Connect 64 Bit SQl2005 to Oracle

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Connect 64 Bit SQl2005 to Oracle

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2008-03-10 : 14:08:26

Gurus,

I found there is no ODBC support for 64 bit (SQL server 2005). Then which is the best way to connect Oracle Datadbase from SQL 2005..?

Thanks
Krishna

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-10 : 14:43:45

They have Oracle ODBC(64-bit) for SQL Server

Check oracle websites and forum.

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2008-03-10 : 15:12:14

Sodeep, Thanks for your reply.I have installed oracle client. But when i am making linkserver i am getting the following error.

Cannot initialize the data source object of OLE DB provider "OrsOLEDB.Oracle" for linked server "RPASTSSERVER".
OLE DB provider "OraOLEDB.Oracle" for linked server "RPASTSSERVER" returned message "ORA-12154: TNS:Could not resolve the connect identifier spcified".(Microsoft SQL Server,Error:7303)

Am i wrong anywhere..?

Thanks
Krishna

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-03-10 : 15:43:47

do you have a tnsnames.ora file in your oracle home that resolves the Oracle SID you are trying to connect to?

google your error http://ora-12154.ora-code.com/

-ec

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-10 : 15:45:31

This is how i fixed problem:

http://forums.oracle.com/forums/thread.jspa?messageID=2123507

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2008-03-10 : 15:54:52

But i cant find 10g release2 for 64bit anyware..?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-03-10 : 17:43:32