code timing out on select from access

From: Jeremy (jeremy_zifchock_at_yahoo.com)
Date: 07/12/04


Date: 12 Jul 2004 06:40:08 -0700

I am getting a timeout error and I'm not sure why. I have not called
any data from a form on either post or get...(do I need to?) Any Idea
why it isn't working and how to fix it?

Thanks in advance!

Here is my entire code:

<%@LANGUAGE="JAVASCRIPT"%>

<%

                var conn = Server.CreateObject("ADODB.Connection");
                var rs = Server.CreateObject("ADODB.Recordset");
                var sqlText = "SELECT DISTINCT Table1.*, Table2.* FROM Table2 INNER
JOIN Table1 ON Table2.Unm = Table1.Unm WHERE Table1.Field1 =
'something'";
                conn.Open("DSN=photo");
                rs.Open(sqlText,conn);
                
                                while (!rs.EOF) {
                                        var f1 = rs.Fields("Field1").value;
                                        var f2 = rs.Fields("Field2").value;
                                        var f3 = rs.Fields("Field3").value;
                                                                                }

                rs.Close();
                conn.Close();

        Response.write (f1 + " " + f2 + " " + f3);

%>