Arguments_are_of_the_wrong_type_are_out_of_acceptable_range_or_are_in_conflict_with_o

[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

[Arnoutdv]

Is gstrDbConnProp a variable?
If so then don’t place “ around it.

[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

[Arnoutdv]

Sorry, then I can't help you.
Never used VBScript or ASP

But...
What is the content of: strSQL

[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