I have compiled sqlite 3.2.1 with the --enable-shared option (using configure) which results in a file /usr/local/lib/libsqlite.so.8.6
Whenever I load the sqlite.lsp program, I get the following error message:
Code Select
Can't open file
problem loading library in function import : "/usr/local/lib/libsqlite.so.8.6"
When I try from the newlisp commandline to load the .so file with sqlite3_open as a function, I get the following:
Code Select
(load "/usr/local/lib/libsqlite.so.8.6" "sqlite3_open" "cdecl")
nil
At this point, I haven't tried extremely hard to figure out what is happening and thought I'd post to the list to see if anyone else has seen this behavior. In theory, this should work just fine, but it doesn't.
I've considering trying the SQLite 2.x series, but would prefer to run 3.1 or higher for some functionality I would like to use.
Any ideas from someone who has made this work?
As a side-note, the sql function/define fails on OS X when attempting to perform any sql command:
Code Select
> (sql3 "select * from mytable;")
invalid function : (sql3 "select * from mytable;")
Perhaps I'm just tired, but this should work based on the documentation (in the sqlite3.lsp file), which states:
;; (sql3 "select * from mytable;") ; makes a sql query, returns result