Open your text editor and create a file named "vb_sql.vb". Create a set of variables in the VB6 file to hold database connection information, including a connection variable, a record variable and ...

In this third example, you use a DSN-less connection to connect to the data source. In this type of connection, you specify all necessary information (the driver, the server, the database name, and ...

Click the "Add" button to create a new connection and start the connection wizard. Click the "SQL Native Client" in the list of drivers. The SQL client is included with the Windows 7 operating system.

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.