A Few Words of Warning

In this example, I'm going to assume that you'll be using Visual Interdev and Microsoft ADO because that's what we have in 232 and what we have support for. If you're doing this on some other platform, you're on your own. As well, be aware that it will probably not be able to be viewed correctly in Netscape.

There are a lot of permissions that need to be set, so if you get some weird error especially of the type "Permission denied" or "Connection Error 800a0bb9" and you can't figure it out in 17 minutes, send me mail with a full description of what happened and we'll see what's going on.

But enough of the caveats.

Mapping a network drive

First, you'll need to map a network drive to where your internet project space will be. If you skip this step, you will not be able to create the project in Interdev. You may be able to avoid mapping the directory if you're not the one who has to create the project, but you'll be accessing the files often enough that it will probably be worth your while anyway.

The project spaces are in the share at \\iinetsrv\cse444_<yourletter>. So right click on "Network Neighborhood", click on "Map Network Drive", pick some drive that's not currently occupied, and then for the path type in "\\iinetsrv\cse444_<yourletter>". Make sure that you've checked yes for reconnect at login, or you'll have to reconnect it the next time that you log in.

Getting started with Interdev

First, start up Visual Interdev using the start, programs, where ever Visual Interdev is; either at that level, under Visual Studio 6.0, or somewhere more cryptic.

The project only needs to be created once. To create the project, choose "New project", and when it prompts you for what type of project you want to make, select "Visual Interdev Projects" in the left panel and "New Web Project" in the right panel.

For the directory in which to create the project, let's assume that you've mapped \\iinetsrv\cse444_x to the I drive. Your project space will be at i:\. You can find your group's iinetsrv space name at the project groups page.
Now click next.

It will ask you what server you want to use, and you want (surprise) iinetsrv. At the bottom it'll ask you if you want master mode or local mode. Ideally, we'd want local mode, but since that seems to be broken at the moment, don't use it. Choose master mode, and click next.

Next it will ask you what theme you want to use. Since none of the themes were loaded when Interdev was installed, don't bother. Click finish, and in mere moments (well, some number of moments that really takes far too long), it'll come back with a new project (we hope, we hope).

At this point you've gotten the project set up so that now it knows what web server it's running on. Now you need to get web server to know to look for the database by

Adding a data connection

Under project explorer, there will be a line with "iinetsrv/[your project name here]", which represents the root of your project. Right click on it and choose "Add Data Connection"

Next a window entitled " Data Link Properties" will come up. You want to choose "Microsoft OLE DB Provider for SQL Server" Hit next. Fill in the appropriate information. Don’t mess with anything else until you have at least one connection working, okay? Follow the wizard.

 

Next, you will have to fill information about the Connection. Do not touch anything but the name unless you know what you’re doing.

Click on "Authentication" and make sure that the passwords are there (there should be little x's) and then make sure that both "Save Design-time Authentication" and "Save Run-time Authentication" are checked. This will save you from having to fill in the password each time you re open Interdev. Now you have a connection. NOTE: This process is somewhat erratic (i.e. it fails for reasons you wouldn’t suspect), so if you can’t get it to work, ask me for help.


Click on Ok.

Congrats! You're almost there! Now add a new ASP page to check to see if it worked:

Next, add a Recordset by clicking on the Toolbox tab in the lower left, then choosing "Design Time Controls" and then dragging a recordset into the ASP page (between the beginning and ending of the body). A recordset is how ASP pages get their data.... if you play with the properties, you'll see that you can either take a whole table or the results of a sql statement. For the moment, just pick a table.

Next, add a Grid (drag it over from the Design Time Controls menu again) below the recordset. Right click on the grid and choose properties. Under the Data tab, you should see choices for which recordset to use (use the one created above), and then once you've selected that, to the right you'll see attributes that you can use. Select some, and click okay. (this is just to test and make sure that all of the connections worked; it doesn't matter what it is). Now, right click on the ASP page, choose view in browser, say okay to anything that it asks, and hopefully, you'll see a page with data!

That's all, folks

From there on in, you're on your own. Enjoy your hacking!