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.
| Author |
Topic |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2009-01-28 : 10:50:11
|
| Hi,I've been getting .i want to connect from mssql server 2005 to oracle 10g and getting following message during OPENROWSET.OLE DB provider "MSDAORA" for linked server "(null)" returned message "ORA-12560: TNS:protocol adapter error".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "(null)".ANy advice are welcome. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-28 : 10:51:45
|
| Is your SQL Server 64-bit? |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-01-28 : 11:13:37
|
| I'm wondering how you recieved "ORA-12560: TNS:protocol adapter error" from QA. Anyway, make sure you Oracle services is running and Orcale Listener is started. |
|
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2009-01-29 : 12:52:32
|
| Is your SQL Server 64-bit?Yes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-29 : 14:13:54
|
| Read this:http://www.mssqltips.com/tip.asp?tip=1433 |
|
|
|
|
|
|
OPENROWSET ISSUE