ADODB.Recordset (0x800A0BB9) error
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=14905
Printed Date: 30 March 2026 at 6:55am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: ADODB.Recordset (0x800A0BB9) error
Posted By: ub3rl337ch3ch
Subject: ADODB.Recordset (0x800A0BB9) error
Date Posted: 01 May 2005 at 10:59pm
|
i get a "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." error when i run either of the two following bits of code:
sql = "SELECT Custname FROM Customer"
vrec.Open sql, adoCon
sql = "SELECT Consult, Locked FROM Consultant"
vrec.Open sql, adoCon
but i only get this error after running the following code:
sql = "UPDATE Consultant SET Counter = 0 WHERE Consult='" & consult & "'"
adoCon.Execute sql, adoCon
any ideas?
|
Replies:
Posted By: Lofty
Date Posted: 02 May 2005 at 6:45am
|
adoCon.Execute sql, adoCon is incorrect. should be just adoCon.Execute sql without the second adocon put on the end. |
Posted By: ub3rl337ch3ch
Date Posted: 02 May 2005 at 7:17pm
duh.... thanks... me be much stoopid... its all this using rs's, i'm used to writing ", adoCon" after sql... 
|