Hi,

I want to create a pipeline that will execute some queries on a MySQL database but it's a community version, so the datadirect driver provided with pipeline pilote is not working.

So I installed the one from MySQL, opened the ports and set the correct rights.

Then i tried to configure the odbc.ini file (Pipeline Pilot server is running on a linux machine), I used a SQL Open Connection component and I get an error :

Error logging into data source with connection string 'DSN=MySQL DB;UID=user;PWD=*****;': [IM003] [DataDirect][ODBC lib] Specified driver could not be loaded

I got the same error by filling in the informations directly inside the Data Source of a SQL Select component.

odbcinst.ini:

[MySQL DB]
Driver=/usr/lib64/libmyodbc5.so

The driver is located in /usr/lib64/libmyodbc5.so

odbc.ini:

[MySQL DB]
Driver=MySQL DB
Description=MySQL driver
server=address-of-server
port=3306
user=
password=
Database=mydb
socket=/var/lib/mysql/mysql.sock

There is an old post in the forum, from which i wrote these configurations files, but it's still not working.

Any help is welcome,

Many Thanks.

Fred