Test connection failed because of an error in initializing provider. ERROR [IM003] Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in instantclient_12_1, C:\OracleClient\instantclient_12_1\SQORA32.dll).
I am getting this error when I am trying to connect the Oracle DB using SSIS.
I am able to successfully "test connection" directly from the odbc 32 client from my pc but not from SSIS
Please help, thx in advance to everyone