Kbase 19501: Visual Basic Connection Syntax to Progress via ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/02/2000 |
|
To connect a Visual Basic (v6) session to a Progress database using the correct ODBC driver please first ensure that you are able to connect through the driver using MS Query (see kbase 17204 for details of this configuration).
Nb. For v9 of Progress, ensure that there is a user ID entry in the ODBC driver setup.
In Visual Basic create a data control and add the following entry to the Connect property of the data control:
ODBC;UID=<username>;PWD=;DSN=<data source name>;DATABASE="Database name"
Thus if the data source name is Progress9dsn, the user is fred and the database is sports:
ODBC;UID=fred;PWD=;DSN=Progress9dsn;DATABASE="Sports"
Now clicking on the RecordSource property of the data control should result in the list of PUB.tablenames which confirms that the connection has succeeded.
References to written documentation:
MS Visual Basic Guide to Data Access Objects 1997
PKB 17204