Verifying Database Connectivity: SQL Server Connection Tutorials

Table of Contents

Disclaimer: This post includes affiliate links

If you click on a link and make a purchase, I may receive a commission at no extra cost to you.

SQL Test Connection

This feature enables the user to test if the ODBC connection works.

General

Connection String

In this field an SQL Connection field could be entered.

To escape characters in an SQL connection string you must enclose them between { and } characters (e.g. To escape a password value like;1234, the connection string should containPwd={;1234};. Since Advanced Installer uses formatted fields the syntax will become something like Pwd=[\{][PASSWORD_PROP][\}]; where PASSWORD_PROP public property will be dynamically resolved at runtime to ;1234.)

Use 64-bit ODBC resource

Check this option to test connection against a 64-bit ODBC driver.

Optionally, you can specify a connection timeout (in seconds) for this test. The default is 60 seconds. The timeout can be specified through the Windows Installer property SqlConnectionTimeout. You can set this property_statically_ (from Properties Page ) or dynamically (from the installer UI - associated with an Edit Control or with a Set installer property value Control Event).

Verbose

In this section you can choose to display the “Please wait..” message box.

Output

Property

The output property is always set to 0 when the connection test fails and to 1 when it succeeds.

Execution

In this section you can specify how the custom action associated with the test operation should run. It could run either in UI sequence or attached to an event.

Did you find this page useful?

Please give it a rating:

Thanks!

Report a problem on this page

Information is incorrect or missing

Information is unclear or confusing

Something else

Can you tell us what’s wrong?

Send message

Fox Shield

Verifying Database Connectivity: SQL Server Connection Tutorials