I have a ASP page which retrieves data from a SQL database. I am setting a variable to hold the data, for example:<BR><BR>query = " SELECT * from emp"<BR>set myvariable = connect.Execute(query)<BR><BR>I then retrieve the data using myvariable("first_name") etc.<BR><BR>This is working fine on my machine, and was working fine on the server until about an hour ago. Further investigation shows that myvariable is not being populated with data on the server and there are no errors.<BR><BR>I am assuming this is a server problem, since it works on my machine and worked until an hour ago. I cannot reboot the server until tonight, but I was wondering if anyone has heard anything like this before?