You are here: Re: Problem with MySQL and ODBC « MySQL Databases « IT news, forums, messages
Re: Problem with MySQL and ODBC

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.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация