Clarion 2.3 Database
lazarus / 16-Databases

----------------------------------------------------------------------
Peter F · 2011-04-06 17:26

Hi,

I have a Clarion 2.3 database which i am trying to read but i fail
over and over again. I found a site on the internet from a guy from
Russia who has a component for this but unlucky me, it get an 404 when
i try to download it. So i sended him a mail but after a few weeks
still no answer, he will be busy ;-)

Because my Db has over 2500 names, date of birth, etc etc in it it
will be a hard option to retype them all, does one of you smart guys
know a sulution for the problem?

TIA,

Cheers,

Peter

----------------------------------------------------------------------
Maciej Kaczkowski · 2011-04-06 18:58

look at torry.net there is component for reading 2.x database

http://www.torry.net/quicksearchd.php?String=clarion&Title=Yes

----------------------------------------------------------------------
kalafior · 2011-04-07 13:31

Hello, I could do converter for you. Just send me file at
kontola1@tlen.pl

----------------------------------------------------------------------
Peter F · 2011-04-08 20:12

Thanks Kalafior, i'll send it to you by mail.

Cheers,

Peter

----------------------------------------------------------------------
Peter F · 2011-05-24 17:26

Hi,

The question is open again...

Does anybody has a freeware component for Lazarus do read the Clarion
Database because i can't get it right.

I know it's my limited knowledge of Lazarus i can't get it work, it's
a pitty because the rest is working fine...

Thanks in advance,

Peter

----------------------------------------------------------------------
SteveF · 2011-05-24 19:22

What about common go-between protocols like ODBC or ADO?  Will Clarion
support these?  You might at least be able to use these to transfer
the data from Clarion to something else that does work well with
Lazarus, like Firebird.

Steve

----------------------------------------------------------------------
Peter F · 2011-05-24 19:38

Thanks for the info Steve!

I allready lookt that up but the only ODBC driver i could find was a
paid one for 249 dollar....

Cheers,

Peter

----------------------------------------------------------------------
CaptBill · 2011-05-24 20:03

Certainly you should have some import facilities if even just a CSV
import function in the original db app right? Do you have a 'database
administrator' app for the database? Or just a Clarion db file?

If it is a simple, one table, address book this should be rather
trivial. And kinda fun and rewarding if you have never 'migrated' a
table before. See kalifior offered to do it free, haha. 

Main thing is deciding on which database to put it in

----------------------------------------------------------------------
Peter F · 2011-05-24 20:21

Thanks for your reply CaptBill...

i can write and read all kind of databases, CSV etc that's not the
problem, i only have a problem with this insane Clarion DB

And i did send the database to Kalifor and sended him some more mails
about the progress but no reply at all...

----------------------------------------------------------------------
CaptBill · 2011-05-24 21:07

Have you looked at the raw data in notepad? Maybe it is unencoded and
just has a header. Probably a long shot but worth a look. Sure you
can't find a csv export app for this Clarion format?

And I am sure kalifior will show.