I cant make myoleDB connect to mySQL

Hi,
I've recently made an intranet application that allows teachers to book
available computer suites for lessons. The data is stored in a mySQL
database and I'm using myOLEdb for the connection.
I've installed myOLEdb3.exe in E:\program files\myoledb and mySQL is
installed in E:\MySQL on the intranet server and mysql is installed on
the same machine.

I've created a MY.CNF file in the root of C: and there is also a my.ini
in WINNT both of which point to the correct base and data directory for
mySQL.

When I attempt to run the application I get an exception that includes
the message "'MySQLProv' provider is not registered on the local
machine." even though myoledb has been installed.

When I try to run the 'sample database creator' that comes with the
myOLEdb installation it reports that "An error has occurred" but doesn't
give any more information.
Please can you help me by providing some information as to what might be
stopping the driver from working correctly, I'm really eager to make
this work as I've got plans to really expand the functionality provided
by the school intranet and using MySQL to store data is a must!

Thanks in advance for any help you can give me.

Steve Richards

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: I cant make myoleDB connect to mySQL

Hi Richard

I'm trying to download file MyOLEDB3.exe but I wasn't able to find it at
mySQL/downloads. Can you send it over to my email shawjh@msn.com?

Thanks in advance,

James Shaw



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org