Hi,

I've just noticed that the problem I'm having can be summarised more easily.
If I issue:

SELECT SUM(ncount) FROM guess

in MySQL I get an answer, however, in ASP, running on IIS I get no records
returned on my new server. The old server is returning the correct answer.

The servers are identical (at least they appear to be). Both running the
same version of Windows 2003, IIS, MySQL, MDAC.

Does this prompt any ideas for me to check something else?

--
Kev

> I've just noticed that the problem I'm having can be summarised more
> easily. If I issue:
>
> SELECT SUM(ncount) FROM guess
>
> in MySQL I get an answer, however, in ASP, running on IIS I get no records
> returned on my new server. The old server is returning the correct answer.

Fixed it!

It was a problem with the ODBC Mysql 3.51.09 driver. Not spotted it was
older than the 3.51.12 on the other machines. Upgraded and problem sorted.
--
Kev