Revolving around the core of technology
| 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 |
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 Driver | Description |
|---|---|
| WinSQL Oracle Wire Protocol Driver | Does 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 Driver | Requires 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 Driver | Requires 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 Oracle | Requires Oracle client on the machine. Before connecting through WinSQL see if you can connect to your server using a native tool like SQL/Plus |
Do you have a helpful tip related to this document that you'd like to share with other users?