I originally posted this is the wrong group (Crystal Reports - I wish there was an easy way to re-classify your posting......)
CR XI W2003 AD / Terminal Server / Citrix
I'm excellent at creating reports; not great at writing scripts and stored procedures. I need to create a report that shows the AD users 'MemberOf' information.
OU name is 'Locations'
domain name is 'corp' or 'corp.cd'
What I've done so far....
Create New Connection
OLE DB ADO
OLE DB Provider for Microsoft Directory Services {next}
(on this page it asks for data source, user id, password or integrated security - I've selected Integrated Security and left datasource blank)
Then I get a "Add Command" option
I open that up and type in
SELECT name, memberof FROM 'LDAP://OU=Locations,DC=corp.cd'
( I've also tried using double-quotes)
I click on OK and get the following error message
Failed to retrieve data from the database. Details ADO Error Code 0x80040e14
Source: Provider
Description: Table does not exist.
Native Error -2147217900 Crystal
When I use double quotes, I get this error message:
Failed to retrieve data from the database. Details ADO Error Code 0x80040e14
Source: Provider
Description: One or more errors occurred during the processing of command.
Native Error -2147217900
What am I missing? I've tried this as administrator with full access and get the same response.
Any thoughts?
CR is installed on one server, SQL another, and Server yet another. I can see objects in the repository but cannot run them. Getting different errors each time. On the CR SERVER server, all services are running. All updates to the server program have also been installed.
CR XI W2003 AD / Terminal Server / Citrix
I'm excellent at creating reports; not great at writing scripts and stored procedures. I need to create a report that shows the AD users 'MemberOf' information.
OU name is 'Locations'
domain name is 'corp' or 'corp.cd'
What I've done so far....
Create New Connection
OLE DB ADO
OLE DB Provider for Microsoft Directory Services {next}
(on this page it asks for data source, user id, password or integrated security - I've selected Integrated Security and left datasource blank)
Then I get a "Add Command" option
I open that up and type in
SELECT name, memberof FROM 'LDAP://OU=Locations,DC=corp.cd'
( I've also tried using double-quotes)
I click on OK and get the following error message
Failed to retrieve data from the database. Details ADO Error Code 0x80040e14
Source: Provider
Description: Table does not exist.
Native Error -2147217900 Crystal
When I use double quotes, I get this error message:
Failed to retrieve data from the database. Details ADO Error Code 0x80040e14
Source: Provider
Description: One or more errors occurred during the processing of command.
Native Error -2147217900
What am I missing? I've tried this as administrator with full access and get the same response.
Any thoughts?
CR is installed on one server, SQL another, and Server yet another. I can see objects in the repository but cannot run them. Getting different errors each time. On the CR SERVER server, all services are running. All updates to the server program have also been installed.