ODBC connection Setup for MySql
Posted: Mon May 23, 2016 1:47 pm
Hi all,
we are trying to setup a ODBC connection for MySql. It works fine in the lower dev/test env, but when we did the same setup in UAT it is failing with this error below. This is the first time i am seeing this error.compared the libraries between environments. everything is in order. when we test the connection with view data in the ODBC connector, the connection works but when we run the job, i see this error below. I appreciate your inputs.
ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 0: Msg = [DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased. If you wish to purchase a license, then you may use the Driver Manager for a period of 15 days, during which time you are required to obtain a license. You can order a license by calling DataDirect Technologies at 800-876-3101 in North America and +44 (0) 1753-218 930 elsewhere. Thank you for your cooperation. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 812)
we are trying to setup a ODBC connection for MySql. It works fine in the lower dev/test env, but when we did the same setup in UAT it is failing with this error below. This is the first time i am seeing this error.compared the libraries between environments. everything is in order. when we test the connection with view data in the ODBC connector, the connection works but when we run the job, i see this error below. I appreciate your inputs.
ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 0: Msg = [DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased. If you wish to purchase a license, then you may use the Driver Manager for a period of 15 days, during which time you are required to obtain a license. You can order a license by calling DataDirect Technologies at 800-876-3101 in North America and +44 (0) 1753-218 930 elsewhere. Thank you for your cooperation. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 812)