Topic: ODBC Data Source Mining

[Dan Williams]

Hi,
In the past I have set up ODBC data source to an AS400.
I then would use MS Foxpro, or SQL server  to mine data from those sources.
What is the preferred/acceptable replacement for those two applications in the Linux world?
I have a small project coming up, that does not have a pressing deadline that I would like to try this with.
Would need the ability, once the query was run, to export in a CSV, or other acceptable format. As well, is there an Linux alternative to Crystal Reports?
Dan Williams

[Arkman]

Might need a little more info, but some food for thought....

I have begun using Mysql for all my small/medium database projects. There are hundreds of handy php/perl/etc.. programs that can act as query frontends and help with data export and movement. You can also easily connect Access (and probably Excel although I have never done so) to Mysql via ODBC and use it as your 'frontend'. Many, many, possibilities...

[Dan Williams]

Hi,
I downloaded MySQL 3.23  from http://www.mysql.com/downloads/mysql-3.23.html and installed it on a Windows PC.
I could not figure out how to select an other database in it? Maybe I have downloaded the wrong thing?
Dan

[Arkman]

Me bad... I read that initial post backwards! I thought that you wanted to replace the backend with a linux solution, not the frontend.

[gavin]

You may like to look at the ADODB php tools as they are designed to move data from source to target databases, Try google and enter adodb and php as search criteria.

Looks like it would be helpful to you.

Regards,
Gavin