DriverConnection

Purpose

Establishes a data source with the raw ODBC connection information. This is the information returned by BrowseConnection.

Note

If you have built a bound columns application (using table and connection FCAS objects instead of code) with a different database, and you would like to migrate to Oracle, you must set the establish connections selection list to manual startup, run something similar to the DriverConnection code example (below) to connect to the database in your Sub Main(), then match the table and column names in the Oracle database to the names in your previous project.

Syntax

DBConnection.DriverConnection (Connection)

Connection

A connection string for the ODBC driver.

Example

The following code can be used in a program to establish a live connection to the Oracle data source, and allocate statements and run queries against it.

Dim cnct As DBConnection

cnct.DriverConnection("DSN=ORACLE;UID=admin;PWD=frisky;ConnectString=MyOracleServerString")