 |
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)
|  |