Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joanne
Starting Member
46 Posts |
 Posted - 2006-05-30 : 08:51:46
|
| Hi,Please, I need your help.I am a junior dba sql server and I want to know if I must install oracle client to connect to an oracle database, with Oracle Provider for OLE dB. I want to create a DTS which will run every week and will transfer an oracle table into a sql server table.Thanks in advance! |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-05-30 : 09:13:55
|
| Hi,You don't need to install oracle client but you need to create system DSN and you need to install oracle ODBC driver.Thanks SanjeevOH Cleveland |
 |
|
|
joanne
Starting Member
46 Posts |
Posted - 2006-05-30 : 10:19:50
|
| this in the case when i`ll use odbc, not ole db.thanks |
|
|
|
|
|
|
connect to oracle with or without oracle client