Error - Connection object
Hi,
I am using Windows 2003, IIS 6.0 as my application server. Database resides in another server.
My application uses DSN connection. When I test the connection through ODBC it says "test completed successfully", but when I try to connect from Application through connection string it throws an error saying
ADODB.Commanderror '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Following is the connection string I am using in Global.asa file
Session("focus_ConnectionString") = "DSN=;DRIVER={SQL Server};UID=;PWD=;APP=Microsoft (R) Developer Studio;WSID=;DATABASE="
Here I am using
DSN = myDSN Name, UID and PWD (provided to me), WSID=myAppservername, Database=myDBName.
Please respond if one has a solution.
