Operation Timing Out

Results 1 to 2 of 2

Thread: Operation Timing Out

  1. #1
    esac Guest

    Default Operation Timing Out

    &#060;% <BR> set rsCat = Server.CreateObject("adodb.recordset") <BR> sqlCatDSN = "DSN=nfdi" <BR> sqlCatStmt = "SELECT distinct(Category) FROM inventory ORDER BY [Category] ASC" <BR> rsCat.open sqlCatStmt, sqlCatDSN <BR> rsCat.MoveFirst <BR> do while not rsCat.eof <BR> response.write "&#060;option name=" & rsCat("Category") & "&#062;" & rsCat("Category") <BR> rsCat.MoveNext <BR> loop <BR> rsCat.close <BR> set rsCat = Nothing <BR> %&#062;<BR><BR>That piece of code is timing out and I can&#039t figure out why. Any clue ?

  2. #2
    Rajiv-rchawla@ccginc.net Guest

    Default RE: Operation Timing Out

    you first need to open a connection... i think thats what u are missing i have used this method for ages and has been working for me. even though i do not use dsn for connection . if the connection statement does not work pl check the syntax for the kinf of DB you are connecting to.<BR><BR><BR>dim conn<BR>set conn = server.createobject("adodb.connection")<BR>conn.op en "dsn=xyz"<BR><BR>dim rs<BR>set rs = server.createobject("adodb.recordset")<BR>rs.open "select xyz from abc",conn<BR>do while not rs.eof<BR> ....what ever<BR> rs.movenext<BR>end do<BR><BR>set rs=nothing<BR>set conn=nothing<BR><BR><BR><BR>also i notice the code you have:<BR>response.write "&#060;option name=" & rsCat("Category") & "&#062;" & rsCat("Category") <BR><BR>is missing "&#060;/option&#062;" at the end<BR><BR><BR>

Posting Permissions

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