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