Thomas Nyman wrote:
Hi all
I'm a mysql beginner. I have my database up and running and can query
it via php and apache.
I would like to set things up so that MSExcel and or MSWord can query
the database and extract info from it. For this reason I downloaded
the and installed MyODBC-standard-3.51.04-win.exe. No errors where
generated upon install on my W2K machine. But when I look in
Datasources ODBC under administrative tools there is no mysql-driver
installed.
What am I missing? Is there something else that needs to be installed?
Thanks
Thomas
You need to configure a datasource. All you've done so far is install
the drivers ( and old ones at that ).
In the administrative tools, create a new System DSN. If you need help
with this, have a look at my page on it:
http://enthalpy.homelinux.org/MySQL/setup.html
Also note that using MS Query from Word or Excel ( or anything else )
will *not* work well with MySQL. MS Query seems to be quite buggy. The
only reliable way of talking to MySQL from Word or Excel is to use ADO.
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]