Clarion Community Help

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
| **Navigation:**  SQL Drivers >====== Logging in to an SQL server ====== | [[using sql tables in your clarion application.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[sql driver behavior.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

**Automatic Login Dialog**

The SQL Accelerator drivers automatically look for UserName and Password values whenever they access an SQL table. If a UserName and Password have already been supplied, the driver uses those values. If no values have been supplied, the driver prompts for the UserName and Password with the automatic login dialog.

We recommend opening a table at the start of your program so the time devoted to logging in occurs at program start up. Clarion's Application Wizard automatically generates code to do this for SQL Accelerator drivers. However, if you do not use the Application Wizard, you can accomplish the same effect simply by adding an SQL table to the Data / Tables Pad for your main procedure. This automatically generates code to open the table.

Except for the ODBC Acclerator Driver, the automatic Login dialog lets the user specify Username, Password and Database.

In the **Database **drop-down list, select from previously selected hosts. If the **Database **list is empty, you may type in the database name.