Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Link to SQL Server
Do I need to do anything on the SQL server side if I want to put some tables into SQL server from Oracle DB? In the past, I wasn't able to put Oracle client(which includes the provider) on the SQL server to allow it "talk" to Oracle. This time I'm planning to set up an Oracle to push...- zhongd
- Post #5
- Forum: Oracle: All versions
-
Connection to Oracle
Do you mean I have to export to a third DB from Oracle, then what should it be? Thanks! -
Connection to Oracle
Does anyone know how I can connect MySQL to an Orcale database to run some distributed queries or import data? Thank you in advance! -
Problem importing data from Oracle using scheduled DTS package.
I used OLEDB Oracle provide to run a scheduled DTS job, got an error saying the Oracle client is needed. I then used the ODBC Oracle driver, I got the job running forever and never ends. Using either of these I was able to run the DTS package right away but not as a scheduled job. Please help...- zhongd
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Linking SQL7 to Oracle
Problem import data from Oracle using scheduled DTS package. I used OLEDB Oracle provide to run a scheduled DTS job, got an error saying the Oracle client is needed. I then used the ODBC Oracle driver, I got the job running forever and never ends. Using either of these I was able to run the...- zhongd
- Post #4
- Forum: Microsoft SQL Server: Programming
