In order to talk to a database, you'll need to create an ODBC connection on the machine
you are working.
To do this, go to Start->Settings->Control Panel->Administrative Tools.
Choose "Data Sources (ODBC)". Click on "System DSN". (*) Then click on "Add".
At this point, you will be prompted for the driver for which you want to setup
a data source. Choose "SQL Server" (at the very bottom of the list) and click "Finish".
(You will see a dialogue with three fields to fill in.)
Next, specify the name of your database in the first text field.
You can leave the second field blank and pick "ISQL02" in the third.
Click "Next" and choose the second radio button (connecting with SQL Server authentication).
Enter your login and password and click "Next". (The database will be contacted to verify
that you have the appropriate permissions.)
Make sure to select your group database as the default database
(it shouldn't be a problem, because you only have permissions for your database on ISQL02).
Click "Next" and then "Finish".
Finally click "Test Data Source" to make sure everything ran properly. This
should be promptly confirmed. After clicking "Ok" twice, make sure that the name of your
database appears in the listbox. If it does not, that's a sure sign you won't be able to
connect using this system configuration. The solutions are two: try another machine
(maybe one that you know works fine) or try "User DSN" (see below) instead of "System DSN",
keeping all other steps the same.
(*)
"User DSN" means that only you will be able to access this data source, while
"System DSN" means that anyone on that machine will be able to access the data source,
though only if they provide the necessary credentials. A "User DSN" may seem like the
right thing, but it reportedly does not work. If, however, you are not successful with
adding an ODBC connection through "System DSN" (e.g. if you are on a machine where it
cannot be installed properly), we recommend that you try "User DSN" as a last resort.