Connection failure : ODBC Driver Manager not found Error about sqlalchemy-exasol

[nndo1991]

Hi Salma,

A couple pointers/questions:

• The UTF- 8 portion in your connection string has a space, is that a typo?
• Your driver name must be listed in your odbcconfig/odbcinst.ini file, the default driver name is EXAODBC and it's stored in here
• The error suggests the odbcinst.ini file is incorrectly configured or not present. By the way, what system are you using this package on? I was a little confused by the [Microsoft] part as the usual is [unixODBC]

Thanks!

[Salma-Bouzid]

Hi @nndo1991 , thanks for getting back to me.

• The utf-8 was a typo in my issue text and not in the actual code. I am running the code on a windows machine. I installed the
  the ODBC driver from the official website of EXASOL but still the same error shows up.

I also installed the driver you referenced but I still get the same error.
Do you have any more pointers? Much appreciated!

[nndo1991]

Hi @Salma-Bouzid, we haven't tested this tool in Windows so far (whole team here is on Linux or Mac) but it should theoretically work.

Sqlalchemy uses pyodbc internally to establish connections to DBs, and everything in your error points to a driver setup issue. For that I would recommend some tests:

• Use the dockerfiles in this repo (which are unix-based) to build a Docker image and run the code from there
• Go one level deeper and try to connect to your DB straight from pyodbc (see step 5 of this guide)
• Search for pyodbc issues on their repo, I actually had a similar issue to yours and found similar information here

Thanks!

[nndo1991]

Closing this issue since it doesn't seem to be related to code in this repository