BrowseConnection

Purpose

Calls against an ODBC driver or data source to determine which arguments are required to connect.

Information is returned in the connection's ConnectionString property, and is useful when connecting to an ODBC database for the first time. This same information states what data is required to establish a connection. The normal connection method used in FCAS is OpenConnection, which takes the three arguments for normal data sources.

Syntax

DBConnection.BrowseConnection (String)

String

Most ODBC data sources have a maximum of three arguments for String (DSN, UserID, and Password). Oracle and other enterprise databases may require a minimum of four arguments for String (DSN, UserID, Password, and ConnectionString).

Example

Dim cnct as DBConnection

cnct.BrowseConnection ("DSN=ORACLE") 'Oracle data source

Print cnct.ConnectionString

UID:Login=?,PWD:Password=?;ConnectString: Connection String=?;

'string returned from the driver indicating which parameters are required

REM

'the format of the string returned from the driver indicating which parameters are required is (KEYWORD:DESCRIPTION=VALUE)