Index: openacs-4/packages/acs-core-docs/www/tutorial-second-database.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/tutorial-second-database.html,v diff -u -N -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-core-docs/www/tutorial-second-database.html 16 Feb 2005 00:21:03 -0000 1.2 +++ openacs-4/packages/acs-core-docs/www/tutorial-second-database.html 26 Aug 2005 00:02:30 -0000 1.2.2.1 @@ -1,4 +1,4 @@ -Connect to a second database
Alex logo
Prev Chapter�10.�Advanced Topics Next

Connect to a second database

It is possible to use the OpenACS TCL database API with +Connect to a second database

Alex logo
Prev Chapter�10.�Advanced Topics Next

Connect to a second database

It is possible to use the OpenACS TCL database API with other databases. In this example, the OpenACS site uses a PostGre database, and accesses another PostGre database called legacy.

  1. Modify config.tcl to accomodate the legacy database, and to @@ -56,8 +56,8 @@ ns_param database_names [list main legacy] ns_param pools_main [list pool1 pool2 pool3] ns_param pools_legacy [list legacy]

  2. To use the legacy database, use the - -dbn flag for any of the - db_ API calls. For + -dbn flag for any of the + db_ API calls. For example, suppose there is a table called "foo" in the legacy system, with a field "bar". List "bar" for all records with this tcl file:

    db_foreach -dbn legacy get_bar_query {