altium连接oracle,Online Documentation for Altium Products

The Database Connection Dialog.

Summary

This dialog provides controls related to database connection, the designer can link the project to a database Lib with this dialog.

Access

In SVNDblib Editor or DbLib Editor, run command Tools >> Database Connection to access this dialog.

Options/Controls

Connection Tab

The designer can configure source of connection in this tab.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. This file is referred to as a Microsoft Data Link (.udl) file. Use the Browse button or the drop-down list to obtain a data link file. Click on an existing data link file from the drop-down list or click onBrowsebutton to hook up to a data link file.

Browse -  Click this button to browse to a Data Link File if you wish to use a data link file as the source of connection to a database.

Use Connection String -  A connection string is a string version of the connection information to a database. The information specified in a connection string may vary depending on the specified OLE DB provider. Click on the Build button to update the connection string.

When theUse Connection Stringis enabled, the connection string contains details to connect to a linked database for controlled updating of components' parameters. Click theBuildbutton to define a new connection string to a database.

Build -  Click this button to rebuild the connection string to a database for mapping of components' parameters.

Advanced Tab

The designer can configure advanced settings in this tab.

SQL OptionsQuote Tables -  Enable this option and you can use specific quote characters to quote tables. The specific quote characters used will depend on the database you are using. For example, square brackets [] are only useable in Microsoft databases like Access. MYSQL uses ` character for quoting.

Left Quote Character -  Specify the left quote character. The default is [.

The specific quote characters used will depend on the database you are using. For example, square brackets [] are only useable in Microsoft databases like Access. MYSQL uses ` character for quoting.

Right Quote Character -  Specify the right quote character. The default is ].The specific quote characters used will depend on the database you are using. For example, square brackets [] are only useable in Microsoft databases like Access. MYSQL uses ` 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 are only used.

Most databases have tables and these tables are identified by the table name. Other databases such as Oracle (tm) have tables that also have a prefix called table schema name. You will then need to enable this option to include such tables.

Field Data Type

Specify the data type for new fields.