Microsoft SQL Server for Hydra


The installation procedure described assumes that a version of SQL Server is being installed from CD-ROM.

Microsoft has identified a potential issue when running many processes while using SQL Server on NT Servers. This issue is discussed in the Microsoft Knowledge Base article 824422 (UPD: This article is no longer available on the Microsoft website).
http://support.microsoft.com/kb/824422/en-us

SQL Server Connections

From the CD-ROM autorun index window, select SQL Server 2000 Enterprise Edition.

  1. Click the SQL Server 2000 Components button.
  2. In the Install Components window, select Install Database Server.
  3. In the Computer Name window, select the LocalComputer radio button, and click the Next button.
  4. In the Installation Selection window, select the Create a New Instance of SQL Server, or the Install Client Tools radio button and click the Next button.
  5. In the User Information window, type your username and the name of your company, then click the Next button.
  6. In the Software License Agreement window, read the license agreement and, if you agree to the terms and conditions, click the Yes button.
  7. In the Installation Definition window, select the Client Tools Only radio button, and click the Next button.
  8. In the Select Components window, accept the defaults shown and click the Next button
  9. In the Start Copying Files window, click the Next button.
  10. In the Setup Complete window, click the Finish button.

Connection Setup

  1. Open ‘HydraStudio’, and from the Tools menu, select Database Connections. The Querix Connect window is displayed
  2. Click the ODBC tab and then click the ODBC Administrator button. The ODBC Data Source Administrator window is displayed.
  3. Select the System DSN tab, and click the Add button. The Create New Data Source window is displayed.
  4. From the list displayed, select SQL Server, and click the Finish button. The Create a New Data Source to SQL Server window is displayed.
  5. In the Name field, type the name by which you will refer to the data source.
  6. In the Description field, type some text to describe this data source connection.
  7. In the Server field, type or select the name of the SQL Server instance that you want to connect to. To complete the test this can be ‘localhost’.
  8. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog is displayed. This lists the configuration details for the setup you have just created.
  9. To test the connection to the data source, click the Test Data Source button; otherwise click the OK button.

You also need to set the SQLSERVER system variable in your systems environment AND in the GUI server (file inet.env)
for example: SQLSERVER   DSN=%DB_NAME%;UID=%DB_Login%;PWD=%password%