ConnectInIt Parameters for SQL server 2008 using odbc connecter

[Former Member]

Hi ,

I am trying to add connectInIt parameters in universe connection which is connecting to SQL server 2008 using odbc.

I tried various parameters but getting error every time. Below are the parameters I am using

SET ApplicationName(@variable('UNVNAME')'); FOR TRANSACTION;

Env: BI4.1 SP4 IDT or UDT

Please suggest me if this can be possible or not ?

Regards,

Rohit Vamsi

[former_member193452]

Hi Rohit,

You should be able to add the parameter to connectinit.

Can you collect tracing to see what is being passed to sql server?

[former_member193452]

Hi Rohit,

Try this.

Add the parameter to the sqlserv.sbo file

Parameter Name="Optimize Execute">True

(True)

Re-start the Universe Tool

< installation folder of the business objects>\SAP BusinessObjects Enterprise XI 4.0\Dataaccess\Connection server\odbc\

also please check the wiki: http://wiki.scn.sap.com/wiki/x/lAJcFg

But the Set applicationName=@Variable('UNVNAME');For Transanction;

[Former Member]

Hi Jacqueline,

Thanks for the reply.

Which Parameter I need to add in sqlserv.sbo file ?

Regards,

Rohit Vamsi

[former_member193452]

Hi Rohit,

sorry about that.  It looks like my copy paste dropped the parameter that had the html encoding.  I edited the previous reply to add the parameter

(<Parameter Name="Optimize Execute"= True>)

Hope that helps

[Former Member]

Hi Jacqueline,

The parameter is already set to true in sqlsrv.sbo file. I have added

Set applicationName=@Variable('UNVNAME');For Transanction; in connectinit

I get the below error when I refresh report in BILaunchPad

[Former Member]

Hi JAcqueline,

Is it possible to use connectinit parameter if the reporting datase server is SQL server 2008 and BO is connecting the reporting server using odbc ?

Regards,

Rohit Vamsi