www.webdeveloper.com
Results 1 to 5 of 5

Thread: ADODB.Command error '800a0bb9'

  1. #1
    Join Date
    Jul 2012
    Posts
    5

    Unhappy ADODB.Command error '800a0bb9'

    Hi,

    I was wondering if I could ask for your assistance.

    I have a script (not written by me) which I am trying to get working.

    It's a script that handles a login. When logging in I get:

    Code:
    ADODB.Command error '800a0bb9'
    
    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
    
    default.asp, line 27
    I've read a few help threads but none of which are helping unfortunately.

    Basically, the line it refers to is either:

    Code:
    Line 27 of the file:
    
        MM_rsUser_cmd.ActiveConnection = MM_templenews_STRING
    Code:
    Line 32 of the file: 
    
        Set MM_rsUser = MM_rsUser_cmd.Execute
    I am providing two lines, as the file has some HTML in it before the ASP starts (5 lines) so not sure which specific line the error refers to.
    Any help would be greatly appreciated

    Thanks in advance,

    Jon

  2. #2
    Join Date
    Jun 2012
    Location
    Dark Side of the Moon
    Posts
    70
    The error is referring to the first chunk of code you gave reffing the line 27. You can tell because it is attempting to set the MM_rsUser_cmd, which is attempting to connect to a database. SO, whatever you are passing in the MM_templenews_STRING is in wrong and needs to be fixed. If you want more help I need more code.
    I love how people get an attitude when THEY asked for help.

  3. #3
    Join Date
    Jul 2012
    Posts
    5
    Hi,

    Many thanks for the reply

    The connection string is included in another file. The string is:

    Code:
    MM_templenews_STRING "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=../../private/temple-news.mdb;"
    Before that, in the included connection file, we have:

    Code:
    ' FileName="Connection_odbc_conn_dsn.htm"
    ' Type="ADO" 
    ' DesigntimeType="ADO"
    ' HTTP="false"
    ' Catalog=""
    ' Schema=""
    Dim MM_templenews_STRING
    'MM_templenews_STRING = "dsn=templenews;"
    Thanks again

    Jon

  4. #4
    Join Date
    Jul 2012
    Posts
    5
    BUMP.

    Can anybody offer any assistance with this please?

  5. #5
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    Your connection variable is missing the equal sign.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles