LSTOWN-L Archives

LISTSERV List Owners' Forum

LSTOWN-L

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Topic: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Eric Thomas <[log in to unmask]>
Sat, 9 Jan 1999 20:52:37 +0100
text/plain (22 lines)
>(1) If multiple lists are using the DBMS interface, do their tables all
>have to be in the same DBMS?

Currently, the drivers only support a single DBMS connection. The data
can be in different physical DBMS if they are networked together. With
NT you can also have both OCI and ODBC drivers active and use two
DBMS concurrently. Another way is to run multiple copies of LISTSERV
connecting to one DBMS each. There isn't much demand for having
some lists on Oracle, some on SQL and some on DB2 from the same
logical LISTSERV instance, the typical multi-DBMS case is where you
have multiple offices which each have an Oracle database for their
WWW visitors, and that only requires a single DBMS connection.

>(2) Can OCI connect to any non-Oracle DBMSs, such as DB2, MS SQL
>Server, and/or Sybase?

OCI connects only to Oracle. There are "gateway" products available
from Oracle which would probably allow the use of SQL Server through
OCI, but I don't really know much about this.

  Eric

ATOM RSS1 RSS2