When configuring system DSN, you encounter one of the following errors: The setup routines for the IBM Rational XML ODBC Driver could not be loaded due to system error 126

The following steps could help you to solve:

Verify the settings in the Windows registry:

  • Click Start, click Run, type regedit and click OK.
  • In the registry, go to 
    My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM Rational XML ODBC Driver
    and make sure the 
    Driver and Setup
    properties point to the correct file path of ratlxml.dll.
  • In the registry, go to 
    My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
    and make sure 
    IBM Rational XML ODBC Driver
    is found to be installed.
  • In the registry, go to 
    My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
    and make sure the system DSN you are configuring is using 
    IBM Rational XML ODBC Driver
    .

Verify the setting of the JDBC driver path:

  • On the desktop, right-click My Computer and click Properties,
  • On the System Properties page, click Advanced and click Environment Variables.
  • Make sure that 
    $INSTALLDIR\jdk\jre\bin\classic
    is present at the beginning of the 
    PATH
    or 
    Path
    variables of user variables and system variables.