[ic] MYSQL/IC: Connecting to a second database

Michelle Wilant interchange-users@interchange.redhat.com
Tue Feb 26 13:03:01 2002


Problem:  Need to connect to a second database within IC pages.

I've been searching through the documentation and seen some related 
messages, but nothing exactly on this topic.  We need to connect to a 
second database within IC.  To explain further, we have a corporate 
master products database (mpd).  Currently, we have to get a feed of 
products from this database, and then import it into our IC MYSQL 
database.  We would like to just make queries directly on the mpd and 
then  continue to use our MYSQL database for everything else.  (We need 
to eliminate the feed.)

For example, within the flypage.html, how would we do this? Or would we 
have to set up a global sub and call it from the page?  I've seen things 
such as:  dbi:mysql:database_name;host=111.111.111.111 --

I need a shove here.  Thanks

Michelle