I am attempting to connect to a Manifold.net GIS database in Desktop Excel 365 via ODBC. Failed connection, Error message as follows.
Details: "ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
This error message has been googled and none of the resolution approaches seem to apply.
I know the the ODBC connection works because have have opened the same Manifold dataset in both MS Access and Tibco Spotfire. This suggests the error lies in Excel. I have used this Manifold ODBC many times without issue. Troubleshooting, I have tried different Excel Trust settings and running a repair on SQL_HANDLE_ENV.
Excel will connect to an Access DB with via ODBC but will not connect to a Manifold or a MySQL DB. MySQL throws the same error when attempting to connect to Excel via ODBC.
Specifics: Windows 11, Manifold and Excel are 64 bit & Manifold provides the ODBC driver
I truly appreciate and help or guidance that this community can provide.