creating link to oracle db - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

creating link to oracle db

Author

Topic

bob123
Starting Member

16 Posts

Posted - 2006-07-12 : 17:26:55

Hi I'm trying to create link to oracle db and keep getting this error when I try to look at the oracle tables from enterprise manager.

error 7399: ole db provider microsoft.jet.oledb.4.0 reported an error
ole db error trace [ole/db provider microsoft.jet.oledb.4.0 idbinitialize::initialize returned 0x80004005:]

I can connect to oracle db from sql server using oracle sqlplus and I have a ODBC connection to db that works.

sql server 2000
os = MS windows server 2003
oracle client 10.2

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-12 : 19:26:37

you are using the Jet OLE DB provider (access database) instead of the Oracle OLE DB provider.

drop and recreate the link. Make sure you select an Oracle driver and you should be fine.

-ec

bob123
Starting Member

16 Posts

Posted - 2006-07-12 : 19:58:56

Hi, thanks for the reply.

I changed the driver to MSDAORA but still get same error

error 7399: ole db provider MSDAORA reported an error

ole db error trace [ole/db provider MSDAORA idbinitialize::initialize returned 0x80004005:]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources