No, what he is suggesting is that you use Access or MSSQL, and link Mysql to either platform via ODBC so that you can use it indirectly. All databases are not the same in terms structure and capabilities..you most likely will not be able to swap one out for another and make it work directly with your app. If there is an absolute requirement to use Mysql then you may be better off finding a different front end software that supports it, if not then embrace the fact that you will in all likelihood be maintaining a MS DB server for it. Not that it is such a bad thing, most corporate environments are heterogeneous these days, not geared toward one platform vs. another.
-David -----Original Message----- From: Y z [mailto:yan...@hotmail.com] Sent: Wednesday, February 09, 2011 8:32 AM To: vegiv...@tuxera.be Cc: mysql@lists.mysql.com Subject: RE: Replacing MS SQL with MySql Thanks. The developer cheerily informs me that Access is 'deprecated' and will be phased out. So, SQL it is. I'm not sure what you mean by 'passthrough'. Do you mean MYSQL | ODBC | Win app ? If so, where do I go to learn how to configure MySQL and ODBC to dance together nicely, and talk to the app? Thanks! > No way to do that directly; however, using the MySQL ODBC connector you can > get at least a) and c) to play passthrough. Performance will likely suffer, > though; especially Access' Jet Engine has a tendency to pull in full remote > datasets instead of passing through the query. > > > On Wed, Feb 9, 2011 at 6:36 AM, Y z wrote: > > > > > I have a windows app that wants to talk to either a) an access database, b) > > a MS Sql Express database, or c) a MS Sql 2008 database. > > > > Can anyone please point me in the direction of configuring My Sql to > > imitate any of the above? > > > > Thanks! > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > > > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dch...@invenda.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
