I have a windows app that wants to talk to either a) an access database=2C =
b) a MS Sql Express database=2C or c) a MS Sql 2008 database.=20
Can anyone please point me in the direction of configuring My Sql to imitat=
e 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=3Dgcdmg-mysql-2@m.gmane.o rg
--0015174be03aa85090049bd36c0e
Content-Type: text/plain; charset=ISO-8859-1
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
>
> 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=vegivamp@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
--0015174be03aa85090049bd36c0e--
--------------enigBA25AABF04611DD774BAC193
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Am 09.02.2011 06:36, schrieb Y z:
>=20
> I have a windows app that wants to talk to either a) an access database=
, b) a MS=20
> Sql Express database, or c) a MS Sql 2008 database.=20
>=20
> Can anyone please point me in the direction of configuring My Sql to=20
> imitate any of the above?
no way if the application has no abstraction-layer
you can not easy switvh from one rdbms to another
because in a closed source app you will even not
can connect
after connect there are hughe differences in many details
so if a application does not support a specific rdbms
you can not use it
--------------enigBA25AABF04611DD774BAC193
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
iEYEARECAAYFAk1SMcMACgkQhmBjz394AnlphACfao6B37PDUsUKvov2/uQN j9ly
I5YAn04On/dAZjddhIk7kwwp9OdMSxWb
=713X
-----END PGP SIGNATURE-----
--------------enigBA25AABF04611DD774BAC193--
--0015174bee00af8628049bd3ed4b
Content-Type: text/plain; charset=ISO-8859-1
On Wed, Feb 9, 2011 at 7:18 AM, 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 application has no abstraction-layer
> you can not easy switvh from one rdbms to another
> because in a closed source app you will even not
> can connect
>
> after connect there are hughe differences in many details
>
> so if a application does not support a specific rdbms
> you can not use it
>
Remember, TIMTOWTDI
If someone you want to talk to knows only one language, find an
interpreter. MS Access apparently speaks the same language as his app; and
using ODBC it can also talk MySQL. Link the tables in Access and let the app
use them as if they were regular tables.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--0015174bee00af8628049bd3ed4b--
To borrow your line of reasoning, translators can be rather slow and unreli=
able. Adding the extra overhead and complexity is certainly not worth the p=
otential gains.
-----Original Message-----
From: vegivamp@gmail.com [mailto:vegivamp@gmail.com] On Behalf Of Johan De =
Meersman
Sent: Tuesday, 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
:
> 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 application has no abstraction-layer
> you can not easy switvh from one rdbms to another
> because in a closed source app you will even not
> can connect
>
> after connect there are hughe differences in many details
>
> so if a application does not support a specific rdbms
> you can not use it
>
Remember, TIMTOWTDI
If someone you want to talk to knows only one language, find an
interpreter. MS Access apparently speaks the same language as his app; and
using ODBC it can also talk MySQL. Link the tables in Access and let the ap=
p
use them as if they were regular tables.
--=20
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=3Dgcdmg-mysql-2@m.gmane.o rg
--0015174bdefac2bf92049bd416ce
Content-Type: text/plain; charset=ISO-8859-1
On Wed, Feb 9, 2011 at 7:55 AM, David Brian Chait
> 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 why he
needs the application to connect to a MySQL DB.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--0015174bdefac2bf92049bd416ce--
Thanks. The developer cheerily informs me that Access is 'deprecated' and w=
ill be phased out. So=2C SQL it is.=20
I'm not sure what you mean by 'passthrough'. Do you mean
MYSQL
=A0 |
ODBC
=A0 |
Win app
?
If so=2C where do I go to learn how to configure MySQL and ODBC to dance to=
gether nicely=2C and talk to the app?
Thanks!
> No way to do that directly=3B however=2C using the MySQL ODBC connector y=
ou can
> get at least a) and c) to play passthrough. Performance will likely suffe=
r=2C
> though=3B especially Access' Jet Engine has a tendency to pull in full re=
mote
> datasets instead of passing through the query.
>
>
> On Wed=2C Feb 9=2C 2011 at 6:36 AM=2C Y z wrote:
>
> >
> > I have a windows app that wants to talk to either a) an access database=
=2C b)
> > a MS Sql Express database=2C 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=3Dvegivamp@tuxera.be
> >
> >
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt=2C is eene kwezel
> Hy die't drinkt=2C is ras een ezel
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
No, what he is suggesting is that you use Access or MSSQL, and link Mysql t=
o 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 you=
r app. If there is an absolute requirement to use Mysql then you may be bet=
ter off finding a different front end software that supports it, if not the=
n embrace the fact that you will in all likelihood be maintaining a MS DB s=
erver 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:yankel@hotmail.com]=20
Sent: Wednesday, February 09, 2011 8:32 AM
To: vegivamp@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 w=
ill be phased out. So, SQL it is.=20
I'm not sure what you mean by 'passthrough'. Do you mean
MYSQL
=A0 |
ODBC
=A0 |
Win app
?
If so, where do I go to learn how to configure MySQL and ODBC to dance toge=
ther nicely, and talk to the app?
Thanks!
> No way to do that directly; however, using the MySQL ODBC connector you c=
an
> get at least a) and c) to play passthrough. Performance will likely suffe=
r,
> though; especially Access' Jet Engine has a tendency to pull in full remo=
te
> 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=3Dvegivamp@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
=20
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Ddchait@invenda.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
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 06032
860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com
>-----Original Message-----
>From: Y z [mailto:yankel@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 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=jerry@gii.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
>-----Original Message-----
>From: vegivamp@gmail.com [mailto:vegivamp@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 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.
>
>
[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 will pre-fetch records 20 at a time.
There are some places where it bogs down badly, mostly when it needs to make
sure that its local data cache is synchronized with the MySQL database. That's
where I'm having trouble.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com
>On Wed, Feb 9, 2011 at 6:36 AM, 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 General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamp@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=gcdmg-mysql-2@m.gmane.org
--0015174be65611336a049bdd60cf
Content-Type: text/plain; charset=ISO-8859-1
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz
> [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 will pre-fetch records 20 at a time.
>
Good to know that performance enhancements have been made, but what I'm
specifically thinking of is joins between remote tables - have you got data
on how it handles those ?
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--0015174be65611336a049bdd60cf--
------=_NextPart_000_00BA_01CBC85F.3A36A860
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
=20
From: vegivamp@gmail.com [mailto:vegivamp@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
=20
=20
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz
[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 will pre-fetch records 20 at a time.
Good to know that performance enhancements have been made, but what I'm =
specifically thinking of is joins between remote tables - have you got =
data on how it handles those ?=20
=20
[JS] I donâ=99t have any data at the moment. I know that I tried =
outsmarting Access with pass-through queries, with little luck.
=20
Regards,
=20
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
=20
860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp=20
Web site: www.the-infoshop.com
=20
=20
--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
------=_NextPart_000_00BA_01CBC85F.3A36A860--
--000e0cd116e29e15a1049bdde1e2
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
On Wed, Feb 9, 2011 at 7:42 PM, Jerry Schwartz
> *[JS] I don=92t have any data at the moment. I know that I tried outsmart=
ing
> 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 allowed myself to be degraded to that
point :-)
I believe I also resorted to creating views in MySQL and importing those
instead of the tables, for some things.
--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--000e0cd116e29e15a1049bdde1e2--