I've a query which happily returns a full set of data when run in SQL
Studio but when I do the same query using IIS with Classic ASP
connected via ODBC's SQL Server driver (not the native one) numbers
returned to the record set are filled with 0 and strings are empty
exept for a few rows.
This is happening in IIS 5.1 and IIS 6.0 when the database is on a
seperate machine. With IIS 5.1 and SQL Server 2005 Developer Edition
on the same machine (XP Professional) the query results are as
expected.
I can't even think of what to check or search for!
David