Yes, Initially I thought the same thing because of the Error "Permission Denied"
But I have checked the Connection string, and the username/Password in the SQL server. By using MS SQL server Studio and logged in with the same username/password.
I think it maybe having problems acctually using the connection string "dbconn"
My sting is
Code:
Application("shs1sql_ConnectionString") = "PROVIDER=SQLOLEDB;Database=help;SERVER=server-HQ\SQLEXPRESS;PASSWORD=mypass;UID=support;User Id=support;"
This code is in global.asa file in teh root dir.
it is called by a script like the one below
Code:
'##### validate the account and password
connectStr = Application("shs1sql_ConnectionString")
dbConn.Open connectStr
spHC_adminLoginValidate.CommandText = "spHC_adminLoginValidate"
spHC_adminLoginValidate.CommandType = 4
spHC_adminLoginValidate.CommandTimeout = 30
spHC_adminLoginValidate.ActiveConnection = dbConn
spHC_adminLoginValidate.Parameters.Append spHC_adminLoginValidate.CreateParameter("RETURN_VALUE" ,3 ,&H0004)
spHC_adminLoginValidate.Parameters.Append spHC_adminLoginValidate.CreateParameter("@account",adVarChar,&H0001,50,erpAccount)
spHC_adminLoginValidate.Parameters.Append spHC_adminLoginValidate.CreateParameter("@password",adVarChar,&H0001,50,erpPassword)