[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)