Gee, I realy thought I was onto something there but still no luck.
I checked the access permissions for nobody (which cf is using) and sure
enough the orahome directory was 700, i changed it to 755 but i'm still
not able to verify it (I do have a username and password specified in cf
administrator). I also tried the test page you suggested and got
ODBC Error Code = IM003 (Specified driver could not be loaded)
Specified driver coult not be loaded
The error occured while processing...etc
Just to check, I used
su - nobody
checked that i can cd to the directory where libclntsh.so was and i can,
then I set LD_LIBRARY_PATH to the same value as it is set in the
$CFHOME/bin/start script, and ran
ldd /opt/coldfusion/lib/CFor815.so
It found the libclntsh.so library without problems, what else can the
problem be?
Thanks a lot for your help so far, I can feel that I'm edging towards
getting this solved.
Chris Jensen
Camden Spiller wrote:
>
> That fixed it for me. Chris, Hopefully it will work for you as well.
>
> Here is the revised step 8:
>
> 8) Test it
>
> Bring your test page up in the browser like:
> http://www.yoursite.com/oracle_test.cfm
>
> If you get an error like this:
>
> ODBC Error Code = IM003 (Specified driver could not be loaded)
>
> Try typing changing the permission on the oracle home directory to 755 and
> give the test page another try.
>
> If CF is still unable to load the ODBC driver, it boils down to the library
> search path or client library filename.
>
> Set your LD_LIBRARY_PATH and try using the ldd command on the Oracle driver:
> ldd /opt/coldfusion/lib/CFor815.so
>
> Note the libclntsh.so library it is looking for and make sure the ColdFusion
> user (nobody?) can access the Oracle directories.
>
> Now you should be able to bring up your test cfm page and see the results of
> your test query! Congratulations!
>
> Camden
>
> ----- Original Message -----
> From: "Tom Jordahl" <[EMAIL PROTECTED]>
> To: "CF-Linux" <[EMAIL PROTECTED]>
> Sent: Wednesday, February 14, 2001 10:25 AM
> Subject: Re: Using MERANT oracle 8 client under linux
>
> > If CF is unable to load the ODBC driver, it always boils down to the
> > library search path or client library filename.
> >
> > Set your LD_LIBRARY_PATH and try using the ldd command on the Oracle
> > driver: ldd /opt/coldfusion/lib/CFor815.so
> >
> > Note the libclntsh.so library it is looking for and make sure the
> > ColdFusion user (nobody?) can access the Oracle directories.
> >
> > --
> > Tom Jordahl
> > Allaire Development
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
