The CONNECT statement is required when connecting to OLE DB providers by way of the SQL Pass-Through Facility. Note: Not all of these engine-connection options are supported by all OLE DB providers.

dbms-name identifies the database management system to which you want to connect. You must specify a DBMS name, which is listed in your DBMS chapter. You may also specify an optional alias in the ...

Create a set of variables in the VB6 file to hold database connection information, including a connection variable, a record variable and a string variable to store and send SQL commands:Dim ...