Syntax error in INSERT INTO statement.

Report · Jul 04, 2007

Hi everyone,

I'm developing a form in DWMX using ASP VBScript trying to write to an Access db

I've done similar things successfully on another PC and remember having to go through various file permissions tweaks before I could successfully write to the db. I've compared the security/file folder permissions of both machines and made a few changes to make the second PC set up the same as the one I've worked on successfully.

At this point, I'm just trying to write the value of a text field to the db and get an "HTTP 500.100 - Internal Server Error - ASP error" - specifically"Syntax error in INSERT INTO statement.".

I can copy the pages to the other machine and write the value successfully so it must be some permissions or other setting on the second machine. Any ideas?

Thanks.

Report · Jul 04, 2007

The error generally means that you are using a reserved word for the name of
a field. eg Date

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · Jul 05, 2007

If it works on one machine and not the other then check that you do not use
the word "Password" for a field name. This seems to have been added to the
list or reserved words.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"NewDevGuy" <webforumsuser@macromedia.com> wrote in message
news:f6grp2$lt3$1@forums.macromedia.com...
> Hi everyone,
>
> I'm developing a form in DWMX using ASP VBScript trying to write to an
> Access
> db
>
> I've done similar things successfully on another PC and remember having to
> go
> through various file permissions tweaks before I could successfully write
> to
> the db. I've compared the security/file folder permissions of both
> machines
> and made a few changes to make the second PC set up the same as the one
> I've
> worked on successfully.
>
> At this point, I'm just trying to write the value of a text field to the
> db
> and get an "HTTP 500.100 - Internal Server Error - ASP error" -
> specifically"Syntax error in INSERT INTO statement.".
>
> I can copy the pages to the other machine and write the value successfully
> so
> it must be some permissions or other setting on the second machine. Any
> ideas?
>
> Thanks.
>

Report · Jul 17, 2007

Thanks to everyone for the helpful replies. It turns out that machine (where I was able to work successfully) has IIS set up to run ASP.net version 1.1.4322 and machine 2 (where I was having problems) had IIS set up to run ASP.net version 2.0.50727. I changed the version and now everything works successfully.