I wonder what if performance would be an issue with an ODBC interface when creating dynamic lists? Some of our lists are very large, i.e. over 4000 members. Perhaps it would not be practical to create dynamic lists of this size? __________________________ Sheree Englehardt Software Developer St. Leo University (352) 588-7590 -----Original Message----- From: LISTSERV give-and-take forum [mailto:[log in to unmask]] On Behalf Of Paul Russell Sent: Monday, September 13, 2010 5:54 PM To: [log in to unmask] Subject: Re: Benefits for Against using ODBC On 9/13/2010 17:41, Valdis Kletnieks wrote: > On Mon, 13 Sep 2010 16:57:12 EDT, Sheree Englehardt said: >> So what are you saying? You can dynamically build lists from an external >> database such as SQL Server? I did not think that was possible. But if it >> is, then I am very interested in knowing more. > > What would be the point of an ODBC interface if it didn't allow you to do this > sort of thing? :) > > Yes, it's possible - but as we've not deployed it locally yet, somebody else > will need to fill in the details. > See http://www.lsoft.com/manuals/15.5/htmlhelp/advanced%20topics/DBMSandMailMergeSupport.6.1.html#2340739 -- Paul Russell, Senior Systems Administrator OIT Messaging Services Team University of Notre Dame