Oracle Error

#1

Hello,

I keep getting this error and I need to know how to fix
this. There are computers that can run the DTS package and
others that get the following error message:

The ORACLE client and networking components were not
found. These components are supplied by the ORACLE
Corporation and are part of the ORACLE version 7.3 or
higher client software installation.

Thank you for your help.

#2

When do you get this? At design time? In a job ?
It is telling you that you need the Oracle ODBC drivers loaded onto the
PC/Server that runs the package. Oracle provide these and they do work.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Brandon" <bkc5 (AT) cdc (DOT) gov> wrote

Quote:

Hello,

I keep getting this error and I need to know how to fix
this. There are computers that can run the DTS package and
others that get the following error message:

The ORACLE client and networking components were not
found. These components are supplied by the ORACLE
Corporation and are part of the ORACLE version 7.3 or
higher client software installation.

Thank you for your help.

#3

There should be an Oracle directory in Start | Programs

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Brandon Campbell" <bkc5 (AT) cdc (DOT) gov> wrote

Quote:

Alan,

I get this message on computers trying to execute the package. The DTS
package works properly from several computers but we have a couple that
do not seem to have these drivers. I am trying to figure out where they
are located on the computers that do work.

Thank you for your help.

Brandon H. Campbell
Database Administrator
CDC/NIOSH

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Oracle Error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Oracle Error - 12-03-2003 , 09:02 AM

Re: Oracle Error - 12-03-2003 , 10:28 AM

Re: Oracle Error - 12-03-2003 , 11:42 AM