WorkspaceManager_Dlg-EditConnectionFormDatabase Connection_AD

Created: Lipiec 28, 2015 | Updated: Czerwiec 16, 2017 | Applies to versions: 15.1, 16.0, 16.1, 17.0 and 17.1

Now reading version 17.0. For the latest, read: WorkspaceManager_Dlg-EditConnectionForm((Database Connection))_AD for version 21

The Database Connection dialog

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 "]".

The specific quote characters used will depend on the database being used. For example, square brackets ([ ]) are only valid in a Microsoft database, such as MS Access, while MySQL uses the "`" character for quoting.

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.

Most databases have tables that are identified by the table name. Other databases, such as Oracle, have tables that also have a prefix called table schema name. This option must be enabled to include such tables.

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.

Wersja do wydruku

If you find an issue, select the text/image and pressCtrl + Enterto send us your feedback.