Solved

How to Access sybase.db on PC

Posted on 2004-10-27
725 Views
Last Modified: 2012-06-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.
0
Question by:joelhoffman
    3 Comments
     
    LVL 13

    Assisted Solution

    by:alpmoon
    In Sybase Central, you have different options to connect to DB. You should use lower part of database panel. You can either write the path or use browse button. In Login panel, try "DBA" as user name and "SQL" as password. They are default values. If they don't work, you need to find out the actual password or a valid user name.

    Good luck
    0
     
    LVL 19

    Assisted Solution

    by:grant300
    You cannot use Sybase Central by itself.  It is simply a tool that runs against the various Sybase database engines including Adaptive Server Anywhere (ASA) (formerly WATCOM SQL then SQL Anywhere), Adaptive Server Enterprise (ASE), and Adaptive Server IQ (ASIQ).

    You need to download and install the developers edition of ASA before you can do anything.  Even at that, it is very likely that the version of the .DB file you have is older (perhpas several releases) than the latest release on the web site.

    This file did not materialize out of thin air.  Go back and look at the system where you found the file and see if the database  engine is not installed there.

    Good luck
    0
     

    Accepted Solution

    by:
    It looks like you are using ASA, which uses *.db as file extension for the database files.
    1- If you dont have the ASA installed on your machine try to install it.
    2- start the ASA Engine: dbeng9 -n mysrv <fullpath>/myfile.db
    3- Now, create an ODBC dsn by just specifying the a)servername & b)dbname dont forget to give DBA/SQL as username password
    4- Use any ODBC connection supported prgram like MSACCESS or use dbisql to connect to this server. You may also use SybaseCentral to connect by providing the mentioned connection parameters.
    5- Now you should be above to see the contents of the database.

    Try this and update.

    Regards,

    /AP
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Learn The Basics of Ethical Hacking & Pen Testing

    Computer and network security is one of the fastest growing and most essential industries in technology, meaning companies will pay big bucks for ethical hackers. This is the perfect course to leap into this lucrative career, learning how to use ethical hacking to reveal ...

    Suggested Solutions

    Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
    Read about why website design really matters in today's demanding market.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    910 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now