Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    1

    Unanswered: [Microsoft][ODBC SQL Server Driver]Timeout expired

    I keep getting the above error when i run a sql from my web page. The query runs fine in enterprise manager. What is worng . Please help.

    sql="SELECT top 1 * FROM V_ISSUE WHERE ISSUE_ID=" & issueid & " order by issue_id"

    if Session("rs").State = 1 then Session("rs").Close
    Session("rs").Open sql,Session("MyConn")

  2. #2
    Join Date
    Feb 2002
    Location
    India
    Posts
    38

    I hope this will helps u

    Please Try this Code

    sql="SELECT top 1 * FROM V_ISSUE WHERE ISSUE_ID=" & issueid & " order by issue_id"

    Session("rs").Open sql,Session("MyConn")

    Session("rs").close
    Set Session("rs")=Nothing
    -- Prasad --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •