Kbase P38862: Unable to connect from Unix client to SQL Server with error 6142 when name server port is not specif
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/07/2008 |
|
Status: Verified
SYMPTOM(s):
Unable to connect from Unix client to SQL Server
Getting error 6142 when connecting to SQL Server
IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified Failed to connect to the MSS database. (6142).
Using SQL Server DataServer Unified Broker
Connection statement
connect mssholder -db mssdemo -dt MSS -U bob -P bobpass -H host of nameserver -DataService mssbroker1 -Dsrv SVUB,1
FACT(s) (Environment):
Progress 9.1B
Progress 9.1C
Progress 9.1D
SQL Server DataServer
Windows
MS SQL 2000
CAUSE:
Missing -S parameter which indicates name server port.
FIX:
Add and set the -S parameter to the port number assinged to the controlling NameServer (for example, 5162) because -DataService parameter is not 'none'
The connect statement should be
connect mssholder -db mssdemo -dt MSS -U bob -P bobpass -H host of nameserver -S 5162 -DataService mssbroker1 -Dsrv SVUB,1