Data Vault Administrator Guide

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

ODBC Connection String Parameters

You can include the ODBC parameters in the connection string that a client application uses to connect to the Data Vault. Use semicolons (;) to separate the connection parameters in the connection string.

The following table describes the parameters that you can include in the connection string:

Parameter	Description
DRIVER	Path and file name of the Data Vault ODBC driver. Alternatively, you can set the driver parameter to the ODBC driver name in the following format: DRIVER={NUCLEUS ODBC Driver}
DATABASE	Name of the folder in the Data Vault to connect to.
UID	User account to log in to the Data Vault. The user account must be defined in Data Archive.
CONNECTION	Name of a Data Archive connection to the Data Vault. The connection name must match a target connection defined in the Data Archive Workbench.
HOST	Host name of the machine that hosts the Data Vault.
PORT	Port number to connect to the Data Vault.
UTF8DATA	The code page to use for code page translations between the client and the Data Vault. Set the parameter to one of the following options: True. Sets the code page to 65001 (UTF-8). False. Sets the code page to 1252 (ANSI - Latin I).
USEREGIONALSETTINGS	Format to use for date, time, and numeric values. Set the parameter to one of the following options: True. Sets the date, time, and numeric settings to regional setting. False. Sets the date, time, and numeric settings to ISO.
AUTOREFRESH	Configures the Data Vault ODBC driver to commit or roll back all transactions before each SELECT statement so that the ODBC client accesses the most recent version of the Data Vault archive folder. Set the parameter to one of the following options: COMMIT. The ODBC driver commits all transactions before the next query. You can also set the ROLLBACK. The ODBC driver rolls back all transactions before the next query. 0. The Autorefresh parameter is not enabled and the ODBC driver does not commit or roll back transactions before a SELECT statement.
AUTOCOMMIT	Configures the Data Vault ODBC Driver to commit transactions after each SQL command that modifies data such as an UPDATE or INSERT. Set the Autocommit parameter to one of the following options: True. The ODBC driver commits all transactions after an SQL command that modifies data. False. The ODBC driver does not commit transactions after an SQL command that modifies data.
PWD	Password for the user account specified by the UID parameter.

Alternatively, you can include the data source name (DSN) in the connection string.

To use the DSN in the connection string, add one of the following parameters to the connection string.

DSN. Indicates a user or system DSN. Use the following format:

DSN=Data Source Name

FILEDSN. Indicates a file DSN. Use the following format:

FILEDSN=Data Source Name

Parameters set in the connection string take precedence over parameters set in the data source. If the value of the parameter in the connection string is different from the value of the same parameter in the data source, the client application uses the value in the connection string. For example, if the value of UID in the data source is DBA but the connection string contains UID=BOB, the client application uses the value of the connection string UID parameter, BOB.

The following text shows an example of the Data Vault ODBC parameters in a connection string:

DRIVER=C:\WINNT\System32\sando.dll;CONNECTION=serv1_db01;DATABASE=db01;AUTOCOMMIT=True;UID=BOB

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

ODBC Connection String Parameters

ODBC Connection String Parameters