Hi.

I am quite new to ASP but have been trying out the tutorial for database connection, however i get the following error:

Error Type:
ADODB.Connection (0x800A0E79)
Operation is not allowed when the object is open.
/guestbook.asp, line 22

Can anyone help?.

E.

Thanks for the response, I have managed to resolve that problem now but I have anotehr query regarding submitting a form that I am working on.

I am trying to declare the variables for all of the headings within my form, however I am getting the following error:

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/example/Bookings_process.asp, line 15, column 124
Dim Firstname, Secondname, Organisation, Position, Address_1, Address_2, Address_3, Postcode, Telephone, Fax, Mobile, Web, E-Mail, Request, Service, Therapies, Events, Training, Comments, theDate,sql

I have successfully tried the tutorial using just 3 fields but obviously I need to have all of the fields available form my form to work, can you advise what I should have added?

Regards,

M.

if you wrap the DIM statment to a second line, then that is probally what your problem is. Try doing one of the following:

add a _ to the end of the first line so the script knows to continue to the next line, ex
Dim Firstname, Secondname, Organisation, Position, Address_1, Address_2, Address_3, Postcode, Telephone, Fax, _
Mobile, Web, E-Mail, Request, Service, Therapies, Events, Training, Comments, theDate,sql

add a second DIM statment, ex
Dim Firstname, Secondname, Organisation, Position, Address_1, Address_2, Address_3, Postcode, Telephone, Fax,
Dim Mobile, Web, E-Mail, Request, Service, Therapies, Events, Training, Comments, theDate,sql

The _ character when used in this fasion is basically a line terminator that tells the script that the line contiues on the next line. If you put anything, including comments, after the _, you will also get an error, as ASP expects nothing after it.

Thought I'd share a tidbit that solved an ODBC connectivity problem for me with the guestbook database tutorial, as used with IIS 5.0 & W2K. The IUSR must have R+W permissions wherever the db containing folder is at, of course. But it was also necessary for me to change the *system* TEMP and TMP environment variables to point at a folder named TEMP in the root of (any) drive and to give the IUSR R+W permission there, too. That TEMP folder is apparently used when ODBC is used from ASP. I don't know if the problem was specific to Access97 or not, but the tutorial started working for me immediately after I made that change to the system environment variables and rebooted.