February 22, 2016 at 3:42 am
Hi,
I have been trying to create a link server connection from management studio to mysql and it is proving to be a nightmare :w00t::w00t::w00t:
I have tried downloading the ODAC 12c (which i really dont have a clue what it is) and every other connector I found on the internet.
I also tried to install the connector manually as I still do see it on the registry. And that doesnt work either, it tells that i have the wrong version (I tried both) or that I am missing something else.
I also tried to make a ssis connection and also have no luck.
can someone please help me to get connected to myslq using a linked server connection.
pretty please :blush:
thanks
astrid
February 22, 2016 at 5:48 am
Thanks for your reply.
I have installed drivers but they don't show on the management studio when I try to create the linked server.
Maybe there is something wrong with my installation, or I am installing the wrong drivers.
Help will be much appreciated 😀
February 22, 2016 at 5:51 am
I am sorry I forgot to add, I don't have any permissions from the oracle side, only from my own side.
I need to try to do everything from my side.
thanks
February 22, 2016 at 7:19 am
did you reboot the server after installing the drivers?
February 22, 2016 at 7:43 am
When setting up a linked server to Oracle, I normally install the Oracle client, which can be obtained from the Oracle web site, on the SQL Server Box. (Make sure you download the full client and not the instant client.)
Once the Oracle client is installed, you will need to configure tsnames.ora and sqlnet.ora. The easiest way to do this is to run the Oracle Net Manager program.
When everything looks okay it is usually best to restart the server before setting up the linked server.
February 22, 2016 at 9:44 am
I have just had time to look where the Oracle client is.
It is winx64_12102_client.zip, near the bottom of the following page:
February 22, 2016 at 10:43 am
Thanks for your help. I will tried what you have suggested and update on how it went. 🙂
February 22, 2016 at 1:47 pm
Sorry, I have just read this thread again.
I initially saw 12c and assumed you were trying to connect to Oracle.
You also mention mysql so I am now not sure what you are trying to connect to.
The instructions I gave are for Oracle.
February 23, 2016 at 4:07 am
Good morning.
I am trying to link my management studio 2014 to an oracle db that I only have a view access.
I am trying to copy tables from there.
And I am having issues with the connectors cause it is not letting me connect or they dont show when I try to link the servers.
thanks
astrid
February 23, 2016 at 4:18 am
yes i did and nothing :crying:
February 23, 2016 at 5:34 am
Hey,
I installed what you suggested but I am having a hard time initiating the Oracle Net Manager program.
:w00t::w00t::w00t:
February 23, 2016 at 8:51 am
From the Windows menu:
Oracle - oraClient...
Configuration and Migration Tools
Net Manager
Then expand:
Oracle Net Configuration
Local
Service Naming
Highlight Service Naming and press the Green plus on the left
February 23, 2016 at 8:59 am
hi,
i managed to open that lol, slowly but surely. the problem is that i was supposed to configure tsnames.ora and sqlnet.ora and i dont know what that is (i have an idea, but the first time i saw oracle up close was a week ago :w00t::w00t:)
thanks!!
February 23, 2016 at 11:44 am
There are plenty of articles on how to use Net Manager and set up an Oracle linked server.
Here is the first one I came across:
http://sqlmag.com/sql-server/connecting-sql-server-and-oracle-using-linked-servers
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply