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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2005-06-01 : 10:14:30
|
| I'm trying to set up a linked server to an oracle database. I'm using sql server 2000, sp3, running on a windows 2003 server. When I click on the tables/views below the link, I get the following error:---------------------------------------------------------Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005:].----------------------------------------------------------I have this running on windows 2000 servers and I think I've set it up the same way on the windows 2003 server. I have found other references to this problem on the internet, but not a solution that has worked for me. Has anyone else run into this and found a solution? Thanks in advance. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-06-01 : 10:21:34
|
| Did you check through the simple stuff first? Same TNS Names entries on the 2003 and 2000 box? Same OLE DB provider versions? If you try to set up a data source under control panel on the win2k server can you connect?Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
linked server to oracle