Small company logo:
   History
 
Advertising banner:
 
 Connection.OpenConnection
Home • Help • Customization Tools • FCAS • Language Reference • Connection.OpenConnection
 
Purpose
Opens an ODBC data source connection.
7202010_20004_0.png        Note
This method must be run on any DBConnection object prior to opening statements and executing database operations.
Syntax
DBConnection.OpenConnection (DSN [,Login] [, Password])


DSN
Accepts any string expression that specifies a valid data source name as configured in the ODBC Data Source Administrator.
Login
Accepts any string expression that specifies the data source login.
Password
Accepts any string expression that specifies the data source password.

Example
Sub Main()
        Dim cnct As DBConnection
        cnct.OpenConnection("MyDSN")
'Open the data source "MyDSN"
' Create statements and execute SQL...
' ...
        cnct.CloseConnection    
'Close the connection
End Sub