[clisp-list] =?ISO-8859-1?Q?CLISP-ODBC_interface:_plain-odbc?=

[Roland A. <rol...@gm...>]

Hello,
I would like to announce plain-odbc which is a simple interface 
to ODBC.

It can be found at http://common-lisp.net/project/plain-odbc.

Statement parameters, clobs and blobs are supported.
An example:

[5]> (use-package :plain-odbc) 

T
[6]> (setf *con* (connect-sql-server "ltrav" "test"))

WARNING: [ODBC info] 1 state: [Microsoft][ODBC SQL Server Driver][SQL
         Server]Changed database context to 'test'.
#<ODBC-CONNECTION SERVER="LTRAV" DBMS="Microsoft SQL Server" USER="dbo">
[7]> (exec-command *con* "create table clob_test (id int,txt text)")


[8]> (exec-update *con* "insert into clob_test(id,txt) values(?,?)" 123
(list (make-string 1000000 :initial-element #\z) :clob :in))

1
[9]> (subseq (first (first (exec-query *con* "select txt from clob_test
where id=?" 123))) 999990 1000000)

"zzzzzzzzzz"


The interfacing to C is done via UFFI.

For CLISP I used Jörg Höhle's UFFI implementation with small
additions.

In the FTP directory there is also a modified UFFI-1.5 
which supports CLISP. 
The support of UFFI for CLISP was written by me.
I just implemented what I needed.

CLISP is my development platform, plain-odbc works with 
CLISP on Linux and Win32. (Oracle, SQL-Server, ACCESS and MySQL).

I have tested it also with the trial versions of 
Allegro and Lispworks on Win32.

Roland Averkamp


-- 
Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner