|
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 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 |
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? Please add it below. Your name and tip will appear at the
end of the document text.
|