WorkspaceManager_Dlg-EditConnectionFormDatabase Connection_AD
Created: 10月 27, 2017 | Updated: 3月 05, 2018
| Applies to versions: 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 3.2, 4 and 5
現在、バージョン 4. をご覧頂いています。最新情報については、バージョン WorkspaceManager_Dlg-EditConnectionForm((Database Connection))_AD の 5 をご覧ください。
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.