Hello,
I have given an application with a file xy.db (size: 200 MByte).
I want to convert it into MDB or CVS.
with a binary editor ("WinHex"), I see inside the file xy.db:
--------------------------
----------
----------
----
almost at the beginning of the file, I see the copyright notice:
WATCOM International Corp., Copyright (c) 1987, 1994
searching for "Password" gives several occurrences such as:
SYSUSERAUTHVIEWÁcreate view SYS.SYSUSERAUTH("name",
password,resourceauth,dbaa
uth,schedu
leauth,use
r_group)
as select user_name,password,resourc
eauth,dbaa
uth,schedu
leauth,use
r_group
from SYS.SYSUSERPERMN" where
below this, I see another possibly helpful info:
SYSCOLUMNSVIEWÿcreate view SYS.SYSCOLUMNS(creator,cna
me,tname,c
oltype,nul
ls,length,
syslength,in_primary_key,c
olno,defau
lt_value,r
emarks)
as select(select user_name from SYS.SYSUSERPERM
where user_id=SYSTABLE.creator)
when searching for "login", I get:
"SYSLOGINBASEN+"
--------------------------
----------
----------
----
Also found in the same directory are some *.dbf files and some *.sql files.
Question 1: what kind of file is xy.db ?
Question 2: how can I open (display) xy.db, to see the stored records in a way readable by human ?
Question 3: how can I convert xy.db into an *.mdb or into a *.cvs ?
I believe (but I am not sure) the only problem is I do not have the password.
I already tried to open the file with "Sybase SQL Anywhere", but I failed. It seems to me it wants a password (see the enclosed error messages). I am sure somewhere in space, there is a tiny tool to retrieve the password :-)
Best regards, Sonja
Start Free Trial