ODBC Drivers error '80040e14'

Results 1 to 2 of 2

Thread: ODBC Drivers error '80040e14'

  1. #1
    Join Date
    Dec 1969

    Default ODBC Drivers error '80040e14'

    im using a simple asp page,when i use to retreive some data with a recordset its working well.but when i try to insert or update some thing with connection.execute its showing the following error,i have connected via a dsn.why this please help,actually there is no erros with the insert into statement<BR><BR>Microsoft OLE DB Provider for <BR>[Microsoft][ÈÑäÇãÌ ÊÔÛ*á Microsoft Access ODBC] Syntax error in INSERT INTO. <BR><BR>my query is:"INSERT INTO courses (course_name) values &#039;" & cnames &"&#039;"<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: ODBC Drivers error '80040e14'

    you forgot the parens around values:<BR>insert into courses (course_name) values(&#039;" & cnames & "&#039;)"<BR>

Posting Permissions

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