This is a discussion on SUM + IIS problem update within the MySQL Database forums, part of the Database Forums category; Hi, I've just noticed that the problem I'm having can be summarised more easily. If I issue: SELECT ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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 |