We help IT Professionals succeed at work.

Possible or not

AEII
AEII asked
on
503 Views
Last Modified: 2011-10-03
We have a required software that uses a sybase engine - adaptive server anywhere

The file is a .db extension ...

What we are hoping that we can access the datafile directly to make some table data changes directly with any other
application instead of using the software.  We still plan to use the software because we have to ... but to make some of the data changes to some of the tables is way too slow ... if we could access the specific table we could import or cut/paste the profiles we need ... otherwise the software only does it manually ...

We have tried the software manufacturer and their development plan is two years from now !

I can post the file on our site if someone thinks it can be opened or point me to somewhere ?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
You need these:
1) A valid userid/password. You may be to obtain them from an existsing odbc datasource.
2) start the .db file with dbeng50.exe
Ex: from start/run
dbeng50.exe datafile.db
50 is the version number depending on the version that may change.

3) Connect from isql or create an odbc dsn to point to this file. Any odbc tool will do.


Author

Commented:
I really appreciate your quick response ...

I have gotten to step 3 before by just dropping the db file onto dbeng8.exe ...
The sql window says: Now accepting requests ...

It the step 3 .. I basically don't have a clue what I should do ...

I am not sure what isql or exactly what a obdc tool is ... can you give me an example ? In the beginners
way ...

I do have valid user ID and password
CERTIFIED EXPERT

Commented:
I assume that you have dbeng8.exe located in a directory say

C:\Sybase\SQL Anywhere 8\win32.

In that directory you should be able to see a "dbisql.exe".

Doubleclick on it to start the isql, give the username/password and the databae you wish to connect to.

And the nyo ucan query/alter the records as yo uwish to.

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I actually experimented last night before you provided such good instruction and was able to
open the db and tables using Db Commander 2000, Approach, and Access ... the later two would only work as read only last night, but this morning I changed the attributes of the db file to read ... it worked too !

I muddled through setting up the ODBC items, but got it to work ... way too cool ...

I assume the Isql interface could be used if I understood sql ... (fat chance ... I only struggle with VB enough)

I am at a loss why someone else in our industry didn't figure this out 5 years ago ... it has always been a pain
working with this program and having to do each user manually ... now i think i can do it globally and
probalby build a little Access program that will open and preform the updates automatically ... and I consider
myself as a dangerous beginner !!! :-)

Thanks
CERTIFIED EXPERT

Commented:
Forgot to mention.

You can use SQL CENTRAL (scview.exe) that comes with sql anywhere. That supports a graphical interface to do what you are trying to do.

Regards-
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.