DesignSeries00007.pngDatabase Connection

In the Vectorworks file, connect the database to the file and then select a Key identifier for each data source.

To establish the connection between the database and the Vectorworks file:

  1. Open the Vectorworks drawing. Database connection information is saved in the Vectorworks file.

  2. Select Tools > Database > Manage Databases.

  3. The Manage Databases dialog box opens. Through this dialog box, manage available databases and connect the desired database or databases to the current file.

    DB_manage.png 

  4. Since the connection has not yet been made, the Available Databases list is empty. Click Connect.

  5. The Database Connection dialog box opens.

    DB_connection.png 

  6. Either select the SQLite file, or the named database added to the ODBC manager/administrator earlier; enter a User Name and Password if required, and click OK.

  7. The selected database is added to the list of available databases in the Manage Databases dialog box. The tables associated with the Layout database are listed on the left, with the database table columns listed on the right.

  8. DB_manage_data.png 

  9. Select one of the available database tables; its rows display on the right. Select one of the rows to serve as the Key identifier by clicking in the Use as Key column for that row. The Key column uniquely identifies the data rows in the table. By default, this is one of the columns with unique data, used as a row identifier.

  10. The ability to select the Key depends on the database driver. If needed, click Show Table to display the table’s contents and help select an appropriate Key.

  11. Select the Key identifier for any other database tables. Each table must have at least one column selected as Use as Key.

  12. Click Connect if there are other databases to connect, and identify the Key for each additional table.

  13. Once the database tables have been selected and connected, and the Key identifier(s) set for each table, click OK.

The data sources have now been properly connected and identified for the file.

If the connection to the database becomes out of date, select the database and click Renew Connection to re-establish the database connection. Table and column information data is updated.

If there are problems connecting to the database, an error message provides troubleshooting information. Click Details to open a log file in the default text editor application. The log file provides further information to help diagnose connection errors.

~~~~~~~~~~~~~~~~~~~~~~~~~

Database Setup

Record Format Database Connection

Object Database Connection

Specifying Update Settings

Database-Vectorworks Communication

 

vectorworks.net