[Cross-posted to LISTSERV-DEVELOPERS and LSTSRV-L forums.]


Colleagues,

I am researching the possibility unifying a number of disparate databases
on our web site into a single MS SQL 2000 database.  Therefore, I am
particularly interested in LISTSERV's ability, through an ODBC driver, to
enable MS SQL 2000 to serve as a data store.

Some questions:

1.  The Developers Guide for LISTSERV 1.8e appears silent on the
possibility of using ODBC as a data store for archives.  Is it possible to
do so and if so, how is it done?  (I'm happy to read about this if someone
can point me in the right direction.)

2.  I note in the Developers Guide that there are certain ODBC driver
issues relating to MS SQL:

(a)  LISTSERV ODBC Interface diagnostics error message "[SEVERE] Max active
stmt: 1 - expect uncommitted read & unrequested commits."  I have read the
explanation about this, but do not understand the operational impact this
has.  An explanation will be helpful and appreciated.

(b)  LISTSERV ODBC Interface diagnostics error message "Cursor behaviour
limits ability to commit before logical close."  The manual implies that I
can safely disregard this particular error message.

(c)  I note that MS SQL is configured by default with its equality operator
case-insensitive.  I have the luxury of installing the product from scratch
at this point.  I assume that I should therefore elect to install the
equality operator as case-sensitive.  Correct?

3.  I am considering moving to a ColdFusion-based web site.  My idea is to
unify all of the disparate databases I now use into MS SQL, and then
utilize ColdFusion to develop web-site functions driven by the single
database.  I'm particularly interested in hearing from anyone who has done
this with respect to LISTSERV.  I want to develop my own subscription
system and archive system, using MS SQL as the data storage system and
LISTSERV/LSMTP as the forum system.  Anyone?

Steve


Stephen C. Nill, J.D.
Founder & Chief Executive Officer
[log in to unmask]

<http://charitychannel.com/>CharityChannel.com - The Conference That Never
Sleeps (tm)