Windows 2000 ODBC installation issue / fix and work-around

Discussion in 'Setup & Installation' started by Nick Harrington, Oct 5, 2006.

  1. Nick Harrington

    Nick Harrington New Member

    We have uploaded a new SERVER install which (partially) corrects an incorrect ODBC entry when installed upon (only) Microsoft Windows 2000.

    The System Envrionement Variable SystemRoot value for
    • Windows XP / 2003 is C:\Windows
    • Windows 2000 is C:\WINNT

    The InstallShield package installs the Firebird/InterBase ODBC drivers into the system32 folder under the appropriate Windows SystemRoot folder: e.g. C:\WINNT\system32\OdbcJdbc.DLL or C:\Windows\system32\OdbcJdbc.DLL depending upon your version of Windows operating system. This specific DLL is deployed correctly whichever operating system is used. Therefore your ODBC definition and driver location for remr-synapse <u>will</u> operate correctly.

    Under Windows 2000 when InstallShield deploys the DLL library used for ODBC configuration it is INCORRECTLY setting the value of SystemRoot to a target location of C:\Windows\system32\OdbcJdbcSetup.dll. Therefore if attempting to configure the ODBC definition remr-synapse through Control Panel > ODBC, Windows will display the error: "Microsoft ODBC Administrator: The setup routines for the Firebird/Interbase(r) driver ODBC driver could not be loaded due to system error code 126". Helpful, huh!


    To correct the InstallShield error change the value of HKLM\Software\ODBC\ODBCINST.INI\Firebird/Interbase Driver:

    Setup = C:\WINNT\system32\OdbcJdbcSetup.dll

Share This Page