Re: ASP and MySQL

On Aug 12, 8:56 am, Risingfish <risingf...@xxxxxxxxx> wrote:
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

Before anyone tries to answer, I found the issue. Whoever wrote the
original code didn't clear the Err object so it was actually happening
well about this sql statement.
.

Relevant Pages

  • 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)
  • 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)
  • 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)
  • Export fast, my code slow =[
    ... ODBC driver or the server (MySQL, ... I think the above code is sending an "INSERT INTO" SQL statement to ... The reason I posted this to the MSAccess group instead of MySQL/MyODBC ...
    (comp.databases.ms-access)
  • 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)
Loading