I have a very strange problem. I have 3 physically separate netwoks 

hosting a single IIS machine and a single SQL machine. Two networks are 

working just fine, but today I tried to put the third one online and would 

get a time out. The files are all identicle on all 3 networks. When I 

tried to find the problem point I did some code troubleshooting. This is 

what I wrote after the connection string:



response.write "Here"

response.end



And it work just fine. But when I added response.write rs("ID") I got 

nothing. So I wrote this:



if rs.eof then response.write "EOF"

if not rs.eof then response.write "NOT EOF"

response.write "Here"

response.end



This is the results I got:



EOF

NOT EOF

Here



I have never seen this...how can the EOF condition be both true and false? 

I don't even know where to start on something like this. I've already re-

registered the asp.dll.

That's quite bizarre. Have you considered (re)installing the Microsoft Data

Access components? Doesn't sound like a problem with ASP - more likely a

problem with ADO. http://www.microsoft.com/data/



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Bill Bonnett" <Bill_Bonnett@y...>

To: "ASP Databases" <asp_databases@p...>

Sent: Saturday, September 15, 2001 1:45 AM

Subject: [asp_databases] RS.EOF





: I have a very strange problem. I have 3 physically separate netwoks

: hosting a single IIS machine and a single SQL machine. Two networks are

: working just fine, but today I tried to put the third one online and would

: get a time out. The files are all identicle on all 3 networks. When I

: tried to find the problem point I did some code troubleshooting. This is

: what I wrote after the connection string:

:

: response.write "Here"

: response.end

:

: And it work just fine. But when I added response.write rs("ID") I got

: nothing. So I wrote this:

:

: if rs.eof then response.write "EOF"

: if not rs.eof then response.write "NOT EOF"

: response.write "Here"

: response.end

:

: This is the results I got:

:

: EOF

: NOT EOF

: Here

:

: I have never seen this...how can the EOF condition be both true and false?

: I don't even know where to start on something like this. I've already re-

: registered the asp.dll.