469,946 Members | 1,805 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

local interface to MySQL

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!
Jul 20 '05 #1
3 1746
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
Jul 20 '05 #2
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.
Jul 20 '05 #3
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.

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bill Hernandez | last post: by
2 posts views Thread by Sean Berry | last post: by
4 posts views Thread by Nathaniel Sherman | last post: by
11 posts views Thread by Keith Hughitt | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.