Very strange connection issue

Discussion in 'ASP General' started by WC Justice, Mar 8, 2005.

  1. WC Justice

    WC Justice Guest

    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=AWS_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.
     
    WC Justice, Mar 8, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Raymond Arthur St. Marie II of III

    very Very VERY dumb Question About The new Set( ) 's

    Raymond Arthur St. Marie II of III, Jul 23, 2003, in forum: Python
    Replies:
    4
    Views:
    483
    Raymond Hettinger
    Jul 27, 2003
  2. shanx__=|;-

    very very very long integer

    shanx__=|;-, Oct 16, 2004, in forum: C Programming
    Replies:
    19
    Views:
    1,629
    Merrill & Michele
    Oct 19, 2004
  3. Abhishek Jha

    very very very long integer

    Abhishek Jha, Oct 16, 2004, in forum: C Programming
    Replies:
    4
    Views:
    427
    jacob navia
    Oct 17, 2004
  4. Peter

    Very very very basic question

    Peter, Feb 8, 2005, in forum: C Programming
    Replies:
    14
    Views:
    518
    Dave Thompson
    Feb 14, 2005
  5. olivier.melcher

    Help running a very very very simple code

    olivier.melcher, May 12, 2008, in forum: Java
    Replies:
    8
    Views:
    2,304
Loading...

Share This Page