You can export / import data in AD by database connection You can use oledb provider
If you use visual basic 6.0 you can set the ado object to this connection string
adodc1.connectionstring = "Provider=ADsDSOObject;Encrypt Password=False;Integrated Security=SSPI; Location=< the server name Ex: a domain controller > ;Mode=Read;Bind Flags=0;ADSI Flag=-2147483648"
you can interrogate the AD in the recordsource property Ex:
adodc1.recordsource = "<LDAP://DC=MICROSOFT,DC=COM>;(objectClass=*);AdsPath, cn; subTree"
you can export the data in a datagrid or othet visual object (excel worksheet) to have what you need.
Bye
PS: It's better to substitute Microsoft with another AD domain
From: "Narkinsky, Brian" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: [ActiveDir] ODBC query of Active DIrectory
Date: Thu, 16 Oct 2003 10:25:31 -0400
MIME-Version: 1.0
Received: from mail.activedir.org ([64.245.160.7]) by mc6-f10.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 16 Oct 2003 07:28:24 -0700
Received: from tlhexsprot2.floridadep.net [199.73.152.177] by mail.activedir.org with ESMTP (SMTPD32-8.03) id AA5CE650074; Thu, 16 Oct 2003 10:25:32 -0400
Received: from tlhexsmb3.floridadep.net ([172.20.30.46]) by tlhexsprot2.floridadep.net with Microsoft SMTPSVC(5.0.2195.4905); Thu, 16 Oct 2003 10:25:31 -0400
X-Message-Info: yilqo4+6kc6E5jjLp3UcOo1PEp/AAGul
X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0
content-class: urn:content-classes:message
Message-ID: <[EMAIL PROTECTED]>
X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ODBC query of Active DIrectory
Thread-Index: AcOT8Vq4q2TQ7SHrRdC82sggDGz0RA==
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 16 Oct 2003 14:25:31.0835 (UTC) FILETIME=[5AEC68B0:01C393F1]
Precedence: bulk
Sender: [EMAIL PROTECTED]
Is it possible to set up an ODBC to Active Directory? I wish to do some reporting using Access and apart from dumping and importing flat files I haven't found a way to do it.
Brian
Brian Narkinsky
System Manager
Department of Environmental Protection
MS 6520
2600 Blairstone RD
Tallahassee, FL 32399
phone (850)245-8314
fax (850)412-0400
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
