The asp code is:

<%@ Language=VBScript %>

<%

dim Conn, cmdTemp, rs, S_String

Session("Projects_ConnectionString")= "DSN=SQL2005;UID=DB_User;APP=Microsoft (R) Developer Studio;WSID=SQL2005;DATABASE=DB_Dev"

Session("Projects_ConnectionTimeout")= 15000

Session("Projects_CommandTimeout")= 30000

Session("Projects_RuntimeUserName")= "DB_User"

Session("Projects_RuntimePassword")= "xxxxxxxxxxxxxxxxxxxxx"

Session.Timeout= 240

Server.ScriptTimeOut= 300

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.ConnectionTimeout = Session("Projects_ConnectionTimeout")

Conn.CommandTimeout = Session("Projects_CommandTimeout")

Conn.Open Session("Projects_ConnectionString"), Session("Projects_RuntimeUserName"), Session("Projects_RuntimePassword")

Set...

"rs.Open cmdTemp, , 1, 3" returns rs.EOF= True and rs.recordcount=0. If I give the user permissions on the table and run the same code, rs.recordcount = 1.

I am not getting an error message. It just isn't returning any records.