Kbase 21652: ODBC Errors with Progress 9.1C SQL Server Driver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/12/2008 |
|
Status: Verified
FACT(s) (Environment):
MS SQL Server DataServer
Progress 9.1C
SYMPTOM(s):
SQL Server Driver, version 3.70.00.00 with p1msss16.dll is being used.
SQL ERROR:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named Pipes]
ConnectionOpen[Createfile[]].
SQL ERROR:
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][Named Pipes]
Specified SQL server not found.
SQL ERROR:
Connection failed:
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]
Invalid connection string attribute
Similar errors are seen when connecting through DSN (configured using the Progress 9.1C SQL Server Driver) from client
-08001: [Microsoft][ODBC SQL Server Driver][Named Pipes]
Specified SQL server not found.
-01000: [Microsoft][ODBC SQL Server Driver][Named Pipes]
ConnectionOpen[Createfile[]].
-Failed to connect to the MSS database (6142)
FIX:
In Progress 9.1C with SQL Server Driver, when using the local address (rather than the hostname of the server) in the "Server Name" field, the local address specified should include parentheses around it.
For example:
SERVER NAME - (local)<--, parentheses around the word "local"