August 23, 2007 at 12:19 am
Hi everybody,
I have designed a DTS package which will migrate a view from Sqlserver 2000 to Oracle.My package is using Microsoft OLEDB provider for Oracle driver for connecting to oracle.Im able to execute this package on the my system ie on the system where sqlclient is installed(Oracle client is also installed on my machine) .But when im doing it on the server im not able to do it.The Connection to Oracle Fails.
I wanted to know in order to connect to Oracle from the server,is it necessary that Oracle has to be installed on the server?.If yes, is it enough if i install oracle client on the server or Oracle Server version has to be installed on Server.
Please suggest me wht should i do know?
Thanks in advance
Regards
Arvind L
August 23, 2007 at 3:20 am
Just the Oracle Client is sufficient.
August 24, 2007 at 6:58 am
Oracle Client needs to be there, but you also need to make sure your SQL*Net configuration is correct and that you've got an entry in your TNSNAMES file.
Not sure if there are tools to automate this stuff, but if you can find the file "TNSNAMES.ORA" on your machine and, if the Oracle Client is installed on the other machine, the corresponding TNSNAME.ORA file there, compare them to see if there is an entry for the server/database that you are trying to connect to. There probably isn't. In that case, check with your admins or whomever to get the connection set up.
August 30, 2007 at 1:19 pm
After the installation of Oracle Client software, reboot the server. Otherwise sql server doesn't seem to recognize until reboot.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply