Running Table Viewer Sample Project without Visual Studio

Run the Table Viewer Sample Project without Microsoft Visual Studio.

1. Open a DOS prompt and go to the appropriate sample directory under <install directory>\Samples.
2. Add the directory with .NET Framework 2.0 binaries to your system path.
3. Verify that the dll directory under Adaptive Server ADO.NET Data Provider installation directory is included in the system path and the LIB environment variable.
   The default installation directory is C:\Sybase\DataAccess\ADONET\dll for Adaptive Server ADO.NET Data Provider, 32-bit and C:\Sybase\DataAccess64\ADONET\dll for Adaptive Server ADO.NET Data Provider, 64-bit.
4. Compile the sample program using the supplied build script build.bat.
5. To run the program, enter:

   tableviewer.exe

6. In the Table Viewer dialog box, supply connection information to an Adaptive Server with pubs2 sample database installed.

   Click Connect.

   The application connects to the Adaptive Server pubs2 sample database.

7. In the Table Viewer dialog box, click Execute.

   The application retrieves the data from the authors table in the sample database and puts the query results in the Results DataList.

   You can also execute other SQL statements from this application: Enter a SQL statement in the SQL Statement pane, and then click Execute.

8. Click the X in the upper right-hand corner of the window to terminate the application and disconnect from the sample database.