Hello,

I am a sysadmin and am configuring a NT/SQL server for one of the 

applications which the client has got developed from a third party. The 

entire dump of ASP, HTM, MDF and one DLL file of the appln. have been 

handed over by the developer to the client. The application was running 

fine on the developer's server. We need to set it up for our client on his 

own server, but the developer is no longer in the picture, hence all 

issues have to be sorted out by me during installation. 



What I have done:

1) Setup a Virtualhost in IIS and pointed to the Dir

2) Attached the MDF files of SQL into the Server, so all tables/stored 

procs, roles, users, etc. are restored

3) Found a wilsonsandhu.dll in the dir, so thought it right to register 

it. Successfully did that.



However when I go to the Login area of the website, I get the error:

ADODB.Recordset error '800a0e7d' 



The connection cannot be used to perform this operation. It is either 

closed or invalid in this context. 



/tracktrace/Login_validate.asp, line 17 



The few lines in question for this file are:



Session("SELECTEDRANGE") = Request.Form("SelectRange")

If (Request.Form("From") = "Login" )AND IsEmpty(Session("CUSTOMEROBJ"))  

Then  

	Dim LoginId

	Dim password

	Dim boolStatus



	LoginId = Request.Form("LoginId")

	password = Request.Form("password")

	Set logObj = Server.CreateObject("WilsonSandhu.login")

	boolStatus = logObj.validate(cstr(loginID),cstr(password),cstr

("CustomerProfile"))



The line in error points to "Set logObj"



I believe the error is related to DB connectivity. The MDF given by the 

client shows "wilson" as the DBO. Hence I tried creating a user named 

wilson in the system, however I am not able to assign him DBO for this DB, 

as it says the user already existing in roles. Thus I have not been able 

to connect using Queryanalyser as well, with the username. 



Also, I am not sure from where the DB connection is opened from the app, 

and under what username/passwd. I could not find any file for this, and 

hence presume it was hardcoded in the DLL file. I am not sure if thats 

possible. I do not even know if its a DSN or DSN-less connection. Hence 

pls give me tips on what best I cud do for this.



Thanks a ton,

Ninad