Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error: Arguments are of the wrong type, are out of acceptable range

Status
Not open for further replies.

PleaseGiveHelp

Programmer
Oct 29, 2002
131
0
0
US
I am getting this error when I try to run my ASP page:

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/admin/tradeexecutions/lib/voyager.inc, line 26

So I go to this voyager.inc page, line 26 and here is the code:

dim db ' Create and open our connection
set db = Server.CreateObject("ADODB.Connection")
db.ConnectionTimeout = Application("conn1_ConnectionTimeout")
db.CommandTimeout = Application("conn1_CommandTimeout")
db.CursorLocation = Application("conn1_CursorLocation")
db.Open Application("conn1_ConnectionString"), Application("conn1_RuntimeUserName"), Application("conn1_RuntimePassword")


What's wrong I don't get it!
 
Check to see that the contents of:

Application("conn1_ConnectionString"),
Application("conn1_RuntimeUserName"),
Application("conn1_RuntimePassword"),
Application("conn1_ConnectionTimeout"),
Application("conn1_CommandTimeout"),
Application("conn1_CursorLocation")


are what you think they should be. As ADO gives that error when passed an empty connection string, presumably any other blank connection information could produce the same message.
 
I have a global.asa which provides the strings to pass and they're all there, so I don't get it:

Application("conn1_ConnectionString") = "Provider=MSDASQL.1;Persist Security Info=False;User ID=Ident;Data Source=IDSrc;Initial Catalog=IDmark;User Id=IDent;PASSWORD=IDPass;UID=dbo;APP=Microsoft Development Environment;WSID=PCWUT-AH3;DATABASE=Test"
Application("conn1_ConnectionTimeout") = 150
Application("conn1_CommandTimeout") = 120
Application("conn1_CursorLocation") = 3
Application("conn1_RuntimeUserName") = "IDent"
Application("conn1_RuntimePassword") = "IDPass"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top