Database Connection

   The Database Connection dialog

Summary

The Database Connection dialog provides controls to link projects to a database library.

Access

The Database Connection dialog is accessed by clicking Tools » Database Connection in the Database Editor (.SVNDbLib or .DbLib).

Options/Controls

Connection Tab

• Source of Connection
  • 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, referred to as a Microsoft Data Link file. If you want to use a data link file as the source of connection to a database, select this option then click Browse to open the Select Data Link File dialog or use the drop-down to search for the desired .udl file. 
  • ​Use Connection String - select this option then click Build to open the Data Link Properties dialog to rebuild the connection string to a database for the mapping of components' parameters. The information specified in a connection string may vary depending on the specified OLE DB provider. ​

Advanced Tab

• SQL Options
  • Quote Tables - enable to use specific quote characters to quote tables.
    • Left Quote Character - specify the left quote character. The default is "[". 
    • Right Quote Character - specify the right quote character. The default is "]". 

• 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 only are used.

• Field Data Type - specify the data type for new fields. For example, TEXT(N) or VARCHAR(N) can be used for MS Access or MySQL databases; VARCHAR2(N) can be used for Oracle databases.