local interface to MySQL

[Shank]

I need to harvest data from MySQL tables. My experience is with MSSQL and
Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't
need to manage anything. I just need the data. What kind of interface can I
use to query and save data locally? I don't see any MySQL drivers available
when I try to setup an ODBC from my desktop. Can I download one somewhere?

thanks!

[Aggro]

Shank wrote:

I need to harvest data from MySQL tables. My experience is with MSSQL and
Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't
need to manage anything. I just need the data. What kind of interface can I
use to query and save data locally? I don't see any MySQL drivers available
when I try to setup an ODBC from my desktop. Can I download one somewhere?

MyODBC:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

[Bill Karwin]

Shank wrote:

I need to harvest data from MySQL tables. My experience is with MSSQL and
Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't
need to manage anything. I just need the data. What kind of interface can I
use to query and save data locally? I don't see any MySQL drivers available
when I try to setup an ODBC from my desktop. Can I download one somewhere?

I have used the MySQL Connector/ODBC driver from MySQL's web site to do
things like extract data from a local or remote MySQL database into an
MS Excel spreadsheet.

http://www.mysql.com/products/connector/odbc/

Once I installed this driver, I was able to use the regular Microsoft
ODBC Data Source Administrator (under the Windows Control Panel) to
create a DSN for a MySQL database. Then I could access these DSN's in
any application that supports ODBC.

Regards,
Bill K.

[Shank]

What I believe happened is that the database was hosted on a linux server
and the web host only allowed access from within their network. I had to use
a script to access the database from within a web browser.
thanks

"Bill Karwin" <bi**@karwin.com> wrote in message
news:cl*******@enews4.newsguy.com...

Shank wrote:

I need to harvest data from MySQL tables. My experience is with MSSQL and
Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't
need to manage anything. I just need the data. What kind of interface can
I use to query and save data locally? I don't see any MySQL drivers
available when I try to setup an ODBC from my desktop. Can I download one
somewhere?

I have used the MySQL Connector/ODBC driver from MySQL's web site to do
things like extract data from a local or remote MySQL database into an MS
Excel spreadsheet.

http://www.mysql.com/products/connector/odbc/

Once I installed this driver, I was able to use the regular Microsoft ODBC
Data Source Administrator (under the Windows Control Panel) to create a
DSN for a MySQL database. Then I could access these DSN's in any
application that supports ODBC.

Regards,
Bill K.