Main Menu

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.

View BASIS LinkedIN Profile Visit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel