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
