WorkspaceManager_Dlg-EditConnectionFormDatabase Connection_AD
Created: 1月 16, 2023 | Updated: 1月 16, 2023
| Applies to version: 21
This document is no longer available beyond version 21.0. Information can now be found using the following links:
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.