ASP

[Pete]

I'm trying to set up my site so that when a user submits a form, an asp script is called which then updates a database.

I'm fiddling around trying to get ASP to work but am having no luck. Is there a specific directory I should upload the ASP script to?
I've been trying the following:

I've uploaded the asp (script.asp) to the cgi-bin folder.

I've used the following html to call the asp:

<FORM name=BookingForm
action="/cgi-bin/script.asp"
method=post>

I've uploaded my access database (example.mdb) to the same folder (cgi-bin)

I've used the following ASP to connect to the database:


ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("example.mdb")

Have I put the asp script and database in the right place, and if not where should I put them, and what changes to the code would I need to make?

As you can probably guess, I'm very new to asp etc.

Thanks in advance,

Pete

[Roger]

Pete,
I know absolutely nothing about ASP but a quick google suggests that you need to set execute permission on for script.asp -- have you done that?

Nice to know somebody else is using this forum, it was getting a bit lonely,
Roger

[Pete]

Thanks Roger,

I hadn't thought of that. I've now applied execute permission to the script yet it still doesn't work. I actually can't get any ASP script to work, despite getting the same script to work on a free host site.

Any help gratefully received!

Pete...