Did you try checking the SQL statement that's being run using :- response.write query
Before you open the recordset? Could be that the user variable is empty. 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/
