beautypg.com

Managing data sources – HP Integrity NonStop H-Series User Manual

Page 33

background image

[ODBC]

TraceFlags = 6

TraceStart = 0

TraceFile = trlog

[ODBC Data Sources]

TDM_Default_DataSource = NonStop ODBC/MX 3.x

DS1 = NonStop ODBC/MX 3.x

DS2 = NonStop ODBC/MX 3.x

DataSourceName = Driver

[TDM_Default_DataSource]

Description = Default Data Source

Catalog = CAT

Schema = SCH

DataLang = 0

FetchBufferSize = SYSTEM_DEFAULT

Server = TCP:xxx.xxx.xxx.xxx:xxxx

SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT

SQL_LOGIN_TIMEOUT = SYSTEM_DEFAULT

SQL_QUERY_TIMEOUT= NO_TIMEOUT

[DS1]

Description = Sample Data Source 1

Catalog = DS1CAT

Schema = DS1SCH

Server = TCP:xxx.xxx.xxx.xxx:xxxx

SQLIntervalBehaviour = SYSTEM_DEFAULT

SQLDatetimeRetrieval = SYSTEM_DEFAULT

[DS2]

Description = Sample Data Source 2

Catalog = DS2CAT

Schema = DS2SCH

SQLIntervalBehaviour = SYSTEM_DEFAULT

[DataSourceName]

Driver = NonStop ODBC/MX

Managing data sources

Unix

To add a new DSN entry in the MXODSN or ODBCDSN file, include the DSN and its description.
If the values of the attributes are not specified in the MXODSN or ODBCDSN file, the driver uses
the default values when creating a connection.

Perform the following steps to modify or delete a DSN entry:
1.

Modify the attributes or remove the DSN entry, and save the file.

2.

Restart the application to reflect the changes.

Managing data sources

33

This manual is related to the following products: