Re: MySQL on i using DB2

As I understand it, an important motivation for creating the i connector was to allow native apps access to mySql data. Having said that, we developers do like to stretch the limits some.

Now there is an ODBC driver for mysql, and ODBC is ODBC and mysql is mysql - so there's no reason not to go directly to the mysql data through mysql. It's got to be just as easy as getting data from any other database server.

So does the OP have that ODBC driver? Has he pointed it at the table in mysql?

HTH
Vern

Dennis Lovelady wrote:

With my SQL setup on system i using the connector for DB2, could an
application running on another platform access the mySQL database on
the i? e.g. Could I write a application that ran on a windows desktop,
or a mac, or another system i and have it access the mySQL database
(actually DB2). If so I would assume that I would use an ODBC driver
for mySQL. Is there anything that would need to be done on the system i
side to allow the connection? I read the IBM redbook and did not see
anything about how to configure mySQL to accept external connections.

Why would you want to, when DB2 is so easily accessible as it is?

I would imagine that you'd run into all sorts of security issues if you
tried something like this, so I doubt that it's allowed. And if this is a
circumvention for such security issues, I doubt you'd want to exercise it.
Having said that, I cannot say one way or another.

Regards,
Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
Phil Rizzuto (to Yogi Berra, driving to a banquet) : "Yogi, we're lost."
"Yeah, but we're making good time."