Tips and Tricks in a world of Mix

Posts tagged ‘SqlServer2008’

Linked Server from Oracle to SqlServer2008

 

The first steps are to create a connection – Linked Server . You have to enter your SqlServer and from there run those commands adjusted to your db.

commands:

exec sp_addlinkedserver ‘doardev’, ‘Oracle’, ‘OraOLEDB.Oracle’, ‘doar_dev’

exec sp_addlinkedsrvlogin ‘doardev’, false, ‘Nessjr\Tzvik’, ‘doar_dev’, ‘doar’

 
Those commands create Linked Server to your Oracle Server and setting the permission of your SqlServer  to the level of permissions of the user you use to connect to Oracle Server(remote server).
Related posts you may find at –
 
 
After creating a linked server (I’ve tried with ‘OraOLEDB.Oracle’ and with ‘MSDAORA’ with the same result for now)
1)check that you have “allow inprocess” in provider you use .
 

when I’m trying to test it I’m getting mistake

 

 

 

and also when I’m trying to open some tables :

the  question is what missing for the proper connectivity and migration .

The answer is

Go to Linked Server –> properties –> security –>

Go back , Right Click on the linked Server “Test Connection” – it should work!

Advertisements

Tag Cloud

%d bloggers like this: