Forum OpenACS Q&A: Re: Connecting to 2 or more DB Pool using -dbn of db_* API

Hi!

I’m sorry for about this post but I’ve already solved the problem.

There was a typo error on the 00-database-procs.tcl comments.

<snippet from 00-database-procs.tcl>

# To define what databases exist, and what pools belong to what

# databases, you need to put something like this in your nsd.tcl

# AOLserver config file:

#

#  ns_section ns/server/$server_name/acs/database

#

#    ns_param databases  [list ora pg foo]

#    ns_param pools_ora  [list main subquery log]

#    ns_param pools_pg  [list pg-main pg-subquery pg-log]

#    ns_param pools_foo  [list foo1 foo2]

#

#    ## Optional, see comments:

#    #ns_param driverkey_ora  {oracle}

#    #ns_param driverkey_pg  {postgresql}

#    #ns_param driverkey_foo  {bar}

The line that says: ns_param databases  [list ora pg foo]

Should have been written as: ns_param database_names  [list ora pg foo]

Have a nice day!