Using Microsoft Visual Basic

Microsoft Visual Basic 6 provides tools and components for building database client applications. But rather than building an entire application to test your SQL, VB6 includes a Visual Database Manager that can be used to directly test and execute SQL statements. To use the Visual Database Manager do the following:

1.
Microsoft Visual Basic uses ODBC (and DAO) for database integration. To interact with ODBC, an ODBC Data Source must be present before proceeding (see the earlier instructions).
2.
Launch the Visual Basic Development Environment.
3.
Select Visual Database Manager from the Add-Ins menu.
4.
From the File menu, select Open Database and then select ODBC.
5.
Select the ODBC Data Source to connect to. You might ...

Get Sams Teach Yourself SQL in 10 Minutes, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.