Using Linkedserver from sqlserver to oracle

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

SQL Server 2000 Forums

SQL Server Development (2000)

Using Linkedserver from sqlserver to oracle

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-17 : 13:41:19

Nehruji writes "Hi,

I am trying to make connection between Sqlserver database and Oracle database(8.1.7). I have executed the following queries and I am getting "Error 7399 -
The OLE Db provider 'MSDAORA' reported an Error"

1. sp_addlinkedserver 'HMS252','Oracle','MSDAORA','HISNET'

HMS252 -is the server where oracle db resides
HISNET - is the name of the sqlnet entry in the sqlserver machine (this is done using NET 8 configuration assistant)

2. sp_addlinkedsrvlogin 'HMS252',false,'sa','scott','tiger'

sa- sql serve login
scott - oracle user name
tiger - password for the user

Please tell me where is the problem?

Thanks

Regards,
Nehruji"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-06-17 : 13:43:40

I've had similar problems with Oracle linked servers, and I got around it by including the full OLE DB connection string as part of the @provider variable:

sp_addlinkedserver 'HMS252','Oracle','Provider=MSDAORA;Data Source=HISNET;User ID=scott;Password=tiger','HISNET'

It is redundant, but give that a try.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources