Kbase P87163: Progress 9.1D MERANT ODBC connection fails with MS-SQL 2000 on Windows 2000 Server using Netsetup.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
Progress 9.1D
Windows 2000
SYMPTOM(s):
ODBC connection to MS SQL Server 2000 fails.
Error string: Specified driver could not be loaded due to system error 126 (MERANT 3.60 32-BIT Progress SQL-92 9.1D).
Error string: Specified driver could not be loaded due to system error 126 (MERANT 3.60 32-BIT Progress SQL-92 9.1D).
The test connection from the ODBC Data Source Administration works!
Windows 2000 Server
Installed Progress via NetSetup
Microsoft MS-SQL 2000 Server
CAUSE:
Microsoft can not handle mapped network drive when it comes to SQLAgents service.
That is the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC and HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI that MERANT does not point to the mapped drive.
Example:
m:\dlc.
Or:
A Progress parameters with map network drive:
DLC=m:\dlc
instead it should be DLC=\\server\dlc
FIX:
Then the fix would be to uninstall the NetSetup, and re-installs it using UNC for the mapped drive.
Example:
start>run>\\server\dlc\netsetup\setup.exe
<file:///\\server\dlc\netsetup\setup.exe>