beautypg.com

Configuring odbc data sources – Sybase 12.4.2 User Manual

Page 87

background image

CHAPTER 2 Running Adaptive Server IQ

67

3

Click Configure.

4

On the ODBC Configuration dialog box, click Test Connection.

If you cannot access the Data Source, check that you have filled out the
various tabs with correct file and pathnames.

To edit a data source, select one from the list in the ODBC administrator
window and click Configure.

If you need to access Windows NT across a network in order to create an
ODBC data source, see the Adaptive Server IQ Installation and Configuration
Guide
.

Configuring ODBC data sources

This section describes the meaning of each of the options on the ODBC
configuration dialog box, organized by tab.

ODBC tab

Data source name

The Data Source Name is used to identify the ODBC

data source. You can use any descriptive name for the data source (spaces are
allowed) but it is recommended that you keep the name short, as you may need
to enter it in connection strings.

For more information, see the DataSourceName connection parameter in the
Adaptive Server IQ Reference Manual.

Description

You can enter an optional longer description of the Data

Source.

Translator

Choose Adaptive Server IQ 12.0 Translator if your database

uses an OEM code page. If your database uses an ANSI code page, which is
the default, leave this unchecked.

Isolation level

The isolation level for an IQ data source is always

effectively 3. However, the default Catalog Store isolation level is 0.

For more information, see “Isolation levels” on page 302.