Hi, I am also one of SQLilte User. I am struggling to compile c code for sqlite. If you don't mind , please send me c code to compile. i am waiting for ur reply. thanks
[EMAIL PROTECTED] wrote: > > Thanks for your fast response. > Now I can compile and test program works > fine, but..... > When I run: test test.db "select * from tbl1" > sqlite3_exec function give me follow error: Unsupported file format. > > If I run this query using sqlite3 interactive program all works fine. > test.db contatins only tlb1 whith 2 coloumns and 2 records. > > Any > Suggestions ? > > > ----Messaggio originale---- > Da: [EMAIL PROTECTED] > Data: > 26-gen-2006 5.57 PM > A: <sqlite-users@sqlite.org> > Ogg: Re: [sqlite] How > to compile sqlite3 C sample code > > On Jan 26, 2006, at 11:03 AM, > [EMAIL PROTECTED] wrote: > >> I'm a novice and after compiled and correctly > installed SQLite 3.x, >> i've tried to compile sample C++ program found > in Quickstart page. >> I've >> got Linker errors, like follows: >> >> > /home/etrax/tmp/cckIV5JC.o: In >> function `main': >> t.c:(.text+0xd6): > undefined reference to >> `sqlite3_open' >> t.c:(.text+0xee): undefined > reference to >> `sqlite3_errmsg' >> t.c:(.text+0x115): undefined > reference to >> `sqlite3_close' >> t.c:(.text+0x142): undefined reference > to >> `sqlite3_exec' >> t.c:(.text+0x175): undefined reference to >> > `sqlite3_close' >> collect2: ld returned 1 exit status >> >> Any > suggestions ? >> I've compiled sqlite3 without errors and using sqlite3 > I've created >> and >> I can use a testDB. >> >> Regards > > You need to > tell the linker that you're using the SQLite library, and > possibly > where to find that library. > > To tell the linker you're using SQLite, > just add to your LDFLAGS '- > lsqlite3'. If the linker still can't seem > to find the sqlite3 > library, you may also need to add '- > L/usr/local/lib' (assuming you > installed SQLite into /usr/local, > which is the default destination). > > A complete makefile might be as > simple as the following line: > LDFLAGS = -L/usr/local/lib -lsqlite3 > > Then, just 'make t' should compile and link your test program > correctly. > HTH, > -MIke Ashmore > > > > > -- View this message in context: http://www.nabble.com/R%3A-Re%3A--sqlite--How-to-compile-sqlite3-C-sample-code-tf1009320.html#a6016846 Sent from the SQLite forum at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
