Issue with @variable('BOUSER) in ConnectInit

[former_member406817]

Hello folks

We are connecting BO/IDT 4.2 to MS SQL Server 2014 and I would like to pass on the BOUSER in the connection so that we can rely on back-end security. The following is the code we used :

declare @binUserGuid varbinary(128);declare @userGuid uniqueidentifier;SELECT @userGuid=SystemUserId FROM SystemUserBase WHERE UPPER(DomainName)=UPPER('@variable('BOUSER')'); set @binUserGuid = cast(@userGuid as varbinary(128)); set context_info @binUserGuid;

This code works when I hardcode the user like UPPER('dev\user1'), but it does not work when we use UPPER('@variable('BOUSER')'). Does anyone know why it does not work when I use @variable('BOUSER')?

Thanks for your inputs

Jhn

[ayman_salem]

try

UPPER('@variable('BOUSER')') ------> UPPER(@variable('BOUSER'))

also:

the variable BOUSER will not include the domain (i.e dev\) it will be only user1