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

[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