2. ASPRunnerPro General questions
  3. Error number 3001: Arguments are of the wrong type
This topic is locked

Error number 3001: Arguments are of the wrong type

 		10/15/2003 9:15:58 AM
ASPRunnerPro General questions
S
 Sushy99 author

Hi all, I'm not so good with Asp and SQL: i get the following error:
Error number 3001: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
I really do not know what this means and where i should put hands.
Anyone can help?
Nick
V
 		vbrimley 10/16/2003

Can you post the sql statement?
S
 		Sushy99 author 10/17/2003

Can you post the sql statement?



i don't have it because the error message i recieve is insert into the automatic error page template created by ASPrunner.
if you tell me how to retrive it.. i will post it!
thanks
Nick
admin 10/18/2003

Nick,
here is what you can do: in ..._variables.asp change this line

vDebug = False


to

vDebug = True


This will displayed all SQL statements executed against the database.
Best regards,

Sergey Kornilov
S
 		Sushy99 author 10/20/2003

Can you post the sql statement?



hi all,
here is the SQL statement:
select [email] From [ItalyDB].[remove] order by [email] asc
and this is the error message i get:
Error number 3001

Error description Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
apparently this tool seems to be simple and useful, but this little problem, that seems no one already experienced, is stopping my work before starting.
i really need help....
Nick
admin 10/20/2003

Nick,
what database do you use?
Best regards,

Sergey Kornilov
S
 		Sushy99 author 10/20/2003

Nick,

what database do you use?



SQL 7 or 2000, not 100% sure.
but is i read, both are supported.
Nick
admin 10/20/2003

Nick,
this SQL query looks OK. Just in case try to copy and paste it to SQL Query Analyzer and run it there to see if it works.
Also I recommend to make sure that you have latest Microsoft Data Access Components installed on your Web server. Please check the following URLs to install updates:
http://www.microsoft.com/downloads/details...&DisplayLang=en

http://support.microsoft.com/?KBID=282010
Best regards,

Sergey Kornilov