Failed to connect using 4.0.34 version

[achettyiitr]

Issue

Getting this particular error for DSN-less connection string for the recent version 4.0.34. It's working with the 4.0.32 version.

('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnect)')

• Simba Spark ODBC Driver
• unixODBC Driver => ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.9.tar.gz

[v-chojas]

Check where your odbcinst.ini is. 4.0.34 came with its own version of unixODBC which might not be looking for the odbcinst.ini in the same place as the one you installed.

[achettyiitr]

Sorry, @v-chojas. I added the description incorrectly. It's working with 4.0.32. Not working with the current released version 4.0.34

[achettyiitr]

Check where your odbcinst.ini is. 4.0.34 came with its own version of unixODBC which might not be looking for the odbcinst.ini in the same place as the one you installed.

I have both the files obdc.ini and odbcinst.ini empty since I am opting for a DSN-less connection string and specifying the Driver as well in the connection string itself. But with the current released version, it was kind of looking for configuration in these files instead of being specified in the connection string itself.

[Atheuz]

4.0.34 is broken because it includes old libraries. I recommend not using it until it is fixed, and instead use 4.0.32.

[v-chojas]

Indeed, avoid '34. It has already caused these problems reported here:
#1082
#1083
#1081
#1079

[TroyWitthoeft]

Reporting in with similar issues.

[v-chojas]

We know. 4.0.34 is broken.

[TroyWitthoeft]

@v-chojas Good luck on the fix! Appreciate the feedback.

[gordthompson]

pyodbc 4.0.35 has been released.