Skip to Content
Former Member
Feb 23, 2011 at 08:53 PM

Unable to Connect to LDAP from Crystal Reports 11.5 through OLE DB (ADO)


I am receiving the following error when trying to connect to my LDAP through Crystal Reports 11.5:

Failed to retrieve data from the database

Details: ADO Error Code: 0x

Source: Provider

Description: One or more errors occurred during processing of command.

Native Error: [Database Vendor Code: -2147217900 ]

The LDAP I am trying to connect to is:

CA Provisioning Manager

Release: 12.5.4 (Build 065822 0.0)

The syntax that i am using in crystal reports 11.5 is:

OLE DB Provider: OLE DB Provider for Microsoft Directory Service

DatabaseType: OLE DB (ADO)

DataSource: ldap://<ServerName>:20389/

UserId: eTGlobalUserName=etaadmin,eTGlobalUserContainerName=Global Users,eTNamespaceName=CommonObjects,dc=im,dc=eta

Password: **************

Comment: SELECT *

I am able to connect to this LDAP through a LDAP browser ( Softerra LDAP Brower 2.6).

I am sure that the credentials are correct.

I am also having confusion with the Add Comment Section after Clicking Finish from the Connection information in the Standard Report Creation Wizard in Crystal Reports 11.5.

Any assistance would be greatly appreciated.

Darius Beckett