CODEWITHSUNDEEP
sql-serveroracle11glinked-servermultiple-instances
ptownbro
ptownbro

Reputation: 1288

Linked Server Provider Shows Not Showing in both SQL Server Instances

I have two instances installed on my test server - a SQL Express instance and a SQL Developer instance.

I‌ just installed Oracle Db drivers (for an Oracle Db 11g instance) so that I can link to an Oracle Database using Linked Servers. The new provider ‌‌(OraOLEDB.Oracle) successfully shows in the SQL Express instance. So I'm able to successfully set up my linked server under that instance.

H‌owever, the provider doesn't show under the SQL Developer instance which is where I really wanted to use it.

Since the provider shows under SQL Express, I know the drivers are installed and presumably installed properly (e.g. right bit version, etc...) ‌ H‌ow do I the provider to show under SQL Developer as well.

Upvotes: 0

Views: 1527

Answers (1)

RGME
RGME

Reputation: 104

run 

select @@version

on both instances. Most likely you will find that one SQL instance is 32 bit and the other is 64 bit. The Oracle Driver "bit version" has to match the sql instance "bit version".

Upvotes: 1

Related Questions