WorkspaceManager_Dlg-EditConnectionFormDatabase Connection_AD
Created: Juli 28, 2015 | Updated: Juni 16, 2017
| Applies to versions: 15.1, 16.0, 16.1, 17.0 and 17.1
Now reading version 16.1. For the latest, read: WorkspaceManager_Dlg-EditConnectionForm((Database Connection))_AD for version 21
Summary
This dialog allows the user to link projects to a database library.
Access
The Database Connection dialog is accessed by clicking Tools » Database Connection in a 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 wish to use a data link file as the source of connection to a database, select this option then click the Browse button 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 the Build button 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 this option 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 this option 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.