Skip to content

SQLConnect Command

SQLConnect

Obsolete

Refer to the SQLConnect method in the cSQLHandleManager class.

SQLConnect [sDriver sConnectString] To hdbc

The SQLConnect command will return a handle to a database connection (hdbc). You need to specify the driver to use and the server to connect to. If the driver and/or connect string were already specified in SQLSetConnect, they may be omitted.

To get a handle to a connection to a DB2 server, you could use the following commands:

SQLSetConnect "DB2_DRV" "DSN=CompanyServer;UID=John;PWD=Secret"
SQLConnect To hdbc
SQLConnect "DB2_DRV" "DSN=CompanyServer;UID=John;PWD=Secret" To hdbc