Excel ODBC Connection Error for non MS DB's

MTDave 0 Reputation points
2023-03-06T22:31:36.34+00:00

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.

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2023-03-07T08:24:11.42+00:00

    Hi,

    Based on the error message, the ODBC connected to the Manifold.net GIS databas is not compatible.

    I suggest you try to update the ODBC driver and check the result.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. MTDave 0 Reputation points
    2023-03-08T19:21:07.11+00:00

    Thank you the suggestion. Unfortunately, this solution does not solve my problem.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.