Administration Guide > Configuring TDV Data Connections > Using the ODBC Driver on Windows > Adding ODBC Data Sources on Windows
 
Adding ODBC Data Sources on Windows
TDV supports the native Windows driver managers. If you need to install the ODBC drivers, see the TDV Installation and Upgrade Guide.
To add an ODBC data source to a Windows machine
1. Select Windows Control Panel > Administrative Tools > Data Sources (ODBC) to open the ODBC Data Source Administrator. Or, when using the 32-bit driver on 64-bit machines, navigate to ...\Windows\SysWOW64\ and run odbcad32.exe.
2. Select the User DSN tab or the System DSN tab.
A User DSN is accessible only to the current user. A System DSN is accessible to all the users on the system and requires special permission to create and modify.
3. Click Add.
4. In the Create New Data Source screen, select the TDV <version> driver, and click Finish.
5. In the Driver Configuration window, enter the following information that is required for configuring the driver:
Field
Description
DSN Name
Name of the data source that the clients refer to. After a DSN is created, its name cannot be changed.
Host
Server name (or IP address) on which TDV is running.
Port
TCP port used to communicate with TDV Server, which must match the port that the server is listening on. With default installation settings TDV listens on port 9401, but that setting should be verified by checking the port setting in the Configuration window accessible through Studio Administration menu:
TDV Server > Client Drivers > Communications > Port
Integrated Authentication
Method for authenticating the ODBC connection: disabled (default), Kerberos, or NTLM.
Kerberos SPN
SPN for Kerberos to use to authenticate the ODBC connection. Ungrayed if Kerberos is selected as Integrated Authentication.
User Name, Password, and Domain
Must be valid within TDV Server. The password is nullable.
NOTE: The ODBC manager may truncate the password at 14 characters.
Datasource
Name of the TDV data source that the ODBC connection accesses.
This entry sets the default scope of client queries to a particular datasource. Querying outside the scope of this data source requires super-qualified tables or stored procedures.
Catalog
Connects with a default data source catalog.
6. Click Refresh to retrieve the catalogs available to this user on the server.
7. Click Test to test the settings in the configuration dialog box.
8. Click OK.
The configured settings you entered are saved, and the data source is added to your machine.