Kbase P18512: Cannot make any ODBC or JDBC connection to SQL-92 Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/1/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Cannot make any ODBC or JDBC connection to SQL-92 Database
Getting the errors Invalid attribute in connection string and Database not started when connecting to SQL-92 Database
Invalid attribute in connection string
Database not started
Database is started successfully using _mprosrv.exe
CAUSE:
SQL-92 Required Environments are not set correctly
FIX:
Use proserve instead of _mprosrv.exe to start the database which sets the required environment variables
The reason is because proserve is a script that contains all required Environment Variables for SQL-92. If you want to use _mprosrv.exe executable, you may want to set manually the Environment Variables for SQL-92. Environment Variables are all mentionned in the "proserve" script.