ASP and MySQL

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
.

Relevant Pages

  • RE: ODBC logging via ISS Internet Scanner
    ... Here is a synopsis of the situation: I want ISS ... I have a ODBC connection to this MySQL ... > Check out Yahoo! ...
    (Security-Basics)
  • Re: Native ODBC access for python on linux?
    ... Can you tell me what I have to use in order to utilize the MySQL native ... > ODBC is a vanilla interface that puts a layer between the program ... The native API can provide access to all ... >> I'm getting my feet wet with making Python talk to MySQL via ODBC. ...
    (comp.lang.python)
  • Re: ASP and MySQL
    ... We're using MySQL ... through ODBC on in an old ASP application. ... customer that it's breaking on): ... to help troubleshoot. ...
    (microsoft.public.inetserver.asp.db)
  • MySQL/OpenOffice/ODBC
    ... MySQL-Version MySQL 4.1.16-standard-log ... GTK-based ODBC configuration library ii libmyodbc 3.51.11-5 the ... 4.1.15-1 mysql database client library ii libmysqlclient 5.0.18-7 ...
    (de.comp.os.unix.linux.misc)
  • =?iso-8859-1?q?A97_DB_mit_MySQL_Backend...Verbindung_bricht_st=E4ndig_ab?=
    ... Als Access Version hab ich hier Access 97 SR2 und den ODBC Connection ... Ich hab die Tabelle in die MySQL DB ... dieses Formular ein bissel crapy programmiert ist, ...
    (microsoft.public.de.access)
Loading