Good ODBC Reference? [was RE: Replacing MS SQL with MySql]

2011-02-11 Thread Jan Steinman
From: David Brian Chait dch...@invenda.com 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. Can someone recommend a good ODBC tutorial or reference? I've tried a couple times to tie things together with

RE: Replacing MS SQL with MySql

2011-02-09 Thread Y z
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

RE: Replacing MS SQL with MySql

2011-02-09 Thread David Brian Chait
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

RE: Replacing MS SQL with MySql

2011-02-09 Thread Jerry Schwartz
06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Y z [mailto:yan...@hotmail.com] Sent: Wednesday, February 09, 2011 12:37 AM To: mysql@lists.mysql.com Subject: Replacing MS SQL with MySql I have a windows app that wants

RE: Replacing MS SQL with MySql

2011-02-09 Thread Jerry Schwartz
-Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Wednesday, February 09, 2011 1:18 AM To: Y z Cc: mysql@lists.mysql.com Subject: Re: Replacing MS SQL with MySql No way to do that directly; however, using the MySQL ODBC connector

Re: Replacing MS SQL with MySql

2011-02-09 Thread Johan De Meersman
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz je...@gii.co.jp wrote: [JS] Actually, I've done a lot of tracing recently (to solve my own performance problems), and Access 2007 is very clever at pulling parts of a dataset and a number of other things. For example, when you are browsing a

RE: Replacing MS SQL with MySql

2011-02-09 Thread Jerry Schwartz
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Wednesday, February 09, 2011 1:10 PM To: Jerry Schwartz Cc: Y z; mysql@lists.mysql.com Subject: Re: Replacing MS SQL with MySql On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz je...@gii.co.jp wrote

Re: Replacing MS SQL with MySql

2011-02-09 Thread Johan De Meersman
On Wed, Feb 9, 2011 at 7:42 PM, Jerry Schwartz je...@gii.co.jp wrote: *[JS] I don’t have any data at the moment. I know that I tried outsmarting Access with pass-through queries, with little luck.* Hmm. I seem to remember those working, but that was in access itself, I think. It's been many

Replacing MS SQL with MySql

2011-02-08 Thread Y z
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

Re: Replacing MS SQL with MySql

2011-02-08 Thread Johan De Meersman
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

Re: Replacing MS SQL with MySql

2011-02-08 Thread Reindl Harald
Am 09.02.2011 06:36, schrieb Y z: 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? no way if the

Re: Replacing MS SQL with MySql

2011-02-08 Thread Johan De Meersman
On Wed, Feb 9, 2011 at 7:18 AM, Reindl Harald h.rei...@thelounge.netwrote: Am 09.02.2011 06:36, schrieb Y z: 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

RE: Replacing MS SQL with MySql

2011-02-08 Thread David Brian Chait
, February 08, 2011 10:54 PM To: Reindl Harald Cc: Y z; mysql@lists.mysql.com Subject: Re: Replacing MS SQL with MySql On Wed, Feb 9, 2011 at 7:18 AM, Reindl Harald h.rei...@thelounge.netwrote: Am 09.02.2011 06:36, schrieb Y z: I have a windows app that wants to talk to either a) an access

Re: Replacing MS SQL with MySql

2011-02-08 Thread Johan De Meersman
On Wed, Feb 9, 2011 at 7:55 AM, David Brian Chait dch...@invenda.comwrote: To borrow your line of reasoning, translators can be rather slow and unreliable. Adding the extra overhead and complexity is certainly not worth the potential gains. I daresay that's up to the user to decide, no? OP