-
Apr 26th, 2021, 02:10 PM
#1
Thread Starter
New Member
Arguments_are_of_the_wrong_type_are_out_of_acceptable_range_or_are_in_conflict_with_o
I am getting Arguments_are_of_the_wrong_type_are_out_of_acceptable_range_or_are_in_conflict_with_one_another
on rstUpload.Open strSQL, Application("gstrDbConnProp"), 1,3
and I have no idea why
Set rstUpload = Server.CreateObject("adodb.recordset")
rstUpload.Open strSQL, Application("gstrDbConnProp"), 1,3
It looks perfectly ok to me. Ha sanyone got any pdeas whyc please?
Thanks
-
Apr 27th, 2021, 02:52 AM
#2
Re: Arguments_are_of_the_wrong_type_are_out_of_acceptable_range_or_are_in_conflict_wi
Is gstrDbConnProp a variable?
If so then don’t place “ around it.
-
Apr 27th, 2021, 04:04 AM
#3
Thread Starter
New Member
Re: Arguments_are_of_the_wrong_type_are_out_of_acceptable_range_or_are_in_conflict_wi
Originally Posted by Knutsford
I am getting Arguments_are_of_the_wrong_type_are_out_of_acceptable_range_or_are_in_conflict_with_one_another
on rstUpload.Open strSQL, Application("gstrDbConnProp"), 1,3
and I have no idea why
Set rstUpload = Server.CreateObject("adodb.recordset")
rstUpload.Open strSQL, Application("gstrDbConnProp"), 1,3
It looks perfectly ok to me. Ha sanyone got any pdeas whyc please?
Thanks
Application("gstrDbConnProp") holds the connection. I am sure that is ok. It is used in other places
-
Apr 28th, 2021, 05:01 AM
#4
Re: Arguments_are_of_the_wrong_type_are_out_of_acceptable_range_or_are_in_conflict_wi
Sorry, then I can't help you.
Never used VBScript or ASP
But...
What is the content of: strSQL
Last edited by Arnoutdv; Apr 28th, 2021 at 05:04 AM.
-
Apr 28th, 2021, 05:34 AM
#5
Thread Starter
New Member
Re: Arguments_are_of_the_wrong_type_are_out_of_acceptable_range_or_are_in_conflict_wi
Originally Posted by Knutsford
Application("gstrDbConnProp") holds the connection. I am sure that is ok. It is used in other places
I have managed to solve it. It was the SQL statement that was wrong. A very confusing error message
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|