cannot query directory services

Dear all,
I would like to query informations that are located in the (AD) Active
Directory Windows 2003 with my server Windows 2000SP4 and MS SQL 2000 SP4 in
the same domain and AD.
I create the link server with the following script :
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'
GO
and I query AD with the following :
SELECT [Name], SN [Last Name], ST State
FROM OPENQUERY( ADSI,
'SELECT Name, SN, ST
FROM ''LDAP://ADSISrv/ OU=myOU,DC=mycompagny,DC=com''
WHERE objectCategory = ''Person'' AND
objectClass = ''contact''')
GO
Then I get the following error :
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'ADSDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prep
are
returned 0x80040e14].
I clarify that I used Integrated Windows security and also used the USERID
and password of service SQLserver as recommanded to launch my query.
But I get the above error. Why ?
Thanks for your next reply,
JobHi
You may get a better response in the ADSI news groups e.g
microsoft.public.adsi.general, but I think the error is probably because the
syntax of your query is incorrect, check out
http://msdn.microsoft.com/library/d...ap_provider.asp
John
"Job" wrote:

> Dear all,
> I would like to query informations that are located in the (AD) Active
> Directory Windows 2003 with my server Windows 2000SP4 and MS SQL 2000 SP4
in
> the same domain and AD.
> I create the link server with the following script :
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and I query AD with the following :
> SELECT [Name], SN [Last Name], ST State
> FROM OPENQUERY( ADSI,
> 'SELECT Name, SN, ST
> FROM ''LDAP://ADSISrv/ OU=myOU,DC=mycompagny,DC=com''
> WHERE objectCategory = ''Person'' AND
> objectClass = ''contact''')
> GO
> Then I get the following error :
> Server: Msg 7321, Level 16, State 2, Line 1
> An error occurred while preparing a query for execution against OLE DB
> provider 'ADSDSOObject'.
> OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Pr
epare
> returned 0x80040e14].
> I clarify that I used Integrated Windows security and also used the USERID
> and password of service SQLserver as recommanded to launch my query.
> But I get the above error. Why ?
> Thanks for your next reply,
> Job
>
>

cannot query directory services

Dear all,
I would like to query informations that are located in the (AD) Active
Directory Windows 2003 with my server Windows 2000SP4 and MS SQL 2000 SP4 in
the same domain and AD.
I create the link server with the following script :
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'
GO
and I query AD with the following :
SELECT [Name], SN [Last Name], ST State
FROM OPENQUERY( ADSI,
'SELECT Name, SN, ST
FROM ''LDAP://ADSISrv/ OU=myOU,DC=mycompagny,DC=com''
WHERE objectCategory = ''Person'' AND
objectClass = ''contact''')
GO
Then I get the following error :
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'ADSDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare
returned 0x80040e14].
I clarify that I used Integrated Windows security and also used the USERID
and password of service SQLserver as recommanded to launch my query.
But I get the above error. Why ?
Thanks for your next reply,
JobHi
You may get a better response in the ADSI news groups e.g
microsoft.public.adsi.general, but I think the error is probably because the
syntax of your query is incorrect, check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/adsi_ldap_provider.asp
John
"Job" wrote:
> Dear all,
> I would like to query informations that are located in the (AD) Active
> Directory Windows 2003 with my server Windows 2000SP4 and MS SQL 2000 SP4 in
> the same domain and AD.
> I create the link server with the following script :
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and I query AD with the following :
> SELECT [Name], SN [Last Name], ST State
> FROM OPENQUERY( ADSI,
> 'SELECT Name, SN, ST
> FROM ''LDAP://ADSISrv/ OU=myOU,DC=mycompagny,DC=com''
> WHERE objectCategory = ''Person'' AND
> objectClass = ''contact''')
> GO
> Then I get the following error :
> Server: Msg 7321, Level 16, State 2, Line 1
> An error occurred while preparing a query for execution against OLE DB
> provider 'ADSDSOObject'.
> OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare
> returned 0x80040e14].
> I clarify that I used Integrated Windows security and also used the USERID
> and password of service SQLserver as recommanded to launch my query.
> But I get the above error. Why ?
> Thanks for your next reply,
> Job
>
>sql

cannot query directory services

Dear all,
I would like to query informations that are located in the (AD) Active
Directory Windows 2003 with my server Windows 2000SP4 and MS SQL 2000 SP4 in
the same domain and AD.
I create the link server with the following script :
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'
GO
and I query AD with the following :
SELECT [Name], SN [Last Name], ST State
FROM OPENQUERY( ADSI,
'SELECT Name, SN, ST
FROM ''LDAP://ADSISrv/ OU=myOU,DC=mycompagny,DC=com''
WHERE objectCategory = ''Person'' AND
objectClass = ''contact''')
GO
Then I get the following error :
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'ADSDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare
returned 0x80040e14].
I clarify that I used Integrated Windows security and also used the USERID
and password of service SQLserver as recommanded to launch my query.
But I get the above error. Why ?
Thanks for your next reply,
Job
Hi
You may get a better response in the ADSI news groups e.g
microsoft.public.adsi.general, but I think the error is probably because the
syntax of your query is incorrect, check out
http://msdn.microsoft.com/library/de...p_provider.asp
John
"Job" wrote:

> Dear all,
> I would like to query informations that are located in the (AD) Active
> Directory Windows 2003 with my server Windows 2000SP4 and MS SQL 2000 SP4 in
> the same domain and AD.
> I create the link server with the following script :
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and I query AD with the following :
> SELECT [Name], SN [Last Name], ST State
> FROM OPENQUERY( ADSI,
> 'SELECT Name, SN, ST
> FROM ''LDAP://ADSISrv/ OU=myOU,DC=mycompagny,DC=com''
> WHERE objectCategory = ''Person'' AND
> objectClass = ''contact''')
> GO
> Then I get the following error :
> Server: Msg 7321, Level 16, State 2, Line 1
> An error occurred while preparing a query for execution against OLE DB
> provider 'ADSDSOObject'.
> OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare
> returned 0x80040e14].
> I clarify that I used Integrated Windows security and also used the USERID
> and password of service SQLserver as recommanded to launch my query.
> But I get the above error. Why ?
> Thanks for your next reply,
> Job
>
>

Cannot open SSIS project in BIDS

Hi,
I have been working on an SSIS project for sometime now. The project files are located on a remote server. Suddenly I am not able to open the solution I get a lot of error messages and all the data flow taks are gone. I later found out that SSIS encrypts packages, so that other users will not be able to see them. Fine, but I have been using the same windows user account for months now. What could be the problem?
This is what I get when trying to open the solution:

There were errors while the package was being loaded.
The package might be corrupted.
See the Error List for details.

And the error list also contains messages saying "Could not load from xml".

Any pointers will be much appreciated.

TIA
Can you please post the specific errors you are receiving? You can copy and paste from the error list.|||Hi,
thanks for that quick reply.
Here are the error messages from the error list.
There are 9 control flow tasks and these three messages seem to
occur for all of them.

Error 1
Error loading RecruteToTempJobs01.dtsx: Unable to instantiate
XML DOM document, please verify that MSXML binaries are properly
installed and registered.
d:\ssis\RecruteToTempJobs01.dtsx

Error 2
Error loading RecruteToTempJobs01.dtsx: Unable to load from
XML. d:\ssis\RecruteToTempJobs01.dtsx

Error 3
Error loading RecruteToTempJobs01.dtsx: Error loading a task.
The contact information for the task is "Performs high-performance data
extraction, transformation and loading;Microsoft Corporation; Microsoft
SQL Server v9; (C) 2004 Microsoft Corporation; All Rights
Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when
loading a task fails.
d:\ssis\RecruteToTempJobs01.dtsx|||

Could you try to register xml libraries on your machine:

regsvr32 msxml3.dll

regsvr32 msxml6.dll

Try to search this forum and you will find a lot of details about issues similar to the one you are seeing.

Thanks.

|||Thanks a ton Bob, that worked!

Just curious, what could have happened to require the dlls to be registered. I didn't register them before and things were working fine.

Thanks once again!
|||

I do not remember exactly. Some setup issues...

Try to search this forum, there was a lot of posts about this.

Thanks.

|||This is quite likely a setup issue in an entirely different application. These DLLs are used by a wide range of applications, and any one of them could have a dodgy installer, stuff you may not even think about. For example I have seeen several instances of "security patches" being deployed via SMS that have broken the registration for one or more of the MSXML versions.|||

Thanks for the information Darren,

the culprit must be one of those 'security patches' in my case I guess!

Thanks.