15.00 - Verifying Installation of the .NET Data Provider for Teradata - Teradata Tools and Utilities

Teradata Tools and Utilities for Microsoft Windows Installation Guide

prodname
Teradata Tools and Utilities
vrm_release
15.00
created_date
March 2014
category
Installation
featnum
B035-2407-034K
The complete installation of .NET Data Provider for Teradata includes an unsupported ad-hoc query tool NQuery.exe. Use this tool to test successful installation of .NET Data Provider for Teradata and to verify connection to a Teradata Database.
  1. Navigate to %PROGRAMFILES%\Teradata\NET Data Provider for Teradata\version\Samples\Bin\ or %PROGRAMFILES(x86)%\Teradata\NET Data Provider for Teradata\version\Samples\Bin\, depending on the Windows platform.
  2. Double-click NQuery.exe.
  3. Select Connection > Connect.
  4. Select .NET Data Provider for Teradata for the Data Provider.
  5. Enter values in the Connection String box. The connection string is a semicolon-separated list of name=value pairs. It uses the format Data Source = system_name ; User Id = username ; Password = password ; where:
    • Data Source = system_name (the tdpid of the Teradata Database system)
    • User Id = username (the logon name by which the user of this client computer accesses the Teradata Database)
    • Password = password, the password for the username
    For example, to connect to database vixen with user name jackieo and password sVnglass3s, type:

    Data Source = vixen ; User Id = jackieo ; Password = sVnglass3s ;

  6. Click Connect.
  7. Type Select Date; in the SQL Command pane and click Execute.The Teradata Database that you connect to returns the current system date in the Command Result pane.
  8. Click Connection > Disconnect.
  9. Click File > Exit.