Recent

Author Topic: Error installing SQlite3 on OS X  (Read 6846 times)

vdubeau

  • New Member
  • *
  • Posts: 24
Error installing SQlite3 on OS X
« on: December 03, 2009, 08:34:21 pm »
Trying to install the SQLite3 components and get the following linker errors:

Undefined symbols:
  "_sqlite3_exec", referenced from: _SQLITE3DS_TSQLITE3DATASET_$__SQLITEEXEC$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 _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGSANDOBJECTS 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_TSQLITEDATASET_$__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 _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGSANDOBJECTS 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$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o
  "_sqlite3_column_count", referenced from: _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$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_TSQLITEDATASET_$__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$TSTRINGS$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_$__SQLITEEXEC$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_TSQLITEDATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqliteds.o _SQLITEDS_TSQLITEDATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGSANDOBJECTS 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

  • New Member
  • *
  • Posts: 32
    • My Portfolio
Re: Error installing SQlite3 on OS X
« Reply #1 on: January 16, 2010, 12:59:19 pm »
Same here +1

Anyone?

zenpicker

  • Newbie
  • Posts: 4
Re: Error installing SQlite3 on OS X
« Reply #2 on: February 14, 2011, 11:11:58 pm »
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

  • Hero Member
  • *****
  • Posts: 2737
Re: Error installing SQlite3 on OS X
« Reply #3 on: February 15, 2011, 04:38:50 pm »
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

  • Newbie
  • Posts: 4
Re: Error installing SQlite3 on OS X
« Reply #4 on: February 18, 2011, 04:43:02 pm »
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.

 

TinyPortal © 2005-2018