ado error

[binaryking]

Hello all,
I was assigned to add option explicit to all of my asp pages and everysince I did, i keep getting the following error on some pages:

Can someone tell me the concept behind this and what is usually can be done to prevent this. I can NOT copy paste the code!.
Thank you

ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/xyzwebapplication/includes/data.asp, line 3564

[paulhiles]

Hi binaryking,

it's a bit difficult to troubleshoot your problem without any code to look at! The error message has given you the line number, so refer to that for possible culprits. According to this page (http://www.adopenstatic.com/faq/800a0bb9.asp) on adOpenStatic the most likely cause is the way in which you've used the Open method when calling a Recordset.

I'm also moving this thread into Database Talk, where you may get further replies.

Hope that helps,

Paul

[jwm5411]

I agree...post your code. You have an argument that does not match. This looks like you are using ASP. I've had this problem when I forgot to use the include for ADOVBS.

[swstyles]

Adding option explicit tags is very good practice.
Option Explicit implies that you Dim all your variables. If you say intMyInt = 2 without Dim intMyInt, you will get an error.

Your error could be that the data type in the database doesn't match the type of data you are trying to insert.

Or your comparison clause could be requiring a number when it is getting a ""(empty string).

Hope this helps