MySQL connection on Ubuntu

Lancer · 03-06-2021 09:14 PM

Im trying to do a mysql connection on my ubuntu server.
I've installed MariaDB and can connect from terminal and remote without any issue.
But Im always getting this error: : [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

Config I use

Code:

IP=127.0.0.1

    User=project

    Pass=password

    Database=testdb

    Driver=`/usr/lib/x86_64-linux-gnu/libodbc.so`

Code:

Code:

EE::SQL m_SQL;

    if (m_SQL.connectMySQL(g_pConfig->ip, g_pConfig->database, g_pConfig->user, g_pConfig->pass, &message, 0, g_pConfig->driver) == false)

    {

        Exit(S + "Error: " + message);

    }

Server: Ubuntu 20.10

Anyone an idea how to fix this issue?
Could not find anything on google

Houge · 03-07-2021 01:47 AM

Please check an example of the driver name here:
https://www.esenthel.com/?id=doc#API/Net/Sql

(driver name is not the path to a library file)

**Esenthel** · 03-07-2021 03:37 AM

https://stackoverflow.com/questions/5547...ct-when-co
Sounds like this is a problem of SQL / OS configuration.
If you can't fix it, for easy life you can switch to sqlite (no installation necessary) or another database.

Lancer · 03-07-2021 02:11 PM

Thanks.
I managed to fix this issue by installing unixODBC from source and configure the odbcinst.ini like here https://mariadb.com/kb/en/creating-a-dat...ectorodbc/

MySQL connection on Ubuntu
Author	Message