Webmaster Forum / ASP / Database Access / October 2008

Hello,

We have an old app that we're having a problem with. We're using MySQL
through ODBC on in an old ASP application. We running into some odd
type mismatch errors are cause us fits and we just can't figure out
what's going on. The following SQL statement works for most people but
on a few it blows up with a type mismatch (this statement comes from a
customer that it's breaking on):

UPDATE Customer SET LastLoginIP = '<removed>', LoginCountSuccess = 55,
LoginCountFail = 2, DateLastLogin = now() WHERE CustomerID = 1146;

Looks normal to me... One of the guys mentioned that there are some
issues with using MySQL through ODBC, and I was wondering if anyone
might be able to help?

The MySQL database is located on a different server than the website
running this query fi that makes a difference, but again, it works for
most customers. Please let me know if any more information is needed
to help troubleshoot.

Thanks!
R