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 |
|
san
Starting Member
26 Posts |
 Posted - 2002-07-18 : 22:00:52
|
| With System DSN, Is it possible to connect to a Oracle/Sybase database running on a UNIX platform ?Also, Is it possible to have a DTS package with the Source connection to a Oracle/Sybase server on Unix and destination connection to a MS SQL server on Win200 ?Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-18 : 22:51:04
|
| Yes, I've done DTS packages connecting to Oracle sources running on Unix, but I got away from ODBC and used the OLE DB provider for Oracle instead. Far fewer problems than ODBC, which I don't think I ever got to work correctly, not reliably anyway. Haven't tried Sybase but I know other people have done it. |
 |
|
|
san
Starting Member
26 Posts |
Posted - 2002-07-19 : 11:25:07
|
| Thanks Rob. Even I feel it would be possible. I wud have tested it, but right now I do not have a Oracle / Sybase running on Unix. |
|
|
|
|
|
|
DSN & DTS