Problem with MySQL and ODBC

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
Pentium IV 1Gb RAM
MySQL v5.0.15-nt-max via TCP/IP
Driver ODBC 3.51.12.00
port used : default
user : root

HELP....

Andre

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.

Which version work? and where i can download this driver?

André

On Wed, 9 Nov 2005 14:03:27 +0000, Bernard Peek <bap@shrdlu.com>
wrote:

>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.