Posted by Bernard Peek on 09/28/07 11:31

In message <cle3n1l8l6408t7g2f3h5n9l0m2h6ued4h@4ax.com>, André
<a_lhoir@skynet.be> writes
>Hello,
>
>I have MySQL v5.0 on my computer. I would like to write some
>applications in VB that reaches the MySQL data bases.
>
>I installed the driver MySQL 3.51 for the ODBC. I want to add, in the
>user DSN, the MySQL driver in the "Data sources(ODBC) in the control
>panel".
>
>When I configure this driver (server, user, password and table) the
>system crash (not responding) when I open the menu to choose the
>database. If I write manualy the name of the database and that I make
>the test of connection, he says that it is good but the system crash
>also.
>
>I downloaded 3 older drivers, I removed and reinstall MySQL and the
>result is the same.
>
>Result, I don't succeed in reaching the MySQL data bases.
>
>My config:
>Windows 2000 SP4

There appears to be a problem with an updated DLL in one of the updates
since SP4. It's a JET security patch. If you replace the DLL with an
older version it may work. I found that I could get a system DSN to
work, but not a File DSN.

Search Microsoft for msjet40.dll or just restore an earlier version.


--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

[Back to original message]