Skip to Content

Issue with @variable('BOUSER) in ConnectInit

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 04 at 11:35 AM

    try

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

    also:

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

    Add comment
    10|10000 characters needed characters exceeded