ASP Error on INSERT INTO Statement

Discussion in 'ASP .Net' started by =?Utf-8?B?T2ZmX1JvdXRl?=, Oct 21, 2004.

  1. Hi

    I'm getting the following error:

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains
    the following unknown field name: 'ClientName'. Make sure you have typed the
    name correctly, and try the operation again.

    I have checked the database and the field names are correct. The IIS server
    has the appropriate permissoins to the database. When I run the query from
    Access it sucessfully inserts a row. Thanks for your help and here is my code:

    set objCmd = server.CreateObject("adodb.command")
    set objCmd.ActiveConnection = oUnifiedConn

    DIM strTest
    strTest = "INSERT INTO Client (ClientName) VALUES ('" & strName & "');"
    response.Write strTest

    objCmd.CommandText = strTest
    'objCmd.CommandType = adCmdtext
    objCmd.Execute ' line 82

    Thanks

    Mark
     
    =?Utf-8?B?T2ZmX1JvdXRl?=, Oct 21, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. compuglobalhypermeganetz0r

    adapter update problem Syntax error in INSERT INTO statement.

    compuglobalhypermeganetz0r, Dec 8, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    841
    compuglobalhypermeganetz0r
    Dec 8, 2003
  2. Saber
    Replies:
    5
    Views:
    536
    Jo Inferis
    Jul 20, 2004
  3. =?Utf-8?B?T2ZmX1JvdXRl?=

    ASP Error on INSERT INTO Statement

    =?Utf-8?B?T2ZmX1JvdXRl?=, Oct 21, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    3,081
  4. =?Utf-8?B?T2ZmX1JvdXRl?=

    ASP Error on INSERT INTO Statement

    =?Utf-8?B?T2ZmX1JvdXRl?=, Oct 21, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    282
    =?Utf-8?B?T2ZmX1JvdXRl?=
    Oct 21, 2004
  5. Neil Zanella
    Replies:
    3
    Views:
    673
    MWells
    Jan 25, 2005
Loading...

Share This Page