Forum OpenACS Q&A: Re: 2nd database

Collapse
2: Re: 2nd database (response to 1)
Posted by Don Baccus on
Study the documentation on the database pools mechanism.  If you're using our standard config.tcl customized for your setup, it should be naming the pools available for OpenACS explicitly.

The idea is that you specify a new pool for the non-OpenACS database, including the correct port and hostname for the machine it is running on.

You then leave that pool out of the list of pools OpenACS should use.  If you're running a relatively recent version of OpenACS (5.0 or better I think) the db_* API allows you to name an explicit pool to grab the handle for running the db_* query you're specifying.  Just give the name of the pool you've set up for the non-OpenACS database, and do your queries (no need for queryfile entries for these of course).

Hope this helps get you started ...