"... 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
