Go Back   CodingForums.com > :: Server side development > ASP

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 09-17-2005, 12:50 AM   PM User | #1
sahar
New to the CF scene

 
Join Date: Sep 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
sahar is an unknown quantity at this point
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")

%>
sahar is offline   Reply With Quote
Old 09-19-2005, 12:48 PM   PM User | #2
glenngv
Supreme Master coder!


 
glenngv's Avatar
 
Join Date: Jun 2002
Location: Los Angeles, CA Original Location: Philippines
Posts: 10,241
Thanks: 0
Thanked 112 Times in 111 Posts
glenngv will become famous soon enough
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.
__________________
Glenn
_____________________________________________
Play Tower of Hanoi Android app (Ad-FREE!)
Play Tower of Hanoi Android app (FREE!)
Go to Tower of Hanoi Leaderboard
Play Tower of Hanoi Facebook app
glenngv is offline   Reply With Quote
Old 09-20-2005, 07:36 PM   PM User | #3
Bullschmidt
Regular Coder

 
Join Date: Aug 2002
Location: USA
Posts: 478
Thanks: 0
Thanked 2 Times in 2 Posts
Bullschmidt is an unknown quantity at this point
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
Bullschmidt is offline   Reply With Quote
Old 09-21-2005, 04:35 AM   PM User | #4
glenngv
Supreme Master coder!


 
glenngv's Avatar
 
Join Date: Jun 2002
Location: Los Angeles, CA Original Location: Philippines
Posts: 10,241
Thanks: 0
Thanked 112 Times in 111 Posts
glenngv will become famous soon enough
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.
__________________
Glenn
_____________________________________________
Play Tower of Hanoi Android app (Ad-FREE!)
Play Tower of Hanoi Android app (FREE!)
Go to Tower of Hanoi Leaderboard
Play Tower of Hanoi Facebook app
glenngv is offline   Reply With Quote
Old 09-24-2005, 02:24 AM   PM User | #5
sahar
New to the CF scene

 
Join Date: Sep 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
sahar is an unknown quantity at this point
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
sahar is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 09:44 PM.


Advertisement
Log in to turn off these ads.