From: vttoonses
Subject: Database connction problem
Date: 
Message-ID: <e2d5f611-5ec5-49df-ab4d-bb81039b4264@c65g2000hsa.googlegroups.com>
<caveat>
    I am new to lisp and do not understand everything about working in
the environment.
</caveat>

<system info>
    OS - Mac OSX 10.5.4
    Lisp - Clozure Common Lisp Version 1.2-r10478M-trunk
(DarwinX8664)
    Database - PostgreSQL 8.3.3
</system info>

I am trying to make a connection to a running datasource. Each time I
execute the following command:
    (clsql:connect '("" "clsql" "gene" "") :database-type :postgresql)
I receive the following error message:
    Error: Couldn't load foreign libraries "clsql_uffi64",
"clsql_uffi". (searched CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*)

The current value of clsql-sys:*foreign-library-search-paths* is (#P"/
Users/gene/Development/clsystems/clsql-4.0.3/uffi/") and, while
clsql_uffi.dylib exists there, clsql_uffi64.dylib does not. After some
research, I found a post recommending copying the clsql_uffi file to
the clsql_uffi64. This results in the following error:
Error: Undefined function: CLSQL-UFFI:ATOL64

Performing "nm" on the files shows an entry point for atol64. Possibly
the linkage between lisp and the native library is broken?

Any help resolving this issue would be greatly appreciated. I'm pretty
much at my wit's end and I'd rather not go back to programming in
Java.

Thanks,
Gene

PS. I've previously posted to the clsql news group yet have received
no response in more than a week. Hence, I am trying here.