DTS from Oracle to SQL Server. Need Help !!!

Last Post 14 Feb 2006 09:51 AM by ConKi. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ConKi
New Member
New Member

--
13 Feb 2006 03:40 PM
Good Afternoon,

I am setting up a DTS package to extract data from Oracle 7 to SQL Server 2000.
When I click the Microsoft ODBC Driver for Oracle icon, I got the following error:
'Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description: [Microsoft][ODBC driver for Oracle][Oracle]

I have Oracle Client 9i and MS ODBC Driver for Oracle installed in the client machine.

Any help would be appreciated.

Thank you,

ConKi
ConKi
New Member
New Member

--
14 Feb 2006 09:51 AM
Thank you, rm
I have those drivers installed on the sql server machine.
It seems to me that DTS is looking for the MS ODBC Driver for Oracle.
How do I check if I have the MS ODBC Driver for Oracle installed in the sql server machine???

I have MDAC 2.8 sp2 installed.

Thanks,

ConKi
You are not authorized to post a reply.

Acceptable Use Policy