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

[Former Member]

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

[Former Member]

Hi Aimen,

Following solution might be helpful in resolving the issue.

SQL statement is case sensitive in Business Objects.

Follow these steps:

Test the connection in your universe and click Details.

From Details, copy and run the path for the PRM file used by your connection which will open the relevant PRM file in Notepad.

Modify the following parameter (or add to the PRM file if it does not exist) as follows:

<Parameter Name="CASE_SENSITIVE">N</Parameter>

Save the PRM file.

Close and relaunch Designer.

Regards,

Sarbhjeet Kaur

[Former Member]

Thank you Sarbhjeet Kaur,

Whe have tried this solution but the problem persists.

We imported the univers in question and we made changes in the associated PRM file, after that we saved the file and we exported again, unsuccessfully .

I don't uderstand why under webi it works?

Thank you again.

Regards,

Aimen

[MariannevL]

I'm guessing you are working with two-tier Deski?

Then the difference is in the connection to the SQLserver database,

In Webi it is going via the server.

In Deski it is going via the local desktop.

I noticed you use an ODBC connection, that means every local desktop needs this setup,

and the problem could easily be in the local setup of ODBC.

Cant you use OLE DB?

Also notice the PRM file used is different for both types of connection to SQL server,

I don't know which one you tried to change...

Just a bit more info, hope it helps

[Former Member]

Hi all,

Thank you for your response. The problème was in Sql géneration.

In fact, Deski generate the sql without a groupby, and that was the source of the problem.

Installing the Fix pack 1.6 repair the files that was responsible of the Sql generation.

Now it works quite good.

Thank you again.

Regards,

Aimen.