Creating a Simple Query to a SQL Server Database

To create a query to a SQL Server database and display the data, you need to:

• Connect to an existing SQL Server database.
• Create a data source—Explains how to create a simple query to retrieve all the data from a single table in the database.
• Display the database data in the Grid Viewer.

These tasks assume that:

• SQL Server and GENESIS are installed on the same machine.

• The example SQL Server database, RollerChainManufacturing, has been restored.

  You can find the database in the following location: 

  C:\ProgramData\ICONICS\11\Samples\RollerChainManufacturing.zip

  The zip file contains RollerChainManufacturing.bak, which is the SQL Server backup file that you need to restore. Make sure to add Network Service to the restored database's db_owner role.

• The ICONICS Databases Point Manager service is enabled and running.