Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-06 : 20:27:23
|
| Swetal writes "I am running SQL 2000 on a Windows 2000 Server and I wish to create a view with information from a Lotus Notes LDAP directory. I used sp_addlinkedserver and sp_addlinkedsrvlogin to create a Linked Server. When I run a query using either SQL or LDAP notation with the attribute set to "*" all I get in the result set is the AdsPath for the LDAP filter. If I use anything other than "*" such as "CN" I get the error:Could not get the data of the row from the OLE DB provider 'ADSDSOObject'. Could not convert the data value due to reasons other than sign mismatch or overflow.My queries look like this:SELECT CN FROM OPENQUERY (LDAP, 'SELECT CNFROM ''LDAP://ldapserver/O=Company'' WHERE objectClass = ''*''')orSELECT * FROM OpenQuery (LDAP, '<LDAP://ldapserver/O=Company>;(objectClass=*);*;subtree')Any suggestions?? Any help is apprecaited. Thanks." |
|
|
|
|
|
OLE DB for ADSI querying LDAP directory.