Kbase P30264: SQL92 internal error -219901- Error attempting to connect to two databases via SQL-92 and SQL-89
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
Using ODBC for two connections (SQL-89 for v8, SQL-92 for v9) but version 8 OIB broker does not start.
Error attempting to connect to database via ODBC/SQL92
Startup of SQLSRV2 process in database log file shows no Classpath being set.
SQLSRV2 1: CLASSPATH from DEFAULT is:
ODBC testconnect : [Merant SQL92 - ODBC Progress Driver [Progress] -219901]
SQL92 internal error 219901
The CLASSPATH system environment variable points to %DLC%\java\progress.zip
12:10:32 SQLSRV2 1: SQL Server 9.1C.08 started, configuration: "example.defaultconfiguration"
12:10:32 SQLSRV2 1: "defaultServerGroup" started on port 3064, pid 5204 (0x00001454).
12:10:32 SQLSRV2 1: DLC from ENVIRONMENT VARIABLE is: e:\Programme\DLC
12:10:32 SQLSRV2 1: WRKDIR from REGISTRY is: D:\Progress9\temp\
12:10:32 SQLSRV2 1: JDKHOME from REGISTRY is: D:\Progress9\jdk
12:10:32 SQLSRV2 1: JREHOME from REGISTRY is: D:\Progress9\jre
12:10:32 SQLSRV2 1: CLASSPATH from DEFAULT is:
12:10:34 SRV 1: Login usernum 246, remote SQL client. (8873)
12:10:34 SRV 1: Usr 246 set name to pub. (7129)
FIX:
Configure first for version 9 with SQL-92 (run some tests and make sure it works) For the version 8 and the SQL-89, make a batch file for the commands and sets the environment variables to point to version 8 Progress.