Recently, something happened on my system that I'm not sure I could ever explain. I'm curious if the expertise of the list might be able to help me out. Please speak layman terms, as I'm forced to jump in this without testing the waters...
I was working fine with MSAccess 97 to MySQL (ver 3.23.38) via MySQL ODBC drivers 2.50 on RH7.1 alpha build. Several days ago, my Access began failing to connect to the MySQL database with the ODBC drivers. I checked the "/path_to_mysql/server.log" file and discovered that whenever the connection attempt was made by MSAccess, MySQL killed and restarted. I've done some browsing of the 'archives' and came to the conclusion that the ODBC drivers probably needed updating - since I was still able to connect by telnet to the server:port from localhost that MySQL was assigned to listen to for my connections. Upgrading to ODBC 3.51.04 has not really fixed my problem, but has given me an error number (#2203) in the windows error boxes. My MySQL continues to kill/restart when attempting connection via ODBC. I have PERL scripts that write/modify via SQL commands to the MySQL databases that still work ok, which tells me that the global and user privileges are still intact with the data files. I've ran 'myisamchk -r *.MYI' and 'myisamchk -e *.MYI' in the directory with the database files and no errors were reported. Also - I've noticed that as root, I cannot shut down the MySQL using the standard /etc/rc.d/init.d/mysqld stop. It fails, and I cannot figure out why. Failing to properly shut down on a reboot or other system malfunction will one day severely corrupt my data - and I'm not looking forward to that. But, I can shut the databases down with 'mysqladmin -p shutdown' and supplying the root password. I'm baffled. I'm not officially part of the list, so if anyone would care to lend some aid, please e-mail me directly (or to the list and I'll eventually get it). At this point, I'm desperate. The hot breath of my users are on my neck... Thanks in advance. -Tony -- __________________________________________________ Tony Alston - Westinghouse TRU Solutions, LLC - Email <mailto:tony.alston@;wipp.ws> Web Site <http://www.t2ed.com> __________________________________________________ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
