Database Connection Palette

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.

To Create a Database Connection:

1. Open the Database Connection Palette.

2. Right click on the DataSources icon and click Add DataSource.

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

4. The Data Link Properties dialog will open.

5. On the Provider page select the appropriate OLE DB Provider type for the datasource to which you wish to connect. Then click Next.

6. The Connection page will appear.

7. Specify the database source. or

8. Use connection String

         1. Click Build

         2. Select a File Data Source or Machine Data Source

         3. Set login info if needed, then press OK.

          4. Select the Database.

9. Setup the Server login information.

10. Click the Test Connection button. If the connection is valid the Test Connection Succeeded message will appear.

11. At this point you can move on to the Advanced and All pages, or click OK.

12. 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.

13. After these operations you will see a new datasource object in DataSources tree.

14. The datasource is not yet connected. Right-click on the datasource and select Connect.

15. Your database is now connected to TurboCAD as a datasource.

16. When connected a datasource shows all available tables and views in database.

To Disconnect a Datasource:

1. Select a connected datasource in the DataSources tree.

2. Right-click on the datasource and select Disconnect.

To Re-configure a Datasource:

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.

3. Make the required changes and click OK.

To Remove a Datasource:

1. Select a datasource in the DataSources tree.

2. Right-click on the datasource and select Remove DataSource.

3. You will be prompted with a warning dialog.

4. If you are clear to proceed click Yes.

To Export a Datasource:

1. Select a datasource in the DataSources tree.

2. Right-click on the datasource and select Export DataSource.

3. This will open Save As dialog.

4. Select a location and name for the datasource, and then click Save.

To Import a Datasource:

1. Right click on the DataSources icon and click Import DataSource.

2. This will start the Open dialog.

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