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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2007-08-31 : 09:35:20
|
| Hello All,Does anyone know what I’m doing wrong or what I need to add to the following scripts? I created a linked server that connects to Oracle 9.2.0.7 by executing the below scripts in Query Analyzer, when I tried to access it I get the below error:Error 7399: OLE DB provider 'MSDAORA' reported an error.OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].Scripts used:exec sp_addlinkedserver 'connection1', 'Oracle', 'MSDAORA', 'connection1'exec sp_addlinkedsrvlogin 'connection1', false, 'QLS\sfa01', 'user_name', 'password'Please advice. Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 15:34:31
|
| Try install Oracle client onsql server then create linked server with Oracle's provider or odbc provider. |
 |
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2007-09-04 : 11:14:05
|
quote:
Originally posted by rmiao
Try install Oracle client onsql server then create linked server with Oracle's provider or odbc provider.
Thanks Rmiao for the response but that was already done. Do you have any other suggestions? Please advice. Thanks. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-04 : 11:23:54
|
quote:
Thanks Rmiao for the response but that was already done. Do you have any other suggestions? Please advice. Thanks.
What happened when you did this? If you installed Oracle Client and the ODBC driver where you able to successfully test making a connection with SQLplus?------------------------Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-04 : 23:11:46
|
| Did you get same error with those providers? |
|
|
|
|
|
|
Connecting to Oracle via Linked Server error