Please help me connect

Forum related to SQLite

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
mskeels
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 11.12.2008, 18:18

Please help me connect

Post by mskeels »

Lazarus 0.9.26
ZeosLib 6.6.4
SQLite 3: libraries (like a DLL?) exist in usr/lib; names confuse me.
Ubuntu 8.04 on EEEPC.

Let's see did I forget anything?

When attempting to set Connected=True on a TZConnection, I get following msg:
"None of the dynamic libraries can be found: libsqlite.so "

I think this has to do with something called Symlink, but I saw no explanation in the forum that was simple/clear enough for me to execute, being almost completely unaquainted with the Linux Way.

I am a Delphi 7/Windows programmer and have very recently come to Linux and Lazarus.

What am I missing; what do I need to do?

Thanks,
Mark
rfwoolf
Fresh Boarder
Fresh Boarder
Posts: 14
Joined: 28.09.2008, 20:46

Just a guess...

Post by rfwoolf »

I think the relevant library has to be in your working directory - the directory where your application is running from - or in the system32 or system folder or wherever - so check what happens if you put libsqlite.so in your folder.
mskeels
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 11.12.2008, 18:18

Post by mskeels »

Thanks, good try, but no joy.........

Any other ideas?
rfwoolf
Fresh Boarder
Fresh Boarder
Posts: 14
Joined: 28.09.2008, 20:46

Post by rfwoolf »

Ummm, double-check that you've chosen the right protocol on your TZConnection ???

I should add that I'm only guessing - I use ZeosLib with Firebird - but some of the principals in connecting are the same.
mskeels
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 11.12.2008, 18:18

Post by mskeels »

But under Lazarus?

Then maybe I should try a Firebird db and see if I can connect to that.......you are successful trying this with Lazarus then?
rfwoolf
Fresh Boarder
Fresh Boarder
Posts: 14
Joined: 28.09.2008, 20:46

Post by rfwoolf »

nope
mskeels
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 11.12.2008, 18:18

Post by mskeels »

OK, I found this:

http://www.lazarus.freepascal.org/index ... pic&t=3548

But I don't know quite enough yet to make it work for SQLite.........anybody else want to try to help me please?
rfwoolf
Fresh Boarder
Fresh Boarder
Posts: 14
Joined: 28.09.2008, 20:46

Post by rfwoolf »

..and I take it you've tried your fair share of googling? For example I found this:
http://wiki.lazarus.freepascal.org/Zeos_tutorial
mskeels
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 11.12.2008, 18:18

Post by mskeels »

Hadn't seen that.....that might be helpful! But I think it is mostly referring to an earlier build.

Thank you.

Still looking, though......
Post Reply