Error installing SQlite3 on OS X
lazarus / 16-Databases

----------------------------------------------------------------------
vdubeau · 2009-12-03 19:34

Trying to install the SQLite3 components and get the following linker
errors:

Undefined symbols:
  "_sqlite3_exec", referenced from: _SQLITE3DS_TSQLITE3DATASET_$__SQLI
TEEXEC$PCHAR$TSQLITECDECLCALLBACK$POINTER$$LONGINT in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
  "_sqlite3_open", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in
sqlite3ds.o
  "_sqlite3_step", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$__EXECUTEDIRECT$ANSISTRING in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o _SQLITE3D
S_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRIN
G in sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_F
ILLSTRINGSANDOBJECTS in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGS in
sqlite3ds.o
  "_sqlite_finalize", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALINITFIELDDEFS in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__EXECUTEDIRECT$ANSISTRING in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o _SQLITEDS_TS
QLITEDATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in
sqliteds.o
  "_sqlite3_column_name", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
  "_sqlite3_column_text", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o _SQLITE3D
S_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRIN
G in sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_F
ILLSTRINGSANDOBJECTS in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGS in
sqlite3ds.o
  "_sqlite3_column_type", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
  "_sqlite3_libversion", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__GETSQLITEVERSION$$ANSISTRING in
sqlite3ds.o
  "_sqlite3_prepare", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__EXECUTEDIRECT$ANSISTRING in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRIN
GS$BOOLEAN$$ANSISTRING in sqlite3ds.o
  "_sqlite3_column_count", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o _SQLITE3D
S_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRIN
G in sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$T
STRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o
  "_sqlite_close", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALCLOSEHANDLE in sqliteds.o
  "sqlite_libencoding", referenced from:
_SQLITEDS_TSQLITEDATASET_$__GETSQLITEENCODING$$ANSISTRING in
sqliteds.o
  "_sqlite3_column_int", referenced from: _SQLITE3DS_TSQLITE3DATASET_$
_QUICKQUERY$crc9A533FFC_FILLSTRINGSANDOBJECTS in sqlite3ds.o
  "_sqlite_changes", referenced from:
_SQLITEDS_TSQLITEDATASET_$__GETROWSAFFECTED$$LONGINT in sqliteds.o
  "_sqlite_error_string", referenced from:
_SQLITEDS_TSQLITEDATASET_$__RETURNSTRING$$ANSISTRING in sqliteds.o
  "_sqlite3_close", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALCLOSEHANDLE in sqlite3ds.o
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in
sqlite3ds.o
  "_sqlite_compile", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALINITFIELDDEFS in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__EXECUTEDIRECT$ANSISTRING in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o _SQLITEDS_TS
QLITEDATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in
sqliteds.o
  "_sqlite3_errmsg", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__RETURNSTRING$$ANSISTRING in
sqlite3ds.o
  "_sqlite3_column_decltype", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
  "_sqlite3_finalize", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__EXECUTEDIRECT$ANSISTRING in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in
sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRIN
GS$BOOLEAN$$ANSISTRING in sqlite3ds.o
  "_sqlite3_changes", referenced from:
_SQLITE3DS_TSQLITE3DATASET_$__GETROWSAFFECTED$$LONGINT in sqlite3ds.o
  "_sqlite_freemem", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALGETHANDLE$$POINTER in sqliteds.o
  "_sqlite_exec", referenced from: _SQLITEDS_TSQLITEDATASET_$__SQLITEE
XEC$PCHAR$TSQLITECDECLCALLBACK$POINTER$$LONGINT in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o
  "_sqlite_open", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALGETHANDLE$$POINTER in sqliteds.o
  "_sqlite_step", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALINITFIELDDEFS in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__EXECUTEDIRECT$ANSISTRING in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o _SQLITEDS_TS
QLITEDATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in
sqliteds.o _SQLITEDS_TSQLITEDATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRIN
GSANDOBJECTS in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGS in
sqliteds.o
  "sqlite_libversion", referenced from:
_SQLITEDS_TSQLITEDATASET_$__GETSQLITEVERSION$$ANSISTRING in sqliteds.o
ld: symbol(s) not found
Error: Error while linking

I am running Leopard on a MacBook. SQLite3 is installed. I can use it
to access/create test DBs. Is there something else I need to include.

----------------------------------------------------------------------
Sandrix · 2010-01-16 11:59

Same here +1

Anyone?

----------------------------------------------------------------------
zenpicker · 2011-02-14 22:11

Sorry to bring this up again, but I'm burning too much time trying to
get SQLite3 components installed.  Same issue as noted by the OP.  I
currently have a TSQLite3Connection component on the SQLdb tab, but no
SQLite components on Data Access.  I cannot get the package to install
due to this flurry of undefined symbol errors.  Latest versions of Laz
and FPC, just set up yesterday.  What's going on?

TIA,
Edward

----------------------------------------------------------------------
Phil · 2011-02-15 15:38

If you have TSQLQuery, TSQLite3Connection and TSQLTransaction
installed, I don't believe you need TSqlite3Dataset.

I haven't used either in about a year, but I couldn't get
TSqlite3Dataset to work with BLOB data, so I switched to TSQLQuery and
it worked fine.

Thanks.

-Phil

----------------------------------------------------------------------
zenpicker · 2011-02-18 15:43

Phil, thanks so much!  That did the trick.  I have misunderstood how
it worked.  It was great to thrown down my dbgrid, set the dials and
see my columns pop in!

May I say what a pleasure it is to be back in the Delphi mode?  Thanks
to all who have contributed so much to make this happen.