Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ADODB.Connection (0x800A0BB9) Arguments are of the wrong type, are out of acceptable

    can somebody help me with this, the error type is like this

    Error Type:
    ADODB.Connection (0x800A0BB9)
    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
    /talentsource/include/tsc_admin_config.asp, line 33

    and this is the code for /talentsource/include/tsc_admin_config.asp

    <%
    '//On Error Resume Next

    '//session.timeout= 1200
    Server.ScriptTimeout= 3600

    Set Conn = Server.Createobject("adodb.Connection")

    '//POWERED BY DETAILS
    Application("CompanyName")="AkyWeb.com"
    Application("CompanyEmail")="jason@akyweb.com"
    Application ("CompanyUrl")="www.akyweb.com"
    Application("ProgrammerName")="md sahrom"
    Application("ProgrammerName_alias")="sahar"
    Application("ProgrammerEmail")="mdsahrom@gmail.com"


    '//CLIENT DETAILS
    Application("CompanyName")="Talent Source"
    Application("CompanyEmail")="admin@talentsource.com"
    Application("ContactPerson")=""

    '//SOFTWARE VERSION
    Application("softwarename")="Talent Source Consulting"
    Application("softwareversion")="Beta V0 1.0"


    'Database Setting
    '//MICORSOFT-SQL-SERVER-2000
    Application("connectionString")="dsn=talentsource;uid=sa;pwd=""; "
    'Application("ConnectionString") = "Provider=SQLOLEDB.1;Password="";Persist Security Info=True;User ID=sa;Initial Catalog=inuovi;Data Source=YTTAN"

    Conn.open Application("connectionString")

    %>

  • #2
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    10,950
    Thanks
    0
    Thanked 236 Times in 233 Posts
    You didn't mention which line is line 33. But try removing "" in pwd.

    Code:
    Application("connectionString")="dsn=talentsource;uid=sa;pwd=;"
    pwd value (or any other keys, for that matter) should not be enclosed in double quotes.

  • #3
    Regular Coder
    Join Date
    Aug 2002
    Location
    USA
    Posts
    478
    Thanks
    0
    Thanked 2 Times in 2 Posts
    I don't even see where a recordset called Application is even opened.

    And here is a related link:

    Why do I get 800A0BB9 / 800A1391 errors?
    http://www.aspfaq.com/show.asp?id=2102
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips

  • #4
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    10,950
    Thanks
    0
    Thanked 236 Times in 233 Posts
    That is not a recordset object, that is an Application object, an ASP intrinsic object like Session.
    The error is in the Conn.open line because the connection string parameter passed is invalid probably because of that "" in pwd.

  • #5
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thank guys for helping me.i've already solve this problem but i dont sure by removing "" for pwd is the correct solution.
    this because my harddisk have 3 partition with drive C (NTFS),
    drive D and drive E(FAT 32),previously sql server stored in drive C and i got an error like this (ADODB.Connection (0x800A0BB9) Arguments are of the wrong type, are out of acceptable) but when i uninstall sql server and change the location to drive D everything was fine using that asp code for connection.
    So i think the problem why this asp code got an error is because NTFS


  •  

    Posting Permissions

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