ODBC Problem

Results 1 to 2 of 2

Thread: ODBC Problem

  1. #1
    Join Date
    Dec 1969

    Default ODBC Problem

    I have set up an active server page at <BR>http://www.web-<BR>sitedesigners.co.uk/ukpers/submit.asp?<BR>to <BR>submit information to a MS Access database<BR>located on an NT website. On entering the<BR>data <BR>I am getting the following error message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers<BR>error &#039;80040e14&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver]<BR>Syntax error in INSERT INTO statement. <BR><BR>/ukpers/submit.asp, line 38 <BR> Has anyone got any ideas?<BR><BR>My email address is abannigan40@hotmail.com<BR><BR>Cheers<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: ODBC Problem

    Right before you execute the SQL statment do a...<BR>response.write(SQL) where SQL is the variable for the SQL statement.<BR><BR>It will show you what the SQL statement looks like as it is going into the database for processing...<BR><BR>You will probably see your error first hand....<BR><BR>Otherwise, post your SQL command in here...<BR><BR>-- Whol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts