Skip to Content

OLE Active Directory Query Not working - Error 0x80040e14

Jan 05, 2017 at 06:37 PM


avatar image
Former Member

So I am trying to query my Active Directory into a Standard Report, and i keep running into this error. Please help. What am i doing wrong?

SELECT CN, LastLogonDate, OperatingSystem, IPv4Address, OperatingSystemServicePack FROM 'LDAP://DC=domain,DC=edu' WHERE objectClass="computer"

10 |10000 characters needed characters left characters exceeded
Former Member

I figured out that the issue is the Integer is a problem for Crystal Reports. What is the correct formatting i need for this parameter screen? What would be the correct SQL syntax to call an integer in?

* Please Login or Register to Answer, Follow or Comment.

0 Answers