RE: Oracle db access on Linux

Ok, got it. I needed the ORACLE_SID environment variable set. Fair enough...

Thanks for the help.

dey

-----Original Message-----
From: Young, David [mailto:deyoung@bloodhoundinc.com]
Sent: Tuesday, September 21, 2004 1:44 PM
To: 'davef@xanalys.com'
Cc: lisp-hug@xanalys.com
Subject: RE: Oracle db access on Linux



Ok, progress. Calling (sql:initialize-database-type :database-type :oracle8)
didn't do what I expected, as sql:*default-database-type* remained
:odbc-driver. I set that variable directly, then called
(sql:initialize-database-type). Fine. Works. Upon connect, I now get:

Error: Sql-Database-Data-Error id -7217[7217] : ORA-07217: sltln:
environment variable cannot be evaluated.

Oops. I suspect I'm almost there...

Cheers, David

-----Original Message-----
From: davef@xanalys.com [mailto:davef@xanalys.com]
Sent: Tuesday, September 21, 2004 1:15 PM
To: deyoung@bloodhoundinc.com
Cc: lisp-hug@xanalys.com
Subject: Re: Oracle db access on Linux


 > 
 > Greetings. We're an Enterprise LWW customer evaluating that platform for
 > Linux. We have Oracle 8.1.7 installed on Redhat 7.2, but can't seem to
 > initialize CommonSQL with a database type of :ORACLE. For example, 
 > 
 > (require "oracle")
 > (sql:initialize-database-type :database-type :oracle)
 > 
 > yields an SQL-ERROR of "Database type ORACLE is not supported"
 > 
 > According to the LW docs, we should indicate oracle's install directory
via
 > an environment variable. That would seem to be ORACLE_HOME, and it's set
to
 > oracle's root install directory.
 > 
 > We don't want to use ODBC. What am I missing? Thanks...

(SQL:INITIALIZE-DATABASE-TYPE :DATABASE-TYPE :ORACLE8)

The documentation in the LispWorks User Guide is inaccurate -
sorry. The correct value is well-hidden, in the manual page for
SQL:CONNECT. We'll improve this documentation.

--
Dave Fox			

Xanalys                 http://www.lispworks.com
Compass House
Vision Park, Chivers Way
Histon
Cambridge, CB4 9AD
England

This email message is for the sole use of the intended recipients(s) and may
contain confidential and privileged information of Bloodhound Software,
Inc.. Any unauthorized review, use, disclosure is prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy
all copies of the original message.

This email message is for the sole use of the intended recipients(s) and may contain confidential and privileged information of Bloodhound Software, Inc.. Any unauthorized review, use, disclosure is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.