This website is running on IIS 6, SQL Server 7 back end, asp scripting.
It has public and private areas, but uses the same connection scripting
throughout the entire site.
SET conn = server.createobject ("adodb.connection")
conn.open Session("DSN")
strUserID = request.form("txtUserID")
SET rsUserCheck = Server.CreateObject("ADODB.Recordset")
rsUserCheck.CursorLocation = 3
rsUserCheck.open "SELECT * FROM tblUSERS WHERE UserWebAuthorityLevel = 1 AND
UserID = '" & strUserID & "'",conn
From Global.asa: Session("DSN") =
"dsn=AWS_SQL;uid=IUSR_Hurricane;pwd=<>;DATABASE=AW S_SQL;APP=ASP
Script;Trusted_Connection=yes"
Although thousands of users connect successfully using the above every day,
2 users are getting the following message when going to the page, even when
using the correct UserID and password.
The connection cannot be used to perform this operation. It is either closed
or invalid in this context.
The error references the line "rsUserCheck.open "SELECT ..."
One of the users has a 3-computer home network, with 2 of the 3 computers
logging on without a problem. The same is true within another network,
where some work and others don't. Otherwise, the vast majority of users are
having no problem whatsoever.
Have you heard of this happening before? Is this an IIS issue?
Please advise and thanks in advance.
