Recover Sybase password

Posted on 2010-04-09
Medium Priority
Last Modified: 2012-05-09

I have a sybase db file which I need to access.  It seems to be using an Adaptive Server Anywhere SQL driver.

Any ideas as to how I can recover/reset password?

Many thanks
Question by:kenabbott
  • 2
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 30285135
Short answer: you can't.

No, seriously. Sybase themselves say in the ASA manuals that they can't recover a password for you.

Also, ASA .db files are not just files you open like you would open a .doc or .xls file. You can't do a thing with it unless you have the database engine that is used to run it. ASA .db files are just low-level device files used as storage by the database engine, and you need that engine to open the database which has been stored in them.

Usually this has to be the same or a very close match to the version of the engine used to create the database stored in that .db file. The driver you mention is likely just the ODBC driver client tools use to talk to the database once the ASA engine was up and running it.

Tell us more about your problem and maybe we can find you another approach. The late grant300 (RIP) once had some success with opening files up in a low-level hex editor, changing a password and noting what bytes had changed, and using that to try to reverse engineer the encrypted form of the password in an existing file. Basically you need some clever hacking to do this. I've never actually attempted this but it doesn't sound very easy. :)

Author Comment

ID: 30316490
So are you saying that even if I had the username password for the file I still couldn't use the ODBC driver to link the file to, for example, an Access db?

I have the front end to this but I really want to get to the tables
LVL 24

Accepted Solution

Joe Woodhouse earned 2000 total points
ID: 30318414
Yes. You need more than the .db, the ODBC driver and the login+password. You need the ASA engine. You do not have a database until you have both the engine and the .db file. ODBC is irrelevant here, that's just the method your client uses to connect to the database.

If you know Sybase ASE or MS SQL Server, the .db is just like a device file that a database has been created on. It isn't a database you can connect to.

But if you have the front end, you do have the engine... but perhaps it has been embedded in the app.  

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
When the first reports of the initial sales of Nintendo Switch in the Land of the Rising Sun appeared. In Japan, only 330,637 consoles were sold for the first day. But many large retail chains have already sold out the entire edition of the console …
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question