Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

TurboCAD has the ability to connect to a database and associate the data with objects. Database connectivity and management is handled through the Database Connection Palette.
Image Removed Image Added

To Create a Database Connection:

  1. Open the Database Connection Palette.
  2. Right click on the DataSources icon and click Add DataSource.
    Image RemovedImage Added

  3. In the Add Datasource dialog type in the name of the new datasource and click OK.
    Image RemovedImage Added

  4. The Data Link Properties dialog will open.
    Image Removed
  5. On the Provider page select the appropriate OLE DB Provider type for the datasource to which you wish to connect. Then click Next.
    Image RemovedImage Added

  6. The Connection page will appear.
  7. Specify the database path and name.
  8. Setup the log on information.
  9. Click the Test Connection button. If the connection is valid the Test Connection Succeeded message will appear.
    Image RemovedImage Added

  10. At this point you can move on to the Advanced and All pages, or click OK.
  11. The features and functions of the Advanced and All pages are network and database specific, and are dependent upon your network and OBDC/OLE DB protocols. Only a person and experienced with your network and database protocols should alter these settings.
    Image Removed Image Added
    Image Removed
    Image Added

  12. After these operations you will see a new datasource object in DataSources tree.
    Image RemovedImage Added

  13. The datasource is not yet connected. Right-click on the datasource and select Connect.
    Image RemovedImage Added

  14. Your database is now connected to TurboCAD as a datasource.
  15. When connected a datasource shows all available tables and views in database.

...

  1. Select a connected datasource in the DataSources tree.
  2. Right-click on the datasource and select Disconnect.
    Image RemovedImage Added

To Re-configure a Datasourse:

  1. Select a datasource in the DataSources tree.
  2. Right-click on the datasource and select Configure. This will open the Data Link Properties dialog.
    Image RemovedImage Added

  3. Make the required changes and click OK.

...

  1. Select a datasource in the DataSources tree.
  2. Right-click on the datasource and select Remove DataSource.
    Image RemovedImage Added

  3. You will be prompted with a warning dialog.

...

  1. 4.If you are clear to proceed click Yes.

Image Removed  Image Added

To Export a Datasourse:

  1. Select a datasource in the DataSources tree.
  2. Right-click on the datasource and select Export DataSource.
    Image RemovedImage Added

  3. This will open Save As dialog.
    Image Removed Image Added
  4. Select a location and name for the datasource, and then click Save.

...

  1. Right click on the DataSources icon and click Import DataSource.
    Image RemovedImage Added

  2. This will start the Open dialog.
    Image RemovedImage Added

    Note: Connect is only available when a datasource is disconnected. Disconnect is only available when a datasource is connected.

...