How to extract current user SQL password from SAP

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member]

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.

[Former Member]

I guess it wouldnt be very wise from SAP if everyone could spy passwords via SDK..Single Sign On does the job fine.

Regards

Clemens

[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