trick trigger

2012-01-11 Thread John G. Heim
I am working on an app to allow a committee to schedule classes. The members of the committee can all update the database by changing the time or the instructor for a class. I have to write an app to warn them when they've scheduled an instructor for 2 classes at the same time or if they've

MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Monte Milanuk
I've got MySQL Connector/ODBC 5.1 installed on my Windows Vista laptop. I have MySQL 5.5.19 installed on the laptop, and was able to connect to it via the Windows Data Source Administrator app and the MySQL Connector/ODBC using a TCP/IP connection to 'localhost'. I could connect to the MySQL

MySQL Community Server 5.1.61 has been released

2012-01-11 Thread Karen Langford
Dear MySQL users, MySQL Server 5.1.61, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.61 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see

MySQL Community Server 5.5.20 has been released

2012-01-11 Thread Hery Ramilison
Dear MySQL users, MySQL 5.5.20 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.20 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL

Re: MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Johan De Meersman
- Original Message - From: Monte Milanuk memila...@gmail.com 'Connection Failed: [HY000][MySQL][ODBC 5.1 Driver] Access denied for user 'ijdb'@'192.168.56.1' (using password: YES)' The connector is not trying to connect to the host address; it's connecting *from* the host address -

Re: trick trigger

2012-01-11 Thread Shawn Green (MySQL)
Hello John, On 1/11/2012 11:16, John G. Heim wrote: I am working on an app to allow a committee to schedule classes. The members of the committee can all update the database by changing the time or the instructor for a class. I have to write an app to warn them when they've scheduled an

Re: MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Monte Milanuk
On 01/11/2012 09:45 AM, Johan De Meersman wrote: The connector is not trying to connect to the host address; it's connecting *from* the host address - in your MySQL, the old grant for ijdb@localhost will no longer work; you need to grant privileges to ijdb@192.168.56.1. I don't *want* to

Re: MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Johan De Meersman
- Original Message - From: Monte Milanuk memila...@gmail.com Again, I *don't* want to connect to 192.168.56.1 - I want to connect to 192.168.56.20 - so why the heck is mysql refusing to do that. Yes. Now take a deep breath and read what I said again. You can perfectly connect to .20

Re: MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Monte Milanuk
Sheesh... I knew it had to be something simple. Opened up phpMyAdmin as mysql/root and changed the privileges for the ijdb user to allow connecting from any host, not just localhost. Problem solved. Thanks! Monte -- MySQL General Mailing List For list archives: