Attaché/Attaché BI ODBC DSN Administrator

Owned by Daniel Renshaw
Last updated: Mar 31, 2023 by Lewys Eisemann (Unlicensed)

Update 31/03/2023:

Run ODBC Installer, located Attache Directory. Should apply attache driver.

Attaché ODBC DSN Administrator

Create the DSN
  • Launch the Attaché ODBC DSN Administrator application

  • Click File and then New and enter in the following information:

    • Data Source Name (DSN): The name of the DSN
    • Attaché Programs Folder: The file path to the Attaché program folder.
    • Data Folder: The path to the Attaché data folder
    • Login ID: The username of an Attaché user account
    • Password: Your Attaché user account password

  • Press OK when complete

Configure the DSN

  • Highlight the CatalogueLINK DSN name

  • Select View and click All Items

  • Go to File and click ’Select All

  • You may now close the Attaché ODBC DSN Administrator application

Note: It is important to show all items and then to select them all because unselected items will be inaccessible to CatalogueLINK.

This could result in errors when importing from Attaché.

To configure CatalogueLINK to use the DSN see CatalogueLINK for Attaché Classic/BI

Attaché BI ODBC DSN Administrator

Create the DSN

To create a DSN you will need to run the Windows ODBC Data Source Administrator.

  • This can be accessed through Control Panel - All Control Panel Items - Administrative Tools - Data Sources (ODBC).
  • Microsoft Windows has different ODBC Data Source Administrators for its 32-bit and 64-bit operating systems.
  • If you run ODBC Administrator from Control Panel it will launch the version which corresponds to your operating system.
    • To run the 32-bit version under the 64-bit OS, you will need to locate the appropriate executable (odbcad32.exe) which you will find in the WINDOWS\SysWOW64 folder

    If you are using a 32-bit Microsoft Office install to access your Attaché data on 64-bit Windows, create a desktop shortcut to odbcad32.exe to save you finding it every time.

  • Once you invoke the ODBC Data Source Administrator, select the System DSN tab
  • A list of system DSNs will be displayed. Select Add to create a new DSN
  • From the list of drivers displayed, select the c-treeAce ODBC driver and click Finish
Configure the DSN

You will now need to give your DSN a name and enter the details of the data connection and its user credentials:

  • DSN Name: A local name for the c-treeACE ODBC data source for use in connect calls and by the ODBC administrator.
  • DSN Description: Optional descriptive string.
  • Host: Specify the machine name on which the Attaché Server is running. If it is this machine you can use localhost as the machine name.
  • Database:  Name of the database where the Attaché data source resides.
  • User ID: User name and password for connecting to the database – must be a valid Attaché BI login.
    • You can leave these fields blank if you want the user to be prompted when the application connects.
  • Password:  See User ID
  • Service: The name of the service that c-treeACE SQL listens to. Normally (port) 6597.
  • Preserve Cursor:  Leave as default.
  • Client Character Set: Leave as default.
  • Options:  Leave blank.


To configure CatalogueLINK to use the DSN see CatalogueLINK for Attaché Classic/BI