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 |
|
putane.sanjay
Yak Posting Veteran
77 Posts |
 Posted - 2007-01-04 : 05:59:18
|
| Hi Im my system sql server 2000 is installed in another system oracle is installed IT IS IN NETWORK & I CAN PING HIS SYSTEMhostname of the oracle system is 'srinivas' database name and the instance name is 'firsttek' i used this query to link exec sp_addlinkedserver 'ora_link2','oracle','MSDAORA','srinivas\firsttek'EXEC sp_addlinkedsrvlogin 'ora_link2',FALSE,NULL,'srinivas','srinivas'iam getting error :7399 oledb MSDAORA reported an erroroledb provider 'MSDAORA' idbinitialize initialize returned 0x8000405 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-04 : 07:36:33
|
| 1. Have you got the right Oracle ODBC/OLE driver installed?2. I didn't think the linked server bit works for SQL->Oracle....I thought you had to use OPENROWSET or similiar....(I'm open to correction on this bit)3. Might be useful to check on www.dbforums.com as I'm told they have oracle experience over there. |
 |
|
|
|
|
|
SP_ADDLINKEDSERVER