Kbase 22111: [MERANT][ODBC PROGRESS DRIVER]No data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/20/2002 |
|
SUMMARY:
The above error occured when an ODBC test connection is made to a database running locally using the SQL-92 drivers
EXPLANATION:
The installed product on NT workstation 4GL Development.
The connection parameters in the ODBC Data Source Administrator->ODBC Progress SQL-92 Driver setup were as follows
Data Source Name: Progress
Description: Testing
HostName: pcnt
Port Number: <==============Notice the value is blank
Database Name: sports
User ID:
SOLUTION:
The database was being connected to in single user mode when the error appeared.
The solution is to start the database server and put the value in the Port number in the ODBC Data Source Administrator->ODBC Progress SQL-92 Driver setup as shown above.
The 4GL development includes Personal RDBMS (single user local database for development and deployment) for which one can start the Progress server using -S -H -N.
References to Written Documentation: