Recover Sybase password

Hi

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
kenabbottAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe WoodhousePrincipal ConsultantCommented:
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. :)
0
kenabbottAuthor Commented:
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
0
Joe WoodhousePrincipal ConsultantCommented:
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.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.