February 15, 2017 at 6:31 am
Dear Folks,
I am trying to connect Oracle source using .Net Providers\Odbc Data Provider.
it shows following error while try to connect source connection
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
But i can able to connect using IMPORT/EXPORT wizard.
kindly do the needful.
regards
Kannan
February 15, 2017 at 7:30 am
Kannan Vignesh - Wednesday, February 15, 2017 6:31 AMDear Folks,I am trying to connect Oracle source using .Net Providers\Odbc Data Provider.
it shows following error while try to connect source connection
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 ApplicationBut i can able to connect using IMPORT/EXPORT wizard.
kindly do the needful.
regards
Kannan
try using the 32Bit ODBC driver. Import/Export Wizard in SSMS will use 32Bit, but default ODBC connection uses the 64bit drivers.
Use: c:\windows\sysWOW64\odbcad32.exe
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 15, 2017 at 11:23 pm
How can i select 32bit ODBC driver as source in SSIS.?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply