Help Centre

   
 
 

Creating Attaché Server ODBC DSNs

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

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

Configuring Attaché Server ODBC Data Sources

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 Attaché Server ODBC Driver 32/64 and click Finish. Give your DSN a name and complete details of the data connection and user credentials.

Item

Description / Notes

DSN Name

A local name for the Attaché Server ODBC data source for use in connect calls and by the ODBC administrator

DSN Description

Optional descriptive string

Host

Specify the fully qualified domain name on which the Attaché Server is running. If the Attaché Database Server is hosted on the local machine, localhost can be used in this field

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é 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

Sample_Data DSN Example

Item

Example

DSN Name

Test_ODBC

DSN Description

A test ODBC DSN

Host

localhost OR mypc.attachesoftware.com

Database

SAMPLE_DATA

User ID

ODBC

Password

TEST

Service

The name of the service that c-treeACE SQL listens to; typically this is (port) 6597

Preserve Cursor

Leave as default

Client Character Set

Leave as default

Options

Leave blank

Note: The password for ODBC is case sensitive. If you receive an error "-17451 CT - Invalid Password" when trying to connect to your DSN, please check your password and try again.  

Modifying and Deleting c-treeACE ODBC data sources

You can modify or delete a c-treeACE ODBC data source after you add it by invoking the ODBC Data Source Administrator and selecting the c-treeACE ODBC data source you want to modify or delete.

When you modify a data source, the ODBC Data Source Administrator modifies the entry for the data source name you specify. For example, you could modify a c- treeACE ODBC data source to change the user name and password that connections use.

When you delete a data source, the ODBC Data Source Administrator deletes the entry for that data source. (Deleting a data source has no effect on any database, only on ODBC's information.)


REF:  110518  3.7   18.1   ODBC1042