I had a beautiful ASP/SQL deal goin' on when I served the ASP from the same
machine as SQL server was installed on, but now I've relocated the ASP to a
stand-alone web server, it takes forever for SQL queries to run.... What's
the deal? any ideas? anybody run across the same problems?
I can't figure it out... I'm using the same code and connection method as
before, but sometimes, the script is timing out, when there are only about
40 rows to return. The query runs fine on the SQL server, and the Web
server can ping and connect to SQL with no problems, and fast.... so I
can't think why it's working so slowly... can someone help me? PLEASE?