Tips and Tricks in a world of Mix

 

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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Tag Cloud

%d bloggers like this: