...

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



sahar
09-17-2005, 01:50 AM
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")

%>

glenngv
09-19-2005, 01:48 PM
You didn't mention which line is line 33. But try removing "" in pwd.


Application("connectionString")="dsn=talentsource;uid=sa;pwd=;"

pwd value (or any other keys, for that matter) should not be enclosed in double quotes.

Bullschmidt
09-20-2005, 08:36 PM
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

glenngv
09-21-2005, 05:35 AM
That is not a recordset object, that is an Application (http://www.w3schools.com/asp/asp_applications.asp) 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.

sahar
09-24-2005, 03:24 AM
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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum