| Author |
 Topic  |
|
|
Astralis
Senior Member
USA
1218 Posts |
 Posted - 20 March 2005 : 15:32:02
|
>> ADODB.Recordset error '800a0bb9'
I know this error usually means that ADOVBS is not included, but I know it is included on my page...
<!--#include file="adovbs.inc"-->
I even did response.writes on it.
But, I still get this error:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/login/inc_protect.asp, line 24
Here's the code:
strCon = database location
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.connectionstring = strCon
adoCon.Open
Set RS = Server.CreateObject("ADODB.RecordSet")
Sql = "SELECT * FROM USERS WHERE ID_USER=1"
RS.CursorType = 2
RS.LockType = 3
RS.Open Sql, adocon
Any ideas? |
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 20 March 2005 : 15:57:54
|
Astalis,
have you tried it like:strCon = database location
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.connectionstring = strCon
adoCon.Open
Set RS = Server.CreateObject("ADODB.RecordSet")
Sql = "SELECT * FROM USERS WHERE ID_USER='"1"';"
RS.CursorType = 2
RS.LockType = 3
RS.Open Sql, adoconJust I have some simular code in an sql query and needed that stuff in red to get it running.
I hope it helps.
|
Cheers,
David Greening |
 |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 20 March 2005 : 16:04:24
|
| Didn't help. |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 20 March 2005 : 16:19:42
|
| Sent you an e-mail. |
Cheers,
David Greening |
|
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 20 March 2005 : 16:23:57
|
Hey David. That e-mail address is wrong in my profile. I forgot to change it.
Could you send it to astralislux at hotmail dot com?
Ot send it through here. I just updated it.
Thanks! |
Edited by - Astralis on 20 March 2005 16:28:45 |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 20 March 2005 : 16:41:33
|
| Sent the email to you. |
Cheers,
David Greening |
|
|
|
DarkDrift
Junior Member
USA
126 Posts |
Posted - 20 March 2005 : 18:19:00
|
try this..Not an expert but it may work:
strCon = database location
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.open strCon
Sql = "SELECT * FROM USERS WHERE ID_USER='1'"
set rs = server.createObject("ADODB.RECORDSET")
RS.CursorType = 2
RS.LockType = 3
RS.Open Sql, adocon
dunno that may or may notwork. what is this for a login script? |
http://www.xcalliber.com - The Future of Boards |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 24 March 2005 : 23:38:57
|
quote:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Usually means you've got the query wrong rather than anything to do with the ADO include (as a matter of fact looking at your code you don't seem to be using any ADO Constants).
DarkDrift I think has probably got the answer, check your ID_USER field is numeric, if it's not then you'll need to use '1' in the query. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 March 2005 : 05:06:08
|
| If you are using Access, you can also create a new query, change it to SQL view and paste the SQL you have now. Quite likely Access will show an error message that will help you track the error. If you are using SQL Server, try running the query in Query Analizer. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
