Progress connection to MYSQL

D

dayv2005

Member
Currently our web db side is powered by db2. We have a module in our progress app that will post information into the db2 via data directs ODBC driver. well we are doing some converting for our web side. And now i want to run a MYSQL instead of db2. So now i want to take this progress app and post information to the mysql db instead of the db2 db.

I know this question has been asked before probably even by myself but i didn't get far with it. Someone suggested pro2Mysql and i was looking at it. I might be wrong but is that just for migrating a progress db to a mysql db? And with this would i be able to just post information into the mySql db?
 
PSC's standard solution for interacting with a non-Progress database is a DataServer. It doesn't sound like that is what you have been using, though.
 
That I can't really comment on since I don't really know what it is. With a DataServer, you can write ABL that accesses a non-Progress database. There are, of course, ways to access non-Progress databases with SQL, but this implies some kind of intermediary code to which you pass requests from the ABL side and it turns around to make SQL requests of the DB. If you have that already, then I would think it shouldn't be hard to adapt to MySQL, but that isn't really a Progress question, since the ABL session is merely using this service. If you want to just write ABL code against the other database, then a DataServer is the right answer.
 
AFAIK the ODBC DataServer does not support MySQL.

... But you could write some kind of Data Access procedure or procedures (or objects) that lets you work, receive or send Temp-Tables on the Progress side

and uses either ActiveX or maybe MySQL API to interact with MySQL side (I believe Scott Auge posted samples for using the MySQL API on the Hive or maybe it's on the Amduus repository hosted on the Hive website).

HTH
 
You must log in or register to reply here.
Back
Top