DESKI - ODBC SQL 2008 R2

building semantic layer
1

Hi All,

I have a user who is using boxi 3.1 sp3 deski, I have created an odbc on user’s machine and tested all works.

The db is sql 2008 r2

User on Windows xp and db on sql server 2008.

After selecting a few objects and running the report the following error message appears:

Error message :

Exception: DBD, [Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER]Statement(s) could not be prepared.State: 42000

When the user uses, webi for report development all ok…

From my analysis it is the odbc driver that’s need updating, please can you advise if you have come across this problem?

Bell_33 (BOB member since 2010-07-05)

2

You need to load the 2008 R2 native drivers.

They can be found here in the SQL Server 2008 R2 Feature pack. You don’t need to download and load the entire feature back, just scroll down and you will find the driver here.

Take an inventory of your connections and make sure you have the native drivers for all that exist, they are faster then using generic windows drivers.

http://www.microsoft.com/download/en/details.aspx?id=16978

tenather :us: (BOB member since 2002-08-29)

3

Thanks downloaded the driver and the sql native driver there but still getting the same error message…

Any ideas?

Bell_33 (BOB member since 2010-07-05)

4

Strip the SQL out of DESKI and run it via the SQL Server Management Studio 2008 R2 to find out where the problem is.

Then using those findings you might have to adjust the Universe. This is not unusal when making a transition from one release to another, just extremely annoying!! :hb:

tenather :us: (BOB member since 2002-08-29)

5

Thanks, but identified the BOXI download of all the applications was not installed correctly. Correct installation has resolved issue.

Thanks

Bell_33 (BOB member since 2010-07-05)