Database Connection

Parent page:  WorkspaceManager Dialogs

Summary

This dialog provides controls related to database connection, the designer can link the project to a database Lib with this dialog.

Access

In SVNDblib Editor or DbLib Editor, run command Tools >> Database Connection to access this dialog.

Options/Controls

Connection Tab

The designer can configure source of connection in this tab.

• Use Data Link File - A connection string is a string version of the connection information to a database and can be saved as a separate file with a .udl extension. This file is referred to as a Microsoft Data Link (.udl) file. Use the Browse button or the drop-down list to obtain a data link file. Click on an existing data link file from the drop-down list or click on Browse button to hook up to a data link file.
   
• Browse -  Click this button to browse to a Data Link File if you wish to use a data link file as the source of connection to a database.
   
• Use Connection String -  A connection string is a string version of the connection information to a database. The information specified in a connection string may vary depending on the specified OLE DB provider. Click on the Build button to update the connection string. 
  When the Use Connection String is enabled, the connection string contains details to connect to a linked database for controlled updating of components' parameters. Click the Build button to define a new connection string to a database.
   
• Build -  Click this button to rebuild the connection string to a database for mapping of components' parameters.

Advanced Tab

The designer can configure advanced settings in this tab.

SQL Options

• Quote Tables -  Enable this option and you can use specific quote characters to quote tables. The specific quote characters used will depend on the database you are using. For example, square brackets [] are only useable in Microsoft databases like Access. MYSQL uses ` character for quoting.
  
  
  • Left Quote Character -  Specify the left quote character. The default is [. 
    The specific quote characters used will depend on the database you are using. For example, square brackets [] are only useable in Microsoft databases like Access. MYSQL uses ` character for quoting.
  • Right Quote Character -  Specify the right quote character. The default is ]. 
    The specific quote characters used will depend on the database you are using. For example, square brackets [] are only useable in Microsoft databases like Access. MYSQL uses ` character for quoting.
     
• Include Table Schema Names -  Enable this option to include tables with Table Schema Names. By default this option is off and tables with normal table names are only used.

Field Data Type

Specify the data type for new fields.