KB#00643-Overview of how to setup the Visual PRO/5 SQL Engine to communicate with an external ODBC Driver
Title:
Overview of how to setup the Visual PRO/5 SQL Engine to communicate with an external ODBC Driver
Description:
To accomplish this, you'll need an ODBC driver which provides an interface between the third-party database and Visual PRO/5. The steps are:
1. Install the third-party ODBC driver according to the manufacturer's directions.
2. From within Windows, use the ODBC Administrator to define a data source for the third-party database.
3. Add a line to your CONFIG.BBX to allow access to SQL. This line simply reads:
sql
and might be in your CONFIG.BBX by default, but might be commented out (with a # at the beginning of the line). The SQL line may optionally specify a path to the SQL.INI text file as in:
sql=c:\basis\vpro5\sql.ini
4. You can now use the SQL functions within Visual PRO/5 to access the database. For example, you should be
able to execute:
>print sqllist(0)
and receive a list of data sources defined in the ODBC administrator under Windows. You can then open a data source by entering:
>sqlopen(chan)"database_name"
For further information on reading and writing to external databases via SQL, see the PRO/5 Commands Manual.
Last Modified: 07/10/1998 Product: Visual PRO/5 Operating System: N/A
BASIS structures five components of their technology into the BBx Generations.