> From: David Brian Chait
>
> 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 it, and always
On Wed, Feb 9, 2011 at 7:42 PM, Jerry Schwartz 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 years since I
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 wrote:
[JS] Actually
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz 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
> dataset Access w
>-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; ho
You should probably take this over to the MyODBC list.
I suggest that you get the Bullzip programs and look at what they do by way of
transferring the database structure. You'll learn a lot from that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 060
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
On Wed, Feb 9, 2011 at 7:55 AM, David Brian Chait wrote:
> 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 never specified
, 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 wrote:
> Am 09.02.2011 06:36, schrieb Y z:
> >
> > I have a windows app that wants to talk to either a) an access data
On Wed, Feb 9, 2011 at 7:18 AM, Reindl Harald wrote:
> 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 configu
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
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
13 matches
Mail list logo
