I am trying to connect to an Oracle 11g 64 bit database running on a Linux operating system from SQL2008 R2 running on Windows 2008 R2. Using the Oracle ODBC configuration tools, I can configure my ODBC connection and verify that my connection succeeds (using the Oracle ODBC utility). I am using the Oracle 64 bit driver and have tried the 32 bit version but this does not connect correctly.
When ever I try to connect to the Oracle database or do anything to it within SSIS (or any other part of SQL server) I get the following error :- “Test Connection failed because of an error in initializing provider. Error [IM014][Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the driver and application.”
Does anyone have any ideas on how I can get this connection working correctly?
-------------------------------Posting Data Etiquette - Jeff Moden Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx