Versions Compared

Key

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

...

To Create a Database Connection:


1. Open the Database Connection Palette.

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

Image Modified

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

Image Modified

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.

Image Modified

6. The Connection page will appear.

Image Modified  

7. Specify the database source. or

8. Use connection String

...

         1. Click Build


          Image Added

         2. Select a File Data Source or Machine Data Source

         Image Modified      

         Image Modified

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

         Image Modified  

          4. Select the Database.

         Image Modified  

9. Setup the Server login information.

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

Image Modified

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.

Image Modified

Image Modified

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

Image Modified

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

Image Modified

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.

Image Modified


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.

Image Modified

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.

Image Modified

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.

Image Modified

3. This will open Save As dialog.

Image Modified

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.

Image Modified

2. This will start the Open dialog.

Image Modified


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