Newbie question

[BillyBubba]

Just installed the components and I am trying to connect to sqllite
I have the sqllite dll and db in the same folder
The Database and LibraryLocation properties of my ZConnection component are both pointed to the folder.

When I try to connect I get teh following error:

client-library sqlite3.dll found but could not be loaded.
check compile-target and library compatibility.

Any help would be greatly appreciated.

[marsupilami]

Hello BillyBubba,

that usually means that for some reason the dll file could not be loaded. This usually happens when you try to load a 64 bits dll into a 32 bits application or try to do that the other way around. Another possibility would be that the sqlite dll depends on some dll that it cannot find. This would lead to the same error message.

With best regards,

Jan

[BillyBubba]

Is there a way to tell.
I'm using Delphi 2009.
Which version of Zeos and SQLite should I use ???

[marsupilami]

Hello BillyBubba,

I don't know of a simple methot to check if you try to load a 32 bits or 64 bits library. With Delphi 2009 you should use the latest Zeos (Zeos 7.2 from the SVN if possible) and a 32 bits sqlite dll.

With best regards,

Jan