(Beating head on keyboard...) "So one more time for the folks at home: Is there anyone out there who has managed to get MySQL 64-bit to work via ODBC?"

For those who aren't aware, MySQL has an ODBC connector called, oddly enough, Connector/ODBC. In previous versions it was called MyODBC. It does work, as evidenced by the fact that I can connect from Windows apps with ease. What doesn't work, and the only thing I'm looking for an answer to is, why do I get the error, "The specified DSN contains an architecture mismatch between the Driver and Application" when connecting from within Struts 2? But at this point I'd be happy hearing from anyone that has gotten "MySQL 64-bit to work via ODBC."

TG

Lee Clemens wrote:
Not to sound like a jerk, but have you gotten JDBC (MySQL Connector/J)
working with a MySQL 64-bit server?  Or is this specifically a Struts issue?
If so, what message/condition do you receive?

Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]?


-----Original Message-----
From: Todd Grigsby [mailto:strutsu...@tgrigsby.com] Sent: Monday, December 14, 2009 9:57 PM
To: Struts Users Mailing List
Subject: Re: MySQL + JDBC



Not that I wanted to get into a debate about the usefulness of ODBC, but the Java-based web services we have aren't the only things that connect to these databases, and going through ODBC has been, for the last 10 years, a very nice and consistent way to connect across all our applications and utilities. We have, at one time or another, supported all of the following:

    MySQL
    Oracle
    SQL Server
    Informix
    DB2
    mSQL
    Pervasive SQL
    MS Access (pre-Jet)

And a few others, and we have connected to these databases via ODBC all along the way. Keeping the connection mechanism consistent has made development work in a number of languages simple. So while I certainly appreciate everyone's enthusiasm for talking directly to MySQL, I have a legacy code base that works *REALLY* well through ODBC, and I'd like to stick with it.

So one more time for the folks at home: Is there anyone out there who has managed to get MySQL 64-bit to work via ODBC?

TG



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@struts.apache.org
For additional commands, e-mail: user-h...@struts.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@struts.apache.org
For additional commands, e-mail: user-h...@struts.apache.org





---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@struts.apache.org
For additional commands, e-mail: user-h...@struts.apache.org

Reply via email to