Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    5

    Unanswered: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) Error

    Hi
    I am doing a mailing list form in dreamweaver with MS access as the database..Whenever try to submit i get this error in the page..cAn anybody help me...

    The error is "Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
    [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
    /omimailinglist/mailinglist.asp, line 115 "
    Please help...I am having the same problem with 2 forms on diff databases.....

    Thanks in advance

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Let's see your query statement that your getting the error on ...

  3. #3
    Join Date
    Jul 2003
    Posts
    5
    <%
    Dim Recordset1
    Dim Recordset1_numRows

    Set Recordset1 = Server.CreateObject("ADODB.Recordset")
    Recordset1.ActiveConnection = MM_OMIMailingList_STRING
    Recordset1.Source = "SELECT subscriber_Name FROM mailing-list"
    Recordset1.CursorType = 0
    Recordset1.CursorLocation = 2
    Recordset1.LockType = 1
    Recordset1.Open()

    Recordset1_numRows = 0
    %>

    This is the code i have to just select the subsriber name from the mailing.Previous error was when i try to indert soemthing into the database.So i tried to retrieve soem data(just to check if instead inserting am i able to retrieve the data)..When i try i am getting this error
    " [Microsoft][ODBC Microsoft Access Driver] Syntax Error in FROM clause"

    Dont know whats wrong.I am using Dreamweaver MX and Access2k.
    Please soembody help

    Thanks in advance
    Banu

  4. #4
    Join Date
    Jul 2003
    Posts
    5
    <%
    Dim Recordset1
    Dim Recordset1_numRows

    Set Recordset1 = Server.CreateObject("ADODB.Recordset")
    Recordset1.ActiveConnection = MM_OMIMailingList_STRING
    Recordset1.Source = "SELECT subscriber_Name FROM mailing-list"
    Recordset1.CursorType = 0
    Recordset1.CursorLocation = 2
    Recordset1.LockType = 1
    Recordset1.Open()

    Recordset1_numRows = 0
    %>

    This is the code i have to just select the subsriber name from the mailing.Previous error was when i try to indert soemthing into the database.So i tried to retrieve soem data(just to check if instead inserting am i able to retrieve the data)..When i try i am getting this error
    " [Microsoft][ODBC Microsoft Access Driver] Syntax Error in FROM clause"

    Dont know whats wrong.I am using Dreamweaver MX and Access2k.
    Please soembody help

    Thanks in advance
    Banu

Posting Permissions

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