Skip to Content

How to wite a vb-coding for decrypt the password which was stored in sap b1 db?

Aug 02, 2017 at 06:02 AM


avatar image

For Example (login screen)

Username : Manager

password : ss@123

But the password stored in backend is Like this 8D780DF364F3ECA51CDD338432A7D167FDB9088F..

Now the problem is If i created the login screen with link of ousr table. I can't able to login with ss@123(password) via vb coding.. how to solve this issue and how to write a coding to decrypt the given sap paasword which is understandtable to backend

Kindly any one help to solve this issue

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Johan Hakkesteegt Aug 02, 2017 at 06:25 AM


The password in the database is encrypted. Your login will work if you use the DI API method for logging in, and you know what the user name is and what the actual password is.

Public vCmp As Company = Nothing
vCmp = New SAPbobsCOM.Company
With vCmp
    .Server = SBOServer  'name or IP address of your B1 server here
    .DbServerType = BoDataServerTypes.dst_MSSQL2008   'make sure to select the correct sql version
    .LicenseServer = SBOLicenseServer    'name or IP address of your B1 license server here
    .CompanyDB = cmp     'The name of your company database
    .UserName = usr      'the user name that you found before you got to this piece of code
    .Password = pwd      'The actual password
    .language = SAPbobsCOM.BoSuppLangs.ln_English 'or whatever language you like
    .Connect       'This function will try to connect to the B1 company, and will return the integer 0 upon success
End With

So you need to code your addon to first get the user name from OUSR, based on the email address. Please note that technically there can be multiple users with the same email address.



10 |10000 characters needed characters left characters exceeded