Kbase 17776: Error 126 when Configuring ODBC datasource MSSQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/10/1998 |
|
Error 126 when Configuring ODBC datasource MSSQL Server
What causes error 126 when establishing ODBC datasource?
--------------------------------------------------------
The following error may occur when trying to establish an
ODBC datasource to MSSQL with Intersolv's driver through
the ODBC adminstrator on your PC.
"The setup routines for the Intersolv 3.00 32-bit SQL Server
ODBC driver could not be loaded due to system error code 126."
Intersolv provides a database driver for interfacing with MSSQL
that is dependent on two underlying Microsoft-supplied API
protocols, namely DB-Lib and Net-Lib. Intersolv, however, does
not re-package these elements of the MSSQL product with
their database drivers; therefore, you (the user) need to get the
Db-Library and Net-Library DLL's onto the client
machine from which you wish to set up an ODBC client connection.
How to locate these files?
--------------------------
If you call Intersolv tech. support, they will redirect your call
to Microsoft since the DataDirect SQL Server drivers require
Microsoft client software in order to operate. One of the two
options listed below should also rectify the problem in
a more direct fashion:
Option 1: The missing Dll's are supplied when you purchase and
install the MSSQL database product from Microsoft. If you have the
install CD for the MSSQL database product, you can download the
desired DLL's via the SQL Client Configuration Utility directly
onto the client machines.
Option 2: Go to the install location of your MS SQL server and scan
the MSSQL installation directories to find the DB-Library DLL called
"NTWDBLIB.DLL". Copy this DLL over to the /winnt/system32
directory on your client machine. Now do the same
for Net-Library however the specific DLL you want to install is network
protocol and machine-type dependent. The DLL's are listed in the order
from left to right as NT, Windows, and DOS respectively:
TCP/IP - copy "DBMSSOCN.DLL", "DBMSSOC3.DLL", or "DBMSSOC.EXE",
Named Pipes - copy "DBNMPNTW.DLL", "DBNMP3.DLL", or "DBNMPIPE.EXE".
IPX/SPX - copy "DBMSSPXN.DLL", "DBMSSPX3.DLL", or "DBMSSPX.EXE"
Banyan VINES - copy "DBMSVINN.DLL", "DBMSVIN3.DLL", or DBMSVINE.EXE"
Notes:
You must use the DB-Library and Net-Library appropriate for the Version
of MSSQL you have installed and to which you are trying to connect. Use
version 6.0 DLL's on the client if you're connecting to MSSQL 6.0, 6.5 if
connecting to 6.5, 7.0 when 7.0 becomes available, etc.
Progress Software Technical Support Note # 17776