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 |
|
davidc
Starting Member
26 Posts |
 Posted - 2005-02-02 : 09:04:26
|
| When I add a linked server from SQL 2000 to Oracle 9i I get an OLE DB error. Is there something I need to do, after creating the link and adding the serve login, to make it work? |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-02 : 09:44:10
|
| What is the error You are getting ?Do You have Oracle Client or Oracle Instant Client installed ?rockmoose |
 |
|
|
davidc
Starting Member
26 Posts |
Posted - 2005-02-02 : 09:53:54
|
| ERROR 7399: OLE DB provider 'MSDAORA' reported an error.(OLE DB error trace (OLE/DB provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005) |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-02 : 10:13:31
|
| Do You have Oracle Client or Oracle Instant Client installed ?check: [url]http://support.microsoft.com/kb/280106[/url]rockmoose |
|
|
|
davidc
Starting Member
26 Posts |
Posted - 2005-02-02 : 10:24:15
|
| I will install the Oracle client tools on the SQL server. Thanks |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-02 : 10:45:16
|
| You might want to try the Instant Client. (much smaller footprint)[url]http://www.databasejournal.com/features/mssql/article.php/3371561[/url]rockmoose |
|
|
|
|
|
|
Linked server to oracle 9i