An error occurred while preparing a query for execution against OLEDB provider

Asked By JesseJones 0 points N/A Posted on - 08/16/2011

Hello All,

I am posting this error message here so I can get help on this as soon as possible. Every now and then the SQL server connection to the Active Directory will crash.

I have SQL server installed on Windows server 2003. When I try to create a view in SQL with Active directory users I am getting this error message.

Any ideas why?

 

SQL Server Enterprise Manager

[Microsoft][ODBC SQL Server Driver][SQL Server]An error occurred

while preparing a query for execution against OLEDB provider

‘ADSDSOObject’.

 

• Status: Open
• Question Views: 3118
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Windows 2003

Best Answer by kevinnash

Go To Solution

Best Answer

Best Answer

Answered By kevinnash 0 points N/A #115131

An error occurred while preparing a query for execution against OLEDB provider

 

Yes, there was this problem once getting renowned but now it is easy to fix. Try the following and you will be fine with it. 

Add the 'MSDTC' to the registry. This must be done by adding the registry keys. If it is known, the no problems. If no, try the following:

In the key field, add  –  Key: [HKEY_LOCAL_MACHINESYSTEMCURRENTCONTROLSETSERVICESMSSQL]

Then in Value name, add  –  Value Name: DependOnService

After that, make value type to this one  –  Value Type : REG_MULTI_SZ

After that the value must be equal to MSDTC.

Cheers.

About kevinnash

Questions
0

Answers
10

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/29/2011
• Question Category: Windows 2003

Answered By marsh watson 0 points N/A #115132

An error occurred while preparing a query for execution against OLEDB provider

 

You can note that this error message refers to the query that contains incorrect syntax. This must have some unbalanced quotes. You can have it resolved using any of the following techniques,

·         You can use VBScript for such queries and can use single quote characters in your desired SQL statement within the string.

·         Do these steps,

o   Define the server linked (which has been used in SQL).

o   Search the LDAP names which you want to use in the query.

o   To get them, use the SELECT statement.

About marsh watson

Questions
2

Answers
108

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 12/05/2012
• Question Category: Windows 2003