Reading an ecrypted DB file.

Questions, tips and tricks and techniques for scripting in Servoy

Reading an ecrypted DB file.

Postby Vaj » Wed Jun 30, 2010 1:04 pm

I have a database file written in Paradox with extension '.db'.
I need to decrypt the database file to access the data inside and import it to my Servoy solution.
anyone know how I can achieve this?
Thanks in advance.
V Rathnayaka
Senior Systems Developer.
Space Air plc.
User avatar
Vaj
 
Posts: 64
Joined: Fri Jul 21, 2006 10:14 am
Location: Surrey, UK

Re: Reading an ecrypted DB file.

Postby rgansevles » Wed Jun 30, 2010 2:03 pm

Vaj,

Servoy solutions don't contain data, the data is in the database.
So any db copy program would do the trick.

You can use servoy for this if you can access the source db with a jdbc diver.
Set it up as server in Servoy, create a solution that uses the tables you want and export the solution with sample data.
Then import this solution into another db.

Hope this helps,

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Reading an ecrypted DB file.

Postby Vaj » Wed Jun 30, 2010 3:21 pm

Hi Rob,
I meant the database, sorry.
The database files don't seem to be running as a service, meaning; they are just files with extension '.db' there isn't a real-time database running which I found strange.
The databases are called the same name, but different sites will have the same database with different data, at different locations in its file system.
My task is to extract these data and put it against that site on to the database that Servoy solution uses, so adding it as a database server via servoy might create connection problems as the location may be different from site to site.
I hope this info makes sense.
The creators of the original software that deals with these databases provide a software which converts the db file to a csv, which is exactly what I want to do via Servoy. I have attached the db file. (Unrar it)
Any Ideas?
Thanks,
Attachments
Analog.rar
(132 Bytes) Downloaded 245 times
V Rathnayaka
Senior Systems Developer.
Space Air plc.
User avatar
Vaj
 
Posts: 64
Joined: Fri Jul 21, 2006 10:14 am
Location: Surrey, UK

Re: Reading an ecrypted DB file.

Postby rgansevles » Wed Jun 30, 2010 6:26 pm

Vaj,

I meant as a conversion to copy the data from the files to another db you can use a jdbc diver that reads the files directly (hxtt seems to provide one).

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL


Return to Methods

Who is online

Users browsing this forum: No registered users and 10 guests