Just looked through your code in more detail... You're not actually
connecting to the database.
You have the connection string stored in the application variable
"University", however you're not connecting to the database using that
connection string, instead you're passing it to the recordset's open
method as the second parameter when it's expecting an ADO connection
object, hence the error.
To solve it, connect to the database before you open the recordset, like
so :-
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open Application("university")
query = "SELECT * FROM User_LogTime WHERE offline=True AND user_id=" &
user & " ORDER BY id DESC"
rs_log.Open query, objConn,3,3
Dan
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of samson
Sent: 31 May 2005 12:02
To: [email protected]
Subject: [ASP] Error 800a0bb9, please help..
Hello Dear Friends, I have uploaded my web pages into Internet. Default
page is working fine, but the redirected page is showing error as
follows. DSN I have is "university"
ADODB.Recordset error '800a0bb9'. Arguments are of the wrong type, are
out of acceptable range, or are in conflict with one another.
/university/main.asp, line 60
Error showing line in code is down red colored,
query = "SELECT * FROM User_LogTime WHERE offline=True AND user_id=" &
user & " ORDER BY id DESC"
rs_log.Open query, Application("university"),3,3 // line number 60
In Global.asa, Application_onStart, i have connected to the database as
follows.
Application("university") = "DRIVER={Microsoft Access Driver (*.mdb)};
DBQ="& Server.MapPath ("database/university.mdb") & ";"
Can you pls suggest me, where should i correct this code?.
Thanks in advance, ~Samson (ASPbeginner)
---------------------------------
Discover Yahoo!
Find restaurants, movies, travel & more fun for the weekend. Check it
out!
[Non-text portions of this message have been removed]
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
