Designing a Custom SQL Statement
114
Chapter 4 - Testing COM Components
4
Also, on the Connection page, check
Allow Saving Password
to allow the password
to be included in the connection string.
Note:
If saved, the password is not encrypted.
5
Click
Test Connection
.
In most cases, it should not be necessary to change any of the default settings on
the
Advanced
or
All
pages. Click the
Help
button for details.
6
Click
OK
to save the OLE DB Connection String and redisplay the Query Builder.
7
Click
Connect
to connect to the database.
Designing a Custom SQL Statement
After you connect to the database, you can design the custom SQL query statement to
be used to retrieve specific data from the database.
If you are familiar with SQL syntax and are familiar with the schema of the database
you are connecting to, you can simply enter your custom SQL query statement in the
SQL text box.
Using the Query Design Wizard
Alternatively, you can use the Query Design wizard to interactively walk you through
the design of your custom SQL query statement. The Query Design wizard helps you
easily create complex SQL query statements by taking you step-by-step through the
design process.
