Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
OLE COM ADO CDO ADSI LDAP
 | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
- !! A List of Links to various OLE docs !!
- !! Understanding COM !!
- 1129 ObjectCreate
- 1129 OleInitiate Failed UAC
- 1129 OleInitiate Failed
- 1251 Ole - WIL Ole interface Dll not found
- Access to Excel Converter
- Access2000 Transaction Processing Demo
- Add Application to the Windows Firewall Exceptions List
- ADO vs ODBC
- ADO vs OLEDB vs ODBC
- Automatic Update from MicroSoft
- Bring up the RUN Dialog
- BYREF return parameters
- Close All Open OLE COM Objects
- Close an Object
- Closing Objects Explained
- Code to Create a Temporary DB
- Collaboration Data Objects Roadmap
- COM Constants for MS Office Applications
- COM Interfaces Explained
- COM Widestring Value Issue
- CommandTimeOut - lesson learned
- Connection String
- Convert Data Returned OLE
- Converting Pre 2004B OLE Scripts
- Copy Table Structure With SQL
- Create Object
- Create Recordset in Memory
- CreateObject Remote Computer
- Database ISAM Example
- dBase IV Creation
- Delete Mailbox in Exchange
- Determining if a Particular Update has Been Installed
- Determining Whether Automatic Updates is Enabled
- Display the Windows Run Dialog Box
- Does WinBatch Support 3rd party COM objects
- DSO Tabular Paging Demo
- Enumerate Citrix Applications
- Find Object Name and Properties
- Find User on Workstation
- ForEach Problem
- Generate GUIDs using ObjectType
- Get Audio File Information
- Get Information for IOMega Zip Drive
- Get Number of Records in Each Table
- Getting Multivalued Properties and Arrays
- GUID Create
- Handle Reassignment
- How to include an Office Assistant
- Insert Data into an SQL Server 2000
- Install CAPICOM on Win7
- Intcontrol 71 and Number of OLE Channels
- Interacting with Citrix
- IPCONFIG Results From STDOUT
- IsObject UDF
- List Components in Com Catalog
- List Databases on a Server
- List OLE DB Providers
- Load Data from ASCII File to a Java Applet Window
- MatLab COM Automation
- Method with Variant Parameters Explained
- Multi-Dimensional SafeArrays are NOT supported
- Named Parameters
- Object 101
- ObjectCreate Cannot Access Remote Server
- ObjectEventAdd Issue
- Office 2007 Driver Tips
- OLE COM Default Member Discussion
- OLE Explanation
- OLE Failing unless IE4 Installed - DCOM98
- OLE Property and Method Name Limit
- OLE Shell functions
- OLE2 Automation Tips
- Open DB and Permit Working with Tables
- Oracle Objects
- Pass ByRef Type Parameter
- Passing an Array as a Parameter to an OLE Method
- Passing Parameters
- Primer - Fabricated Hierarchical Recordsets
- Problems Writting a VB to WinBatch OLE Code Converter
- Read and Write to a Parallel Port
- RecordSets to HTML - with some Javascript
- Regular Expressions with WB
- Remotely Stop or Start COM Components
- Sample Code to Query a MIMSXServer
- Save Binary Streams to DB
- Set Proxy Server and Port
- Setting Group Policy Objects
- Shell ExtendedProperty
- Shell Helper Object
- SQL Server Update Stored Procedure
- Textract Problem
- textract test
- TextStream and Scripting.FileSystemObject
- Translate VB Default Member Name
- Trapping COM OLE Errors
- UDF to Return an Array of DB Table Types
- Un supported Variant Type Error With Concatenation
- Unicode Conversions with FileSystemObject
- Using the Object Browser
- Using the Visual Basic Object Browser
- Vbscript Array in WIL
- Virtual Server COM CoInitializeSecurity
- VT_DECIMAL Versus FLOAT
- WinBatch and Dot NET
- WinBatch Equivalent To VB Nothing
- WinBatch OnError
- Windows Firewall
- Windows Image Acquisition
- Working with Office Applications
- Write-Read DBF
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Getting multivalued properties in from Exchange
Keywords: arrays exchange adsi
Question:
I'm trying to extract the distribution list membership of an Exchange mailbox. It works great if the mailbox only belongs to one list:User="TEST1" (0) VALUE=> "TEST1" Div="TEST" (0) VALUE=> "TEST" ADsPath="LDAP://OCAREX2/cn=TEST1,cn=TEST,cn=Recipients,ou=OCAR,o=ORGANIZATION" (0) VALUE=> "LDAP://OCAREX2/cn=TEST1,cn=TEST,cn=Recipients,ou=OCAR,o=ORGANIZATION" adsUser=ObjectAccess(ADsPath,0) (297) VALUE=> 33333 Members=adsUser.memberOf (422) VALUE=> "cn=OCAR TEST,cn=Mailing Lists,cn=Recipients,ou=OCAR,o=ORGANIZATION"However, if the mailbox belongs to more than one list (ie membersOf becomes multivalued) the script fails:
User="TEST1" (0) VALUE=> "TEST1" Div="TEST" (0) VALUE=> "TEST" ADsPath="LDAP://OCAREX2/cn=TEST1,cn=TEST,cn=Recipients,ou=OCAR,o=ORGANIZATION" (0) VALUE=> "LDAP://OCAREX2/cn=TEST1,cn=TEST,cn=Recipients,ou=OCAR,o=ORGANIZATION" adsUser=ObjectAccess(ADsPath,0) (312) VALUE=> 33333 Members=adsUser.memberOf (1359) VALUE=> 0 TERMINAL WIL ERROR=>1249 (Ole Object: Could not process value returned from object)Gotta be something simple, right? What's the syntax I need?
Answer:
There are limitation to the type of data that the object function in WinBatch can handle. For example....Arrays, some objects have properties and methods that return an array of data or take an array as an argument. WIL cannot process these types of properties or methods.You might consider using the Beta ADSI extender to handle this....
AddExtender("wwads34I.dll")
; Set credentials.
dsSetCredent("bill", "Guesswho")
; User.
sUserPath = "LDAP://win2000/cn=Homer Simpson,cn=users,
DC=win2000,DC=windowware,DC=com"
;Group specified with common name.
sGroupPath = “LDAP://win2000/cn=Toon,DC=win2000,DC=windowware,DC=com"
; Check for group membership.
if dsIsMemberGrp( sGroupPath, sUserPath) then sResult = "Is a toon"
else sResult = "Is not a Toon."
message(sUserPath, sResult)
Unfortunately this requires that the MS ADSI support files be
installed on any NT4 box.
Article ID: W14670
Filename: Getting multivalued properties and Arrays.txt
File Created: 2001:03:01:13:20:22
Last Updated: 2001:03:01:13:20:22