O'Reilly logo

Sams Teach Yourself SQL in 10 Minutes by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 be prompted ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required