Exception :DBD, [Microsoft][SQL server] ..State: 42000

Hi All,

I have this technical environment:

-BOXIR3.1.

-DB: SQL server 2005.

-OS: Windows server 2003.

When i try to create a report under Deski, with 2 objects, i get this error:

"Exception: DBD, [ ODBC SQL Server Driver][SQL Server]Impossible

de préparer les insctruction.state:42000"

Note : I have tried all the tests(under the server, with administrator account.. ) but i get the same problem under Deski, but under Webi when i create the same Query nothings happen, in other words it works.

I have copied the SQL query:

SELECT

count (distinct (convert(char

(10),dbo.Tbld_CLI_PMSI_RSS.CLI_Donn_NoAbsEpisode)'_'convert(char

(10),dbo.Tbld_CLI_PMSI_RSS.CLI_Donn_NoRSS))),

year(( dbo.Tbld_CLI_PMSI_RSS.CLI_Date_Entree ))

FROM

dbo.Tbld_CLI_PMSI_RSS

*I activated the log, and i send you the 3 *

interesting line:

1- 2009/04/23 16:23:46.449|==| | | 3296|3924| |||||||||||||||BOCSHelper::DoRealCSDescribe( SELECT count (distinct (convert(char(10),dbo.Tbld_CLI_PMSI_RSS.CLI_Donn_NoAbsEpisode)'_'convert(char(10),dbo.Tbld_CLI_PMSI_RSS.CLI_Donn_NoRSS))), year(( dbo.Tbld_CLI_PMSI_RSS.CLI_Date_Entree )) FROM dbo.Tbld_CLI_PMSI_RSS )

2- sqlboAsyncNet.cpp:83:void __cdecl job_thread::Describe|E| | 3296|2044| |||||||||||||||job_thread::Describe : DBD:[Microsoft][ODBC SQL Server Driver][SQL Server]Impossible de préparer les instructions.

Thank you for any suggestion.

Regards,

Aimen

Edited by: Aimen Akriche on Apr 24, 2009 10:35 AM

Edited by: Aimen Akriche on Apr 24, 2009 10:36 AM