Hi,
How much do you know about Oracle (particularly, configuring the
Oracle Net8 client)?
Presuming you configured the Net8 client to connect to your Oracle
instance (in other words, you can connect to your Oracle database
using something like SQL*Plus) ... setting up the database pool
in AOLserver is fairly straightforward.
First, in your nsd.tcl, you need to define the database driver:
ns_section "ns/db/drivers"
ns_param ora8 ora8.dll
(We're assuming that you placed the ora8.dll in your bin/ directory
where the other .dll's live.)
Then, you need to define a database pool:
ns_section "ns/db/pools"
ns_param ora_db "Your Oracle Database Pool"
Then, you need to define the attributes of the database pool:
ns_section "ns/db/pool/sysmon_db"
ns_param driver ora8
ns_param connections 4
ns_param user <insert_username_here>
ns_param password <insert_password_here>
ns_param datasource <insert_oracle_sid_here>
Don't worry about tuning the "connections" parameter until you
have everything working. Obviously, replace the <insert_..._here>
with the appropriate values.
Then, you need to define the database settings for the actual
webserver instance (assumed to be set to $servername somewhere
earlier in your nsd.tcl script):
ns_section "ns/server/${servername}/db"
ns_param defaultpool ora_db
ns_param pools *
Then, all you have left to do actually create pages that use
the ns_db API to interact with the database.
- Dossy
On 2001.04.12, Ling Wang <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I installed Windows version of AOLServer from
> ftp://ftp.aolserver.com/pub/misc/as32-win32-installer.zip and downloaded
> the driver for Oracle8 from http://www.arsdigita.com/acs-repository/oracle-
> driver-2.5.tar.gz. I compiled the driver source code without any problem.
> But I just could not figure out from the sketchy description in the readme
> file and other webpages as to how to configure it (change my nsd.tcl file).
> Can anyone who has the experience send me a sample configureation file
> (nsd.tcl file) showing exactly what to do to make it my WinNT Oracle8 work
> with my WinNT AOLServer? I don't know much about UNIX.
>
> Thanks in advance.
>
> Ling Wang
--
Dossy Shiobara mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/
