[Info-ingres] connecting to a mysql database

[Allan Biggs]

I may need to connect to a mysql database.

I know there is an Ingres product that allows one to connect to other
databases can anyone point me in the right direction here so that I can
read up on this.


I envisage doing this from a Linux box probably using ESQLF , this will be
to keep tables in sync between a mysql database and an Ingres database.

thanks
Allan

This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean

http://www.DuPont.com/corp/email_disclaimer.html

[Allan Biggs]

_______________________________________________
Info-ingres mailing list
Info-...@lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres

[Paul White]

Hi Alan,



I have been supporting this combo until the Mysql server was retired
recently:



Ingres <-> OpenROAD <-> EA/MSSQL <-> MSSQL 2008 <-> Mysql



I love Enterprise Access. Simple quick lazy coding.

SELECT, UPDATE, Views, Procedures, DIRECT EXECUTE IMMEDIATE.

The MSSQL Linked Server facility is very useful.





Peercore supports cross database transactions and synchronisation at several
client sites,

example:



Ingres <-> DAS <-> .Net C# <-> MSSQL (but can be any DB).





Also, I recall Myworkplace had built their own ODBC driver



Ingres <-> OpenROAD <-> ODBC <-> MS Access





Should be a fun project.



Paul