Linking DB2 tables to MYSQL

[Kafenated]

My appilcation needs to access two tables, one on MYSQL and one on DB2
Is there a way to link the tables....I would rather link if possible instead of my app having to go to two places

Thanks in advance

 

[sleipnir214]

Define "link" as used in this context.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Kafenated]

Instead of importing the table create a link to it. Like the way you can do it with MS Access

Meaning I would like to access the DB2 Table via MYSQL Database Server

 

[sleipnir214]

Oh.

Maybe. There is heterogeneous database replication software out there.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[QatQat]

MySQL is a RDBMS and stores tables as primary function.

Access is primarely a front-end with minimal internal storage capabilities, therefore you can link to other databases.

Perhaps Sleipnir214 is right in thinking that there may be a third party application doing this but I find it like forcing MySQL to do something that it is not designed for.

Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)