Zeoslib Portal

Posted: **16.08.2010, 14:29**

Hi,

I am using ZeosLib in Delphi 2007. I am trying to load the spatialite extension using the following code:

Zconnection1.Connected := true;
   ZQuery1.SQL.Clear;
   ZQuery1.SQL.Add('SELECT load_extension(''libspatialite-2.dll'')');
   ZQuery1.ExecSQL;
   messagedlg('After extention',mtinformation,[mbok],0);

However I have the message: "Not authorized". By searching on the internet it seems that I need to call the function sqlite3_enable_load_extension(sqlite3 *db, int onoff).

However how call the function using ZeosLib?

Regards,
Carlos

Posted: **30.08.2010, 00:30**

Have a look at the Open procedure in ZDbcSqlite.pas file on how SSL connctions are handled. I'd be glad if I could merge your solution in the definitive zeoslib distro.

For questions : just contact me.

Mark

Zeoslib Portal

SQlite3 Load extension -- not authorized

SQlite3 Load extension -- not authorized