Generally the procedure for setting up the Oracle client is as follows.
1) create group "dba"
2) create user "oracle" in group "dba"
3) install Oracle client software for user "oracle"
4) put the user ColdFusion runs as in the group "dba"
5) chmod the entire oracle home directory for group read/write/execute
permissions
6) run ldconfig
7) modify /opt/coldfusion/bin/start to include Oracle environment variables
e.g. ORACLE_HOME
8) restart ColdFusion
-Matt
> -----Original Message-----
> From: Camden Spiller [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 9:09 AM
> To: CF-Linux
> Subject: Re: Setting up Oracle 8i Datasource
>
>
> Hey Matt,
>
> I've installed the oracle client (which I believe comes with
> the native
> drivers) and I was hopping perhaps a new option would pop up in the
> ColdFusion administrator that would allow me to create a DSN with that
> driver... obviosuly that's not the way it works. Could you
> give me some
> suggestions?
>
> Thanks,
>
> Camden
>
> > > > ----- Original Message -----
> > > > From: "Matt Liotta" <[EMAIL PROTECTED]>
> > > > To: "CF-Linux" <[EMAIL PROTECTED]>
> > > > Sent: Tuesday, January 02, 2001 12:32 PM
> > > > Subject: RE: Setting up Oracle 8i Datasource
> > > >
> > > >
> > > > > I would recommend using the Oracle native driver instead as
> > > > it is much
> > > > > faster. In order to do that you need to setup the Oracle
> > > > client first.
> > > > This
> > > > > will also give you the ability to test the connection.
> > > > >
> > > > > -Matt
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Camden Spiller [mailto:[EMAIL PROTECTED]]
> > > > > > Sent: Tuesday, January 02, 2001 1:35 PM
> > > > > > To: CF-Linux
> > > > > > Subject: Setting up Oracle 8i Datasource
> > > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I'm having trouble setting up a Datasource that will connect
> > > > > > to my Oracle 8.1.6 server. I'm using the Merant Oracle 8
> > > > > > drive that shipped with CF Pro 4.5 I'm using the
> connect string
> > > > > > DSN=mydbname;DBQ=10.1.0.xx;UID=myser;PWD=mypass;
> > > > > >
> > > > > > Does that look correct?
> > > > > >
> > > > > > Camden
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
