Re: Connecting to db via win32 (Word or Excel)

[Daniel Kasak]

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]