Actually, I think it could work the other way around.
(Oops, this is off topic now.)
Informix (in version 9.2.something) has
what they call "virtual table interface"
and they provide an ODBC wrapper, I think.
So you might send your queries to Informix
and Informix could pass (parts of) them further to MySQL (via ODBC).
No idea what the performance could be though.
A safe bet is probably a script (in Perl?) you run regularly
to keep a copy of the important Informix tables on MySQL up to date.
Some timestamp mechanics and a sync state table will be involved, probably.
Jan
"Gerald L. Clark" wrote:
>
> No.
>
> MArk Williams wrote:
> >
> > This is not what I meant.
> > I have a mysql DB running. I have a remote informix DB running.
> > I have DBI/DBD informix/mysql all setup and working.
> > I can access the remote informix database through perl scripts.
> > BUT what I want is my scripts to ONLY access the mysql DB, but to
> > somehow get the mysql DB to go to the remote informix DB and get data
> > out of tables there and return it through mysql, so that the process
> > accessing the data 'thinks' the data has come from mysql.
> > Is this possible?
> > MArk
> >
> > Jan Dvorak wrote:
> > >
> > > Yes, either that or plain text files that Informix dumps and MySQL reads in.
> > >
> > > Jan
> > >
> > > Curtis Maurand wrote:
> > > >
> > > > Perl DBI with the Mysql and the Informix drivers installed.
> > > >
> > > > Curtis
> > > >
> > > > ----- Original Message -----
> > > > From: "MArk Williams" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Monday, March 12, 2001 7:21 AM
> > > > Subject: Can mysql read from Informix
> > > >
> > > > > I have a mysql server running.
> > > > > I would like to be able to select from the mysql DB, but get mysql to go
> > > > > to a remote Informix DB to get the data.
> > > > > Is there anyway of doing that?
> > > > >
> > > > > MArk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
