DTS Error

[john]

I am trying to import data from oracle to SQL, but I get the following error.

"Test connection failed because of an error in initilizing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later software installation."


can anyone tell what drivers I need to install and where can I find them.

Thank You,
john

[Ananth]

I imagine that you'd need to install the Oracle client software on your client, as well as the server, if you plan on scheduling the import job. After installing the client software, you need to configure it to point to your oracle server.



------------
john at 6/25/01 12:02:49 PM

I am trying to import data from oracle to SQL, but I get the following error.

"Test connection failed because of an error in initilizing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later software installation."


can anyone tell what drivers I need to install and where can I find them.

Thank You,
john