Re: Couldn't load foreing library "clsql_uffi" drives me mad

On 11/29/2011 11:26 AM, Daniel Brunner wrote:
> Hi everyone,
>
> that problem arose from time to time and consumed half a day without any
> step further:
>
> On my Linux box, everything is okay with clsql. On Windows it is not. I
> once had a running environment but after switching to some newer
> versions of my libraries it is broken again:
>
> I have Windows XP virtual machine with CCL 1.7-dev-r14645M-trunk
> (Windows X8632). I use quicklisp from scratch. I (ql:quickload "clsql")
> then I did a
>
> (require 'clsql)
> (require 'clsql-sqlite3)
>
> and as so often it broke with
>
> Couldn't load foreign library "clsql_uffi". (searched
> CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*).
>
>
> I searched the web and tried to find my own solution that worked
> beforehand but I didn't get clsql running. Is there anything I am doing
> wrong? Or a recipe on how to get clsql running on windows? The problem
> arose that often that I hope for a general solution. Perhaps we can put
> it in the documentation.
>

Daniel,

Sorry to say but you're probably somewhat alone on this. Windows usage 
is fairly low. Here's what I can think of to try though:

1. Make sure you have the sqlite dll installed.
2. Figure out where that is.
3. Can you call (uffi:load-foreign-library <path>
                                           :module "sqlite3"
                                           :supporting-libraries '("c"))
4. Is it named libsqlite3 or sqlite3 (from the bottom of 
db-sqlite3/sqlite3-loader.lisp), with the extension of dll or lib?
5. Is it in a directory that's one of the standard library directories 
or listed in clsql:*foreign-library-search-paths*?
   * code is in clsql/uffi/clsql-uffi-loader.lisp