Skip to Content
avatar image
Former Member

How can i check sap user and password in my add on application?

Hi all,

I need to create one add on application for my customer.In my app,I have to create log in form like the picture below

When they click Log In, I want to check this user name and password are correct/exist in table OUSR or not. If it has, it can see other form.

So to check the user and password in sap, Anyone know how to do?

Note: I want to execute store procedure in sql server to check user in OUSR table but because of the password is encrypt i don't know how to decrypt.

Thanks

TONY

log in.png (5.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 15, 2014 at 01:09 AM

    Hi Tony,

    Use this

    oCompany.Server = "Server";
    oCompany.LicenseServer = "LicServer:30000";
    oCompany.CompanyDB = "Company";
    oCompany.DbServerType = BoDataServerTypes.dst_MSSQL2012;
    SAPbobsCOM.AuthenticateUserResultsEnum oResult  =  oCompany.AuthenticateUser(bstrUserName, bstrPassword);
    
    

    Regards
    Edy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 14, 2014 at 03:06 PM

    Hi Soeun,

    If you stay in this way, the only solution is to logon on the DI-API.

    But why do you have a need to logon specifically your addon?

    Regards,

    Eric

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2014 at 08:41 AM

    Hi,

    1. oCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2008 
    2.             oCompany.Server = "SAPSERVER" 
    3.             oCompany.LicenseServer = "SAPSERVER:30000" 
    4.             oCompany.CompanyDB = "Promethium_Test" 
    5.             oCompany.UserName = "it" 
    6.             oCompany.Password = "p@ssw0rd"  
    7.             oCompany.Connect 

    regards,

    Prasad

    Add comment
    10|10000 characters needed characters exceeded