RE: ODBC in v2.0?
"Cena, Resty" <[email protected]> Mon, 14 Apr 2003 12:28:12 -0600
| Newsgroups | gmane.lisp.corman |
|---|---|
| Message-ID | <[email protected]> |
If CormanLisp will include a working industrial strength ODBC in its distribution (even though my preference is for a native driver for Oracle), I'll be quick to order for a license... > -----Original Message----- > From: Reginald S. Perry [SMTP:[email protected]] > Sent: Monday, April 14, 2003 11:48 AM > To: [email protected] > Subject: RE: [cormanlisp] 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 > ADVERTISEMENT > <http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=1706441874:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei> > <http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.1728375/D=egroupmail/S=:HM/A=1457554/rand=254896212> > > To unsubscribe from this group, send an email to: > [email protected] > > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/>. > > _____ > > This message scanned for viruses by the EPCOR anti-virus gateway. > This e-mail contains confidential information that is proprietary to EPCOR and its subsidiary companies in all respects. This information is intended only for the person(s) named in the destination address. Distribution, copying or disclosure is strictly prohibited. If you receive this e-mail in error, please delete it immediately. This message scanned for viruses by the EPCOR anti-virus gateway.