Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    6

    Unhappy Unanswered: microsoft oledb error

    good day,

    i am having a problem where everytime i submitted the form, it will prompt this error :

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
    /kiosk/discount.asp, line 115


    and line 115 error is

    If (Not MM_abortEdit) Then
    ' execute the insert
    Set MM_editCmd = Server.CreateObject("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute <---this is line 115
    MM_editCmd.ActiveConnection.Close

    i'm using dreamweaver (aspvb script page) and access..and have a little knowledge on sql,asp or whatsoever..please help me..my dateline is in 1 month from now...please please please!!

    thank you very much!

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    MM_editCmd.CommandType = adCmdText

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    What is mm_editquery ?
    If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL

  4. #4
    Join Date
    Feb 2004
    Posts
    6
    i'm not sure what it is because i'm using dreamweaver mx..every script is ready added on..that is why im having the problem to manipulate the asp script..

    i changed it but the same error occured.. can u give me any alternative way to connect my access and dreamweaver?

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    From my other post to you, you can add response.write in your asp page (not executing the sql) and display the mm_editquery.
    If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL

  6. #6
    Join Date
    Dec 2003
    Posts
    454
    Originally posted by genocide7
    i'm not sure what it is because i'm using dreamweaver mx..every script is ready added on..that is why im having the problem to manipulate the asp script..

    i changed it but the same error occured.. can u give me any alternative way to connect my access and dreamweaver?
    You need to add the following code

    MM_editCmd.CommandType = adCmdText

    before the code of the execution:

    MM_editCmd.Execute

    Note that you need to include the file adovbs or use

    MM_editCmd.CommandType = &H0001

Posting Permissions

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