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.
- 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.
- Double-click NQuery.exe.
- Select .
- Select .NET Data Provider for Teradata for the Data Provider.
-
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
Data Source = vixen ; User Id = jackieo ; Password = sVnglass3s ;
- Click Connect.
- 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.
- Click .
- Click .