Kbase P10632: Error 709 when incorrectly configuring SQL92 ODBC to connect to SQL89 OIB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Trying to connect to Progress Database through ODBC.
Connecting to SQL89 Open Interface Broker
Using Merant SQL92 ODBC Driver
** -P and -U startup parameters require _User file records. (709)
Key violation merant odbc progress driver progress ** -p and -u require _user file records (709)
CAUSE:
In Progress 9.x, if you are using SQL92 you do not need to start an OI Broker.
The OI Broker is an older SQL construct and has been replaced by a newer executable which will automatically launch itself when an attempt is made to connect a SQL92 client to the database server.
FIX:
Correct the Datasource for the ODBC connection to point to the Database Broker service port, not to the SQL89 Open Interface Broker