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.

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