WinSQL » Knowledge base

Document information

Document ID: 809
Subject: Error 126 when connecting to database
Creation date: 7/29/09 4:37 PM
Last modified on: 7/29/09 4:37 PM


Details


You get the following error when connecting to a database.

Specified driver could not be loaded due to system error 126

This error occurs when some DLL files either are missing or are not in your machine PATH when connecting to a database. Note that many databases require a client side library installed and configured on the machine before any client can connect.

You do not need any client DLLs if you are using the "Wire Protocol" driver with WinSQL.

For example. There are several ODBC drivers available to connect to Oracle. The table below lists them.

ODBC DriverDescription
WinSQL Oracle Wire Protocol DriverDoes not require any client libraries. If you are getting error 126 with this driver, unregister and re-register the ODBC drivers in WinSQL. Click Help/Register ODBC Driver on the main menu to re-register the drivers
WinSQL Oracle DriverRequires Oracle client on the machine. Before connecting through WinSQL see if you can connect to your server using a native tool like SQL/Plus
Oracle ODBC DriverRequires Oracle client on the machine. Before connecting through WinSQL see if you can connect to your server using a native tool like SQL/Plus
Microsoft's Driver for OracleRequires Oracle client on the machine. Before connecting through WinSQL see if you can connect to your server using a native tool like SQL/Plus







Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.

Navigation

Social Media

Powered by 10MinutesWeb.com