Peter J. Boettcher — Tue, 21 Aug 2001 13:33:41 +0000

If you're on Windows NT you can install IIS 4, just make sure you have at least:

Service Pack 3 or higher installed
Internet Explorer 4.0 or higher installed

Then you can install the Windows NT Option pack which installs all the necessary files. Just go to this link http://www.microsoft.com/ntserver/techresources/webserv/option_pack4.asp , the link to download the option pack is at the bottom of the page.

DizzEAngel — Tue, 21 Aug 2001 13:21:58 +0000

I do have a personal web server, but I have to have a connection in order to tweak it. Unfortunately, at work, they won't allow most people to be on the ineternet, so there's no way i can do that.

What about if i'm using Windows NT, and have a local intranet. What do I do then? This is sooo crazy.

~DizzE

Peter J. Boettcher — Thu, 16 Aug 2001 14:17:01 +0000

Yes, you have to be running some type of web server software for ASP to function. If you're on Windows 2000 Professional then install the IIS files (go to add/remove programs in the control panel, select add/remove windows components, then select IIS. If you're on Windows 95/98/ME you'll have to install Personal Web Server (I can't remember exactly how to do this, maybe the same way as IIS?).

Once you've done this then try the following code:

<?php
 strTest = "It's Working!" 
?>

<?php
=strTest
?>

You should get a page that says "It's Working". If that works, then we can tackle your first problem

more comments

DizzEAngel — Thu, 16 Aug 2001 13:55:18 +0000

I ment to add that the reason why i think the machine is just not recognizing ASP is because I tried to display a simple message using asp:

<?php
Response.Write("Hello World")
?>

and also

<?php
=Response.Write("Hello World")
?>

and nothing even came up in my browser.

DizzE

DizzEAngel — Thu, 16 Aug 2001 13:52:05 +0000

I wouldn't even know how to check to see if my permissions are set correctly. How do you do that?

I haven't checked to see if I have a Jet 4.0 installed. However, I do have MS Access, so wouldn't that be included when downloaded?

Another problem arises. I don't think it's a problem with the connection code per se. I think my machine is just not regonizing ASP. Since ASP is a server side type of language, do I need to be on an actual server in order for the code to be understood?

I'm off to try the last suggestion in a few minutes. Wish me luck.

DizzE

Peter J. Boettcher — Wed, 15 Aug 2001 19:41:02 +0000

You're correct, that should work. A couple things to check:

1) Are permissions set correctly? Since the database is located on the root of the machine you must give the IUSR_machinename account access to that directory/file.

2) Do you have the Jet 4.0 driver installed?

Try moving the database into your web folder and try the following connection code:

ConnStr = "Driver={Microsoft Access Driver (*.mdb)};DBQ="
ConnStr = ConnStr & server.mappath("/ShiftNotesDatabase.mdb")

Set DBConn = server.createobject("adodb.connection")
DBConn.Open ConnStr

Let me know if that works!