RE: ODBC in v2.0?

Has anyone looked into this problem. I tried using the sql-odbc-0.85
package that comes with corman lisp and got a similar bug in loop.lisp. 

-Reggie


On Fri, 14 Feb 2003, Alan Walker wrote:

> 
> I downloaded the install executable and reinstalled, just to be sure that
> the structures are OK.
> 
> Next, I copied the lines from
> ...\Libraries\sql-odbc-0.85\corman\system-init.lisp into init.lisp
> 
> Then, I evaluated (require 'ODBC), which is what the code suggests I do, and
> this is what I got:
> 
> ;;; Autoloading C:\Program Files\Corman Technologies\Corman Lisp
> 2.0\sys\loop.lisp ...
> ;;; Warning: Unused variable X in function NIL, File C:\Program Files\Corman
> Technologies\Corman Lisp 2.0\sys\loop.lisp, line 337
> ;;; Warning: Unused variable X in function NIL, File C:\Program Files\Corman
> Technologies\Corman Lisp 2.0\sys\loop.lisp, line 476
> ;;; Warning: Unused variable X in function NIL, File C:\Program Files\Corman
> Technologies\Corman Lisp 2.0\sys\loop.lisp, line 1333
> ;;; Warning: Unused variable X in function NIL, File C:\Program Files\Corman
> Technologies\Corman Lisp 2.0\sys\loop.lisp, line 1717
> ;;; An error occurred in function HANDLE-INVALID-TYPE:
> ;;; Error: Type error: The value of UNIVERSE, #<LOOP-UNIVERSE ANSI> is not
> of type LOOP-UNIVERSE.
> ;;; Entering Corman Lisp debug loop.
> ;;; Use :C followed by an option to exit. Type :HELP for help.
> ;;; Restart options:
> ;;; 1   Enter a value of the correct type.
> ;;; 2   Enter a value of the correct type.
> ;;; 3   Abort to top level.
> 
> 
> At least it's a different error.....
> 
> I've also tried the commands in
> ...\Libraries\sql-odbc-0.85\examples\sample-session.lisp
> 
> They don't work either - probably because it's not clear to me how to modify
> stuff like the following to work with Corman Common Lisp:
> 
> (setf (logical-pathname-translations "sql")
>       '(("**;*.*" "ccl:projects;sql-odbc 0.85;**;")))
> #+mcl(load "sql:mcl;use-module.lisp")
> 
> 
> If somebody out there has made ODBC actually work with v2.0, I would
> appreciate some hints.
> 
> Thanks,
> Alan.
> 
> 
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]On Behalf Of Edi
> Weitz
> Sent: Friday, February 14, 2003 3:36 AM
> To: [email protected]
> Cc: [email protected]
> Subject: Re: [cormanlisp] ODBC in v2.0?
> 
> 
> "Alan Walker" <[email protected]> writes:
> 
> > Hi,
> >     I downloaded a copy of Corman Common Lisp 2.0 a couple of weeks ago,
> > with a view to get back into Lisp.  I used the language a little 20 years
> > ago at university, but I'm no expert.  However, it seems like a great
> match
> > for some of the programs I want to write.
> >     Anyway, I'd like to access an SQL database, so I downloaded
> > sql-odbc-0.85 from Chris Double's site, installed it, modified lisp.init
> and
> > tried the following forms one at a time:
> >
> > 	(require 'ODBC)
> > 	(in-package :cl-user)
> > 	(use-package :sql)
> > 	(use-package :odbc)
> > 	(enable-sql-reader-syntax)
> > 	(connect "LispTest")
> >
> >     Executing the last form results in an error:
> >
> > ;;; An error occurred in function STD-COMPUTE-EFFECTIVE-METHOD-FUNCTION:
> > ;;; Error: No primary methods for the generic function
> > #<Standard-Generic-Function (SETF ODBC::HENV) #x15176D8>.
> > ;;; Entering Corman Lisp debug loop.
> > ;;; Use :C followed by an option to exit. Type :HELP for help.
> > ;;; Restart options:
> > ;;; 1   Abort to top level.
> >
> >     This is coming from the CONNECT function in
> > "sql-functional-interface.lisp".  Does this ODBC package works with v2.0
> of
> > the compiler?  Is there some patch or something else I need?  I'm guessing
> > it's something obvious I've overlooked.
> 
> I can't check right now because I'm on Linux but looking at my Windows
> partition reveals this:
> 
>   root@ella:/groucho/Program Files/Corman Technologies > find . -name
> '*odbc*'
>   ./Corman Lisp 2.0/Libraries/odbc
>   ./Corman Lisp 2.0/Libraries/odbc/odbc-ffi.lisp
>   ./Corman Lisp 2.0/Libraries/odbc/odbc-h.lisp
>   ./Corman Lisp 2.0/Libraries/odbc/odbcexample.lisp
>   ./Corman Lisp 2.0/Libraries/odbc/odbcext-ffi.lisp
>   ./Corman Lisp 2.0/Libraries/odbc/odbcext-h.lisp
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/doc/sql-odbc-documentation.lisp
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/odbc
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/odbc/odbc-constants.lisp
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/odbc/odbc-ff-interface.lisp
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/odbc/odbc-functions.lisp
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/odbc/odbc-package.lisp
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/odbc/odbc-sql-interface.lisp
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/odbc/odbc-streams.lisp
>   ./Corman Lisp 2.0/Libraries/sql-odbc-0.85/odbc/odbc-system.lisp
> 
> So it looks like Corman Lisp 2.0 already comes with ODBC
> libraries. Did you try them before downloading the 1.5 stuff from
> Chris Double's site?
> 
> Cheers,
> Edi.
> 
> 
> 
> To unsubscribe from this group, send an email to:
> [email protected]
> 
>  
> 
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 
> 
> 
> 


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/W7NydA/hdqFAA/VygGAA/SyjtlB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[email protected]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/