SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Linked server in SQL server (32bits and 64 bits)

804388Oct 11 2010 — edited Oct 11 2010

Hi all.

i have a question about linking oracle server in sql server.
We have a Windows 2008 R2 (64 bits) with a sql server 2005 (32 bits). We have to connect to an Oracle 9 Server via a linked server.
So we have installed Oracle client 10g for 64 bits and tnsping is working fine.
But we cannot connect via a linked server in SQL : we have this error "Msg 7302, Level 16, State 1, Line 1" Cannot initialize OraOLEDB.Oracle"

We have tried with Oracle 10g client installed 32 bits but it doesn't work.

I have read some thread about this problem, but no solution has worked.

Does anyone experienced this problem and does anyone succeeded to make it work ?

Thanks in advance

Ps : we have enabled Allow in Process in Sql Server for Oracle Provider

Edited by: 801385 on 10 oct. 2010 23:12

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2010

Added on Oct 11 2010

12 comments

7,767 views