Windows DSN Configuration
Using the Microsoft ODBC Data Source Administrator
You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process.
Complete the following steps to edit the DSN configuration:
- Select Start > Search, and enter ODBC Data Sources in the Search box.
- Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
- Click the System DSN tab.
- Select the system data source and click Configure.
- Edit the information on the Connection tab and click OK.
Note: For .NET Framework 4.0, the driver distributes Microsoft Visual C++ 2015-2022 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.
Deploying the Provider
To connect using the CData ODBC Driver for Teradata, you must install the Teradata .NET Data Provider into the GAC.
Ensuring Registry Access
The driver stores connection information in the Windows registry. To ensure that the driver can write to the registry, perform either of the following actions:
- Run the calling application as an administrator.
- Connect via a User DSN instead of a System DSN.
Connecting to Teradata
The driver wraps the official Teradata Database driver. You can connect to the CData ODBC Driver for Teradata using the same connection properties, and access the same functionality, as the underlying Teradata driver.
Required Properties
To connect to Teradata, set these properties:
- AuthScheme: Specify your Teradata server's required authentication mechanism: either TD2 (default) or LDAP.
- User: Teradata user username.
- Password: Teradata user password.
- DataSource: Specify the Teradata server name, DBC Name, or TDPID.
- Port: Specify the port the server is running on.
- Database: Specify the database name. If not specified, the driver connects to the default database.