I would like to find out from fellow developers if there are any pitfalls in using a recent libmysql.dll with a previous MySQL server. I use Delphi with DbExpress to build database applications.
My main reason is that I have both Delphi 7 and Delphi 2010 on my development machine. I have built applications with D7 that use MySQL 5.0 but D2010 requires MySQL 5.1.
I would like to avoid upgrading all my previous DB applications if I can help it hence would like to keep using MySQL 5.0 server but still develop all new DB applications using D2010.
Your advice and or suggestions on this matter will be highly appreciated.