Did you restart the server or at least the CF services? I've made that
mistake after installing Oracle client software a couple of times. Also
check and make sure you're using the same host string, username and password
in CF Admin because that should certainly work if SQL*Plus works.
Good luck
Duncan Hays
-----Original Message-----
From: Tim Painter [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 9:56 AM
To: CF-Talk
Subject: Re: [Re: Native Drivers - Oracle80]
I am running into the same problem. I can connect to it via SqlPlus on the
same machine and I have it running fine on another server.
Any clues? Should I reinstall the oracle client?
Thanks
Tim P.
----- Original Message -----
From: "Julia Phu" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 12:13 AM
Subject: Re: [Re: Native Drivers - Oracle80]
> "... you must give it a service name remember that because you will have
to
> use this when creating the dsn and you will need rights to the db also"
>
> Yes, I had Oracle 8 client software installed and have created a service
name,
> ABC.
>
> On the CF Settings page:
> DSN: ABC
> Host String: 127.0.0.1:1521
> ColdFusion Login: ABCowner/******
>
> I created ABCowner NT user account with Admin right. What else did I miss?
>
> Regards,
>
> Julia Phu
>
>
> "Tom Davison" <[EMAIL PROTECTED]> wrote:
> did you install the oracle 8 client software on the server? when you do
you
> must give it a service name remember that because you will have to use
this
> when creating the dsn and you will need rights to the db also.
> ----- Original Message -----
> From: "Julia Phu" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 10, 2001 4:26 PM
> Subject: Native Drivers - Oracle80
>
>
> > Greetings,
> >
> > Does anyone have any suggestion about setting up a DSN with Oracle80
> native
> > drivers? Or any sources to lookup?
> >
> > Here is my problem.
> >
> > Oracle8i and CF Application Server 4.5 Enterprise Edition installed on
NT
> 4.0
> > server with sp6a.
> >
> > When I run the verify, I got the following message.
> > * Are the data soruces setting configured properly?
> > --- I believed I did ---
> > * Did you provide valid security information in the data source
settings?
> > --- Honestly, I'm not quite sure what it means. ---
> > * For some databases the ColdFusion Server may need to be logged in
under
> a
> > special NT account rather than the default System Account. Use the
Window
> NT
> > Services Control Panel to change the account the ColdFusion Server
service
> is
> > using.
> > --- Again, I believed I did what it said. ---
> >
> > On the Oracle house, I have one sid with 2 instances. I need a
connection
> to
> > instance2. I'm stumbled on this problem for two days and couldn't find
any
> > material or expertise of the failure.
> >
> > Your enlightenment is greatly appreciated.
> >
> > Salute,
> > Julia Phu
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
