Connect Oracle DB from SSIS using ODBC?

0
votes

I have been trying to connect to an Oracle Database using SSIS(Visual Studio) using ODBC as the connection manager.

My OS is Windows 7 (64 bit), Visual Studio 2010 (32-bit) and Oracle 11G is 64 bit.

While connecting to Oracle 11G using Visual Studio via ODBC I am greeted with the following error:

'The specified DSN has an architecture mismatch between driver and application'

This is understandable as Visual Studio is 32 bit and the server I am trying connect to is 64 bit.

Possible solutions?

1
oraclessisodbc

1 Answers

0
votes

Install both the 32 and 64 bit providers for oracle. This will allow you to configure the connection (in 32 bit) and run the package in 64 bit.

Also, check out attunity: https://www.microsoft.com/en-us/download/details.aspx?id=44582

This is a free oracle source and destination component from Microsoft. You'll find that it uses native oracle interfaces and runs much faster than ODBC.

m