Skip to Content
avatar image
Former Member

How to extract current user SQL password from SAP

I have an external exe that needs to connect via ADO to the currently running SAP application using the current user.

I used the SAPbobsCOM.Company object to extract the

CompanyDB , Server ,DbUserName and Password to create my ADO connection string. But obviously the password is encrypted and (when I debug.print gives me ****) is not useful.

Does anyone know how to get this password through the SDK?

Thanks,

Indika.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 11, 2004 at 05:55 AM

    Hi,

    I've already asked about it. No way. Simply forget.

    You can ask for password for the first time and store it in the database or in the registry.

    Regards,

    Mark

    Message was edited by: Mark Gulyansky

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2004 at 08:54 AM

    You can connect to a running SBO application via UI-API, call the dialog for changing the company (simulate click-events on [Administration - Choose company] and read out the password field (and other important fields to establish a database connection). That's a way in SDK 6.2 to connect via UI and DI without requesting the user for repeated input of the login data, because single-sign is available first in SDK 6.5.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I don't think SDK is the tool for everyone. If I make my job for customer I'm know his password anyway, but my program don't. About Single SignOn - it's good thing, but what to do if you need to run some SQL stored procedure via SQL connection? You need the password.

      Best regards,

      Mark