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 Vantage.
- 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 Vantage system)
- User Id = username (the logon name by which the user of this client computer accesses Vantage)
- Password = password, the password for the username
For example, to connect to database vixen with username jackieo and password sVnglass3s, type:Data Source = vixen ; User Id = jackieo ; Password = sVnglass3s ;
- Click Connect.
- Type Select Date; in the SQL Command pane and click Execute.The Vantage system you connect to returns the current system date in the Command Result pane.
- Click .
- Click .