Sure, We've been doing it with SQL 2000 for a couple of years now to feed user records into Blackboard. I'll send you an example tomorrow when I get to the office.
> -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Monday, February 20, 2006 5:35 PM > To: CF-Community > Subject: RE: LDAP: Group List > > Nick, can you give an example of a SQL view based on ADSI? > > How do you make the views? SQL Server 2000/2005? > > I current have a DTS package that pulls data from AD. I'm not sure if I > used LDAP or ADSI. I'll have to refresh my memory. > > I'd like to take a look at any examples you can provide. We are moving > to a different student information system *and* SQL 2005 at the same > time. This would be a good opportunity to try something different and > maybe better. > > Thanks! > > -----Original Message----- > From: Nick McClure [mailto:[EMAIL PROTECTED] > Sent: Monday, February 20, 2006 3:46 PM > To: CF-Community > Subject: RE: LDAP: Group List > > When using LDAP there are memory constraints that force the limit to > 1000 records returned. ADSI doesn't have that limitation. > > We use ADSI to query all sorts of things. I actually just make SQL views > based on ADSI queries and can pretty much whatever I want report wise > based onthat. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:197518 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54