ASORGS (AS0020) decrypt password?

[danielz13]

Hi, I'm trying to create an ODBC connection to the company db and I was wondering if anyone can tell me how to decrypt the Signon Password in the view AS0020?

Also, in the case of multiple company databases, how can I tell which is the active company?

thanks,

Daniel

 

[ettienne]

You cannot decrypt the password.
AccpacSession.CompanyID gives you the current company.

 

[DjangMan]

You can use view CS0120 if you are working with 5.5 or 5.6. That will let you run SQL directly against the database that the view is logged into.

 

[johnhugh]

This may or may not help you.
A while back I came across the link below looking for a way to recover lost passwords.

http://www.rockryno.com/accounting/ACCPAC-Password-Lister-Excel-VBA-Module-425-.htm

 

[DjangMan]

Wow - that's an interesting post to say the least. yikes!

 

[Jay Converse]

I'm astounded we've never seen that before. Must be a rogue DPP person out there, the official line has always been it couldn't be done.

 

[Jay Converse]

FWIW, I just tested that code, it doesn't work on my 5.6 version files. Perhaps that hole has been plugged.

 

[ettienne]

Interesting, but that's the users' passwords from users.ism and not the SQL db password from orgs.ism
Besides, I don't get past error 23 on isamOpen.

 

[Jay Converse]

Good point.

If your file string "xxxxx\SITE\BROWSE", not BROWSE.ISM, you'll get past error 23, the function assumes the ISM extension (just like the Accpac Plus functions did, OMG, I just had a Plus flashback!). It reads the names alright, but the "decrypted" passwords are garbage.

 

[ettienne]

I checked the SDK docs and saw that the .ism extension is added, my problem was that I used a mapped drive. Once I used the natural path it was happy, and as you say the passwords are returned garbled. This might have worked on the older versions where passwords were what... 8 characters upper case only?

 

[mlnick]

I just tried this with 5.3 and it works.

 

[ettienne]

But it's of no use in version 5.4 and higher, the passwords are encrypted in the newer versions and the macro cannot decrypt it. There is actually an easier why to get the user passwords in the older versions, but the point is moot.

 

[Jay Converse]

5.3? That's a dead version.