Permission denied: 'dbConn'

[pana]

I have been trying to install an ASP ticketing system written in ASP and using SQL Express Database.

All database tables are configured, however, when I attempt to log in I get the following error.

Active Server Pages error '00000000'

Create object failed

?

An error occurred while creating object 'dbConn'.

Microsoft VBScript runtime error '800a0046'

Permission denied: 'dbConn'

/helpCentricLoginConfirm.asp, line 49

[Belisarius]

Just out of curiosity (I don't work with ASPs, but I do work with PHP and JSPs), are you sure you're passing the correct username and password to the database?

[pana]

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

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

'##### 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)

[Belisarius]

Good grief, I had forgotten just how convoluted Microsoft API code was.

I'm sorry, but I don't think I'm going to be much help - this is too different from what I've done in other languages.