ISQL/W is the query tool that comes with the SQL Server 6.5 distribution, and is one of the better query tools available for doing your database work. If you don't have access to a SQL server 6.5 release CD, or one of the older Microsoft demo version of SQL 6.5, don't despair; WinSQL is a perfectly acceptable alternative, and is freely available on the internet.

First, let's log onto ISQL/W. If you installed the tools from the CD or the evaluation download, the default location is located at Start Menu -> Programs -> Microsoft SQL Server 6.5 -> ISQL/W, as shown below.

Next, you will be presented with a Connect Server dialog box located in the middle of the ISQL/W window.

Fill out the information in the ISQL/W Connect Server dialog box to reference the PRIMUS SQL server, as is shown below. Make sure that you have the "Use Standard Security" option selected, and type your user ID and password into the fields provided.

When you successfully log in, you will be presented with the query window; a very useful tool for checking and verifying the data you have on the server. This window can be used to do everything from look at data to creating and manipulating tables. When running a query or a SQL command, enter the information directly into the Query window, and then click the green arrow located in the upper right hand corner of the Query window. Also, you can execute commands by hitting CNTRL-E if you are so inclined.

Back to Shared Hosting Support