[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