Kbase P187961: No ODBC connect possible, not even the TEST CONNECT from ODBC data source admin
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/19/2011 |
|
Status: Unverified
SYMPTOM(s):
No ODBC connect possible, not even the TEST CONNECT from ODBC data source admin
TEST CONNECT hangs as soon a connect test is triggered
Then at the same time, both client and remote server are 'dead'
_sqlsrv2.exe is dying immediately
BROKER 0: (2525) Disconnecting dead server 2
BROKER 0: (2526) Disconnecting client 150 of dead server 2.
FACT(s) (Environment):
OpenEdge 10.2x
Windows
REMOTE Server starts
SQL client connects to database
CAUSE:
Database was started with -T startup parameter pointing to directory which does not exist
FIX:
Create directory to which -T is pointing to or make sure -T is pointing to directory which exists and the user who started the database has read and write rights to it