Page 1 of 1

Error during modify existing TI Data Source

Posted: Thu Aug 17, 2017 4:08 am
by hadzri712
Hi,

I encounter error while changing my data source connection at existing TI process.

Currently I am using Oracle 11g database and moving to Oracle 12c database. Client connection has been install/setup and it work fine using normal SQL developer(direct query). Even creating new TI, I able to select and query the new Oracle 12c DB connection/data.

The issue only exist during modify the current existing TI process that connect to data source 11g. Error log as per below.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
15624 [4f] ERROR 2017-08-17 02:17:03.044 TM1.SQLAPI IM003Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient12Home1, E:\Oracle\product\12.1.0\client_1\BIN\SQORA32.DLL).
15624 [4f] ERROR 2017-08-17 02:17:03.044 TM1.SQLAPI E16) Cannot connect to ODBC data source "ICSS TEST" IM003Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient12Home1, E:\Oracle\product\12.1.0\client_1\BIN\SQORA32.DLL)..
15624 [4f] ERROR 2017-08-17 02:17:03.044 TM1.SQLAPI 08003[Microsoft][ODBC Driver Manager] Connection not open
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Kindly need advice.

Re: Error during modify existing TI Data Source

Posted: Thu Aug 17, 2017 6:44 am
by gtonkin
May be worthwhile checking that you are connecting to the 64-bit Oracle/ODBC drivers-assuming you are running 64-bit TM1.