Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Querying Active Directory (AD / LDAP) (Read 4574 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Querying Active Directory (AD / LDAP)
13.12.05 at 16:22:49
Successful tests with SQL*XL to connect to Active Directory were performed using SQL*XL 4.0.31.  
Data can be retrieved using SQL but it behaves a little different than a relational database. Unfortunately no dictionary information can be shown in SQL*XL. It seems to be a fundamental difficulty with AD.
The basic syntax to retrieve data is to use one of the following LDAP paths:  
select * from 'LDAP://myserver'
select * from 'LDAP://'
select * from 'LDAP://DC=mydomain,DC=com'
Back to top
« Last Edit: 14.12.05 at 10:10:08 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1