Linked Server and iPlanet

[FancyPrairie]

I'm having trouble linking to iPlanet where the provider is Microsoft Active Directory Service and the Data Source is adsDataSource.

When I issue the following command, iPlanet stops.

SELECT TOP 100 PERCENT *
FROM OPENQUERY(ADSI, 
                      'SELECT  sn, uid, telephoneNumber, roomNumber,  employeeNumber, givenName, displayName, cn FROM ''LDAP://xxx/ou=zzz,ou=ddd,dc=ee,dc=ffff,dc=com'' ')

I have created a linked server to Active Directory and issue, basically, the same command. So I'm thinking I have not defined the provider information or something correctly when the linked server was created.

Can someone shed some light on this?

 

[mrdenny]

Here is how to query AD via SQL Server.

thread183-1273100

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[FancyPrairie]

mrdenny,

I guess I wasn't clear on what I am attempting to do. I was able to setup a linked server for Active Directory and query it without a problem. (However, like most people I ran into the 1000 record limit. I've read about overcoming this by using the OpenRowSet method and setting the pagesize rather than the OpenQuery method, but have not had any luck with it. Right now I'm using a stored procedure that uses ADODB to get around the pagesize problem.)

My problem is that I'm trying to query AVAYA data (AVAYA is a company that handles phone systems). They store their data in Active Directory or LDAP or whatever the terminolgy is. However, to avoid potential problems with our ActiveDirectory, we are using iPlanet to host AVAYA data. So, my question is how do I setup a linked server for that. My openquery method works when opened via ADODB but not as a query. I'm assuming I setup the linked server incorrectly.

 

[mrdenny]

What's the error message that you are getting.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[FancyPrairie]

An error occurred while preparing a query for execution against OLE DB provider 'ADsDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare:repare returned 0x80040e14].

 

[mrdenny]

Seams like iPlanet doesn't like the AD driver. See if they offer an LDAP ODBC driver (or if there are any that you can download and try from a 3rd party).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com