Oracle Connection in DTS
-
I am fairly new to DTS and need to create a connection to an Oracle server. I need to grab data from an Oracle and import into SQL Server at a specific interval.
Does anyone have any articles or can anyone easily explain how I set up the Oracle connection? Do I need to install any Oracle tools on my SQL Server?
Thank you for your help.
-
You'll want the Oracle client tools on the SQL server, and then make sure (depending on the version of Oracle) that you have the correct entries in the registry (see http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B280106 
.Then you'll have to set up the tnsnames entries for the connections. That's it.
-
Why not just use the 'Microsoft odbc driver for oracle' from the connection windows. Connects just as you would an access db. Does not need tns names file to work.
------------------------------
The Users are always right - when I'm not wrong! -
never yet been able to configure that and get it to work right
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply