Open Forum

Expand all | Collapse all

ODBC error IM004

  • 1.  ODBC error IM004

    SILVER CONTRIBUTOR
    Posted 22 days ago
      |   view attached

    We've been running Nav 2017 since Nov 2017 and recently got this error on 2 of the three machines that run the Developer Environment.

    The following ODBC error occurred:

    Error: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

    State ID: IM004

    The two that get this error are running Windows 7. The one that doesn't runs Windows 10. The two that get the error received some Windows updates prior to the error. Developer Env. Isn't run on those computers very often, so it's hard to stay when the error started exactly.

    #NAV2017 #Technical #DevelopmentandTesting

    ​​​​

    ------------------------------
    Regards,

    Robyn Hawthorne
    Magnum Concrete Inc.
    Aldergrove BC
    ------------------------------


  • 2.  RE: ODBC error IM004

    TOP CONTRIBUTOR
    Posted 22 days ago
    Windows 7 has been out of mainstream support for more than 4 years and Microsoft doesn't support running NAV 2017 on it. Extended support for Windows 7 ends in 8 months (January 2020). It's time to move on unless you have a business reason not to :)

    https://docs.microsoft.com/en-us/dynamics-nav/system-requirements-for-microsoft-dynamics-nav-2017

    Short of looking at the Event Log to try and find more detail it's a bit of a generic error. You could try running the development environment as administrator. Or mess around with upgrading / downgrading your ODBC driver.

    ------------------------------
    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX
    ------------------------------



  • 3.  RE: ODBC error IM004

    SILVER CONTRIBUTOR
    Posted 21 days ago
    We've been running Nav 2017 on Windows 7 since Nov 2017 and testing before that. At the time, Nav 2017 was supported to run on Windows 7. We are heading towards upgrading all the workstations to current OS, but we have other software that has been holding us back until now.

    ------------------------------
    Regards,

    Robyn Hawthorne
    Magnum Concrete Inc.
    Aldergrove BC
    ------------------------------



  • 4.  RE: ODBC error IM004

    TOP CONTRIBUTOR
    Posted 21 days ago
    I mean if you're fairly confident that it was because of a Windows update, you can go into Control Panel, (and sorry I don't remember the exact phrasing in Windows 7), Programs and Features -> Installed Updates / Add Remove Programs, and begin selectively uninstalling certain Windows Updates. I wouldn't uninstall any of the security updates, but you can note the KB number for each one. It's a tedious process...uninstall one, restart, check to see if it worked. But it might get you what you need.

    ------------------------------
    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role