Hey guys and gals. I have a problem with some code. I have had many different problems with all the sites I've done here and there, but I have never had a problem on the line described below. Here are the details:

Site:

http://www.poe-boy.com

Error Message:

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/artiststore.asp, line 14


Page Info:

Line 11: Set cmd = Server.CreateObject("ADODB.Command")
Line 12: cmd.ActiveConnection = dbc
Line 13: cmd.CommandText = "qryNumberOfProduct"
Line 14: cmd.CommandType = adCmdStoredProc


Also, when i fisit another page, I get the same type of error for the same code that is on line 14. What I can't explain is that the site was working properly about 2 hours before I found the error.

Thanks in advance.

try adding

Const adCmdStoredProc = 4

to you script

Yeah Johnno. I reuploaded mu adovbs.inc file and everything worked fine, I guess something happened to it before. Thanks alot.