WorkspaceManager_Dlg-EditConnectionFormDatabase Connection_AD
Created: Oktober 27, 2017 | Updated: März 05, 2018
| Applies to versions: 18.0, 18.1, 19.0, 19.1, 20.0, 20.1 and 20.2
Now reading version 18.1. For the latest, read: WorkspaceManager_Dlg-EditConnectionForm((Database Connection))_AD for version 21
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 "]".
- Quote Tables - enable to use specific quote characters to quote tables.
- 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.