How to Access sybase.db on PC
Posted on 2004-10-27
I am attempting to access a database that I think was created with Sybase. The database resides as a ".db" file on a desktop PC. Simple question: how can I look at the data directly without using the custom client front-end?
Here's what I've done so far:
I've tried opening it with MS Access, thinking it might be a Paradox database. I got a collating sequence error so I tried changing the collating sequence key for Paradox from ascii to International. That didn't work.
I then opened the database with a text editor and saw the name of a company "WATCOM International". I did some searching on them and found that they use sybase for software development. So, I downloaded Sybase Central's free Developer's version from the Sybase website and tried using that to open the db. I got an error message that said something about the database needing the logon and password associated with the Windows environment. I also had to tell the Sybase Central program about ports and other stuff I don't know too much about.
I can keep muddying through this until I hit on the right answer but would sure appreciate some insight. I just want to open the db, and, if possible, use the data in Excel. If necessary, I can email a sample of the db I'm attempting to open to anyone.