From: gtasso
Subject: cl-sql
Date: 
Message-ID: <afcf3628-7da8-42fa-a8b2-2e58297a02d8@y38g2000hsy.googlegroups.com>
Is anybody using cl-sql to talk to ms sql on linux ? Apreciate some
pointers.

regards

George Tasso

From: gtasso
Subject: Re: cl-sql
Date: 
Message-ID: <e2cd7732-add4-4df1-a29e-3c90d787deff@2g2000hsn.googlegroups.com>
On May 16, 9:05 am, gtasso <·······@gmail.com> wrote:
> Is anybody using cl-sql to talk to ms sql on linux ? Apreciate some
> pointers.
>
> regards
>
> George Tasso

here is what i did so far on a ubuntu 8.04

install cl-sql and cl-uffi

sudo apt-get install cl-sql
sudo apt-get install cl-uffi

install unixodbc and Free TDS

sudo apt-get install unixodbc
sudo apt-get install libgda3-freetds

configure unixodbc here is my configuration file..

[epicor]
Driver = libgda3-freetds
Description = Epicor
Trace = No
Server = my server ip
Port = 1433
Database = RBVDATA


start up sbcl

(require :asdf)
(require :clsql)
(use-package :clsql)

when i issue

(asdf:operate 'asdf:load-op 'clsql-odbc)

i get this error :


(SB-IMPL::SIMPLE-FILE-PERROR
"error opening ~S"
#P"/usr/share/common-lisp/systems/clsql-odbc.asd" 40)

Any help appreciated.

George
From: Vagif Verdi
Subject: Re: cl-sql
Date: 
Message-ID: <832e6c14-d218-4720-b44c-de621ede6631@j33g2000pri.googlegroups.com>
On May 15, 8:46 pm, gtasso <·······@gmail.com> wrote:
> On May 16, 9:05 am, gtasso <·······@gmail.com> wrote:
>
> > Is anybody using cl-sql to talk to ms sql on linux ? Apreciate some
> > pointers.
>
> > regards
>
> > George Tasso
>
> here is what i did so far on a ubuntu 8.04
>
> install cl-sql and cl-uffi
>
> sudo apt-get install cl-sql
> sudo apt-get install cl-uffi
>
> install unixodbc and Free TDS
>
> sudo apt-get install unixodbc
> sudo apt-get install libgda3-freetds
>
> configure unixodbc here is my configuration file..
>
> [epicor]
> Driver = libgda3-freetds
> Description = Epicor
> Trace = No
> Server = my server ip
> Port = 1433
> Database = RBVDATA
>
> start up sbcl
>
> (require :asdf)
> (require :clsql)
> (use-package :clsql)
>
> when i issue
>
> (asdf:operate 'asdf:load-op 'clsql-odbc)
>
> i get this error :
>
> (SB-IMPL::SIMPLE-FILE-PERROR
> "error opening ~S"
> #P"/usr/share/common-lisp/systems/clsql-odbc.asd" 40)
>
> Any help appreciated.
>
> George

Add these:

TextSize     = 250000
TDS_Version  = 7.0

You need to set Textsize to any big enough for you number, otherwise
you'll get errors when fetching text fields.
You need to set TDS version to correct one. 7 works for me (SQL Server
2000)
From: Vagif Verdi
Subject: Re: cl-sql
Date: 
Message-ID: <2b2366b9-f594-4ba7-900c-48e4eadf4db1@a9g2000prl.googlegroups.com>
On May 15, 8:46 pm, gtasso <·······@gmail.com> wrote:
> On May 16, 9:05 am, gtasso <·······@gmail.com> wrote:
>
> > Is anybody using cl-sql to talk to ms sql on linux ? Apreciate some
> > pointers.
>
> > regards
>
> > George Tasso
>
> here is what i did so far on a ubuntu 8.04
>
> install cl-sql and cl-uffi
>
> sudo apt-get install cl-sql
> sudo apt-get install cl-uffi
>
> install unixodbc and Free TDS
>
> sudo apt-get install unixodbc
> sudo apt-get install libgda3-freetds
>
> configure unixodbc here is my configuration file..
>
> [epicor]
> Driver = libgda3-freetds
> Description = Epicor
> Trace = No
> Server = my server ip
> Port = 1433
> Database = RBVDATA
>
> start up sbcl
>
> (require :asdf)
> (require :clsql)
> (use-package :clsql)
>
> when i issue
>
> (asdf:operate 'asdf:load-op 'clsql-odbc)
>
> i get this error :
>
> (SB-IMPL::SIMPLE-FILE-PERROR
> "error opening ~S"
> #P"/usr/share/common-lisp/systems/clsql-odbc.asd" 40)
>
> Any help appreciated.
>
> George

BTW looks like your error has nothing to do with odbc setup. Check
uffi. I use clsql with uffi-cffi bridge.
From: vanekl
Subject: Re: cl-sql
Date: 
Message-ID: <ffa1d685-e2d5-459c-a2e9-7ee08f75acd2@m3g2000hsc.googlegroups.com>
On May 16, 3:46 am, gtasso <·······@gmail.com> wrote:
> On May 16, 9:05 am, gtasso <·······@gmail.com> wrote:
>
> > Is anybody using cl-sql to talk to ms sql on linux ? Apreciate some
> > pointers.
>
> > regards
>
> > George Tasso
>
> here is what i did so far on a ubuntu 8.04
>
> install cl-sql and cl-uffi
>
> sudo apt-get install cl-sql
> sudo apt-get install cl-uffi
>
> install unixodbc and Free TDS
>
> sudo apt-get install unixodbc
> sudo apt-get install libgda3-freetds
>
> configure unixodbc here is my configuration file..
>
> [epicor]
> Driver = libgda3-freetds
> Description = Epicor
> Trace = No
> Server = my server ip
> Port = 1433
> Database = RBVDATA
>
> start up sbcl
>
> (require :asdf)
> (require :clsql)
> (use-package :clsql)
>
> when i issue
>
> (asdf:operate 'asdf:load-op 'clsql-odbc)
>
> i get this error :
>
> (SB-IMPL::SIMPLE-FILE-PERROR
> "error opening ~S"
> #P"/usr/share/common-lisp/systems/clsql-odbc.asd" 40)
>
> Any help appreciated.
>
> George

It looks like it may be file permissions.
I don't use ms sql server and clsql combination, but I know a couple
of things about clsql and asdf.

Log on using the same account that your lisp image is using (if you
aren't already logged on under this account).

Try doing,
  cat /usr/share/common-lisp/systems/clsql-odbc.asd

This will probably give you an error.

Make sure the asd file/link is there. As /root/, do:

 ls /usr/share/common-lisp/systems/clsql-odbc.asd

If it's not there, add a soft link to the clsql-odbc.asd file
(wherever it has been installed), to this systems directory. If you
aren't sure where the clsql-odbc.asd file is installed, you can always
find it:
  find /usr -iname clsql-odbc.asd -print
but this step can be skipped if the clsql-odbc.asd file and link are
already there, but just have incorrect permissions.

If cl-sql-odbc.asd exists, make sure it has permissions so that lisp
can read it.
This is one way of accomplishing that:

  chown -R [[lisp-account]] /usr/share/common-lisp

(You will probably have to use sudo or root to do the chown. Also,
don't use the brackets.)

Try the asdf load op again. Now you should be able to read the asd
file. If you have further errors, the answer may be in the backtrace.
Also keep in mind that you may have further permissions problems (I'm
thinking of the odbc libraries).