Oracle10g(32bit) to SQL 2005(64bit) Connection Issue

Last Post 04 May 2008 12:27 AM by SQLUSA. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Dhanakumars
New Member
New Member

--
03 May 2008 09:38 AM
Hi,
I am migrating DTS packages to SSIS. For time being I am running DTS packages in SQL 2005. One of DTS is puling the data from Oracle 10g to SQL Server 2005. I am using MS OLE DB Provider for Oracle as the provider to connect Oracle. In our development environment both SQL server and Oracle are 32 bit and migration is working fine.
Now, in our production environment, Oracle is 32 bit but SQL Server is 64 bit (OS also win2k3 64bit).
In that scenario MS OLE DB Provider for Oracle is not working.
I am getting following Error Msg:

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 client software installation. Provider is unable to function until these components are installed.

Should I have to install/register any Oracle Driver?
Your suggestions & Solutions are welcome.

Thanks
Dhana
SQLUSA
New Member
New Member

--
04 May 2008 12:27 AM
Check out this KB article:

http://support.microsoft.com/kb/255084

Let us know what happens.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
Dhanakumars
New Member
New Member

--
06 May 2008 12:32 PM
I have already checked this article, and this KB is for ASP to Oracle. Mine is different issue, it is actually problem because of 64bit SQL Server Vs 32 bit Oracle.


Acceptable Use Policy
---