CADconform for AutoCAD

Configuring the ODBC Data Source

CADconform installs a tutorial database 'CADconform Tutorial' when first installed, which can be used for testing purposes. However, when you wish to start creating your own CAD standards database, it is strongly recommended that a new database and data source are created. This guarantees that if you upgrade CADconform at a later date, it will not uninstall your customisations. There are three types of data source names that can be created from the Windows Control Panel:

  1. User DSN

  2. System DSN

  3. File DSN

CADconform supports all three types of data source, however the simplest and most flexible type to use is the 'File DSN' type, which stores the database configuration settings in a plain ASCII text file. The main advantage of this type of data source, is that the one file can be shared by multiple users on the network, making central administration much easier. User and System DSNs store their settings in the Windows Registry, which means they must be configured and maintained individually for each Client. CADconform Server creates a directory specifically for File DSNs in the CADconform installation sub-directory 'File DSN'.

To create a File DSN data source (recommended):

  1. From the Windows Start menu, choose either:

  1. Go to "About" and ensure that all of the core components are at least version 3.51.xx. If they are not, then install the newest drivers.

  2. Go to "File DSN" and choose "Add"

  3. Choose a driver, for example "Microsoft Access Driver (*.mdb)" and click "Next".

    In some cases, typically with newer versions of Microsoft Office, the system's ODBC driver may be named "Microsoft Access Driver (*.mdb, *.accdb)" and existing File DSNs will need to be updated.

  4. Browse to the 'File DSN' sub-directory in the CADconform installation directory, and create a data source name in that directory.

  5. Click "Create" and enter a file name (eg: "CADconform.mdb") for the database file. This file should be created on the network server so it is visible to every client machine. It is preferable that this database is installed in the existing "Database" directory of the CADconform Server install path.

  6. Click "OK" to confirm the data source and "OK" a second time to close the ODBC window. Your ODBC data source is now configured and ready to use with CADconform.

Copyright 2001-2015 Altiva Software, Inc. Last modified by Matthew Tolmie.