I need to copy data from ORACLE database onto SQL Server Machine and I am planning to use DTS to import the data. Do I need to install any thing on the machine hosting SQL Server? On my personal machine I installed TOAD and when I try to create a DTS package connecting to ORACLE, I am able to connect with out any problem. This is the problem I am getting when I try to connect from the SQL Server machine where no other software is installed except ORACLE.

Thanks in advance -

---------------------------
Microsoft ODBC for Oracle
---------------------------
The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.

You will be unable to use this driver until these components have been installed.
---------------------------
OK
---------------------------

DTS is a client application therefore she looks for everything relative from
the position in which she is started. Even if a package lives on a server,
if you call it from your workstation then the package is executing on your
workstation.



--
--

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


"Narendra" <Narendra (AT) discussions (DOT) microsoft.com> wrote

the machine hosting SQL Server? On my personal machine I installed TOAD and
when I try to create a DTS package connecting to ORACLE, I am able to
connect with out any problem. This is the problem I am getting when I try to
connect from the SQL Server machine where no other software is installed
except ORACLE.
Version 7.3 (or greater) client software installation.

Allan,

Thanks for the reply. How do I install ORACLE client? I read some other posts in this group and read that we need ORACLE client, to be installed on the machine where we are going to connect to ORACLE.

"Allan Mitchell" wrote:

You can get the Oracle client drivers from the Oracle site or your Admin
staff should have the drivers for your installation on CD somehwere under
their desks <g>



--
--

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


"Narendra" <Narendra (AT) discussions (DOT) microsoft.com> wrote

the machine where we are going to connect to ORACLE.