Static ADODB.Recorset In ASP

[cmlimnet]

Hi All,
I have a problem open a static recordset in ASP. I wonder static recordset is working in ASP or not? By default, what type of recordset is default in ASP?
My code sample is showes as below:

Set cnn = Server.CreateObject("ADODB.Connection&quot
cnn.Open CONSTR
Set rst = Server.CreateObject("ADODB.Recordset&quot
rst.Open strsql, cnn, adOpenStatic,adLockReadOnly,adCmdText

I get error message like this :
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

However, the same piece of code is working very well in VB.
Any idea of how this problem happen?

Thank you.

Best Regards,
cmlimnet

 

[Tarwn]

This may be an error inside your SQL statement. Since the string is not evaluated until you attempt to execute it or open it (it is just a string to the ASP server, it is a command sequence to the database) than any error in it won't be caught earlier. Have you tried Response.Write'ing the SQL to see if there are any issues with it?

-Tarwn

_{01010100 01101001 01100101 01110010 01101110 01101111 01101011 00101110 01100011 01101111 01101101}
^{29 3K 10 3D 3L 3J 3K 10 32 35 10 3E 39 33 35 10 3K 3F 10 38 31 3M 35 10 36 3I 35 35 10 3K 39 3D 35 10 1Q 19}
Get better results for your questions: faq333-2924
Frequently Asked ASP Questions: faq333-3048

 

[cmlimnet]

Hi Tarwn
Thank you for suggestion. I think the error is because I have set some property like rs.AbsolutePage=No.

Best Regards,
cmlimnet