Open System Services ODBC/MX Client Driver (SQL/MX 3.x)

Configuring Client Data Source Attributes for
ODBC/MX Connectivity
HP NonStop Open System Services ODBC/MX Client Driver—640328-001
2-7
Example ODBCDSN file
Example ODBCDSN file
The following example shows an ODBCDSN file that defines connections to three
client data sources, TDM_Default_DataSource, DS1, and DS2.
In this example, the attributes Catalog and Schema for data source DS1 are defined
as DS1CAT and DS1SCH.
[ODBC]
TraceFlags = 6
TraceStart = 0
TraceFile = trlog
[ODBC Data Sources]
TDM_Default_DataSource = NonStop ODBC/MX 3.0
DS1 = NonStop ODBC/MX 3.0
DS2 = NonStop ODBC/MX 3.0
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
[DS2]
Description = Sample Data Source 2
Catalog = DS2CAT
Schema = DS2SCH
Server = TCP:172.31.41.214/61000
[DataSourceName]
Driver = NonStop ODBC/MX