Here are a few questions and things to try:
Is your $PATH set up correctly?
Can you "tnsping" your database (any error messages)?
Is your database on a separate machine (can you ping that machine)?
Is the db listener set up?
Make sure the connect string in your datasource properties corresponds
exactly to the name in tnsnames.ora.
Is the Oracle user you're using in CF set up?
Feel free to contact me off-list if you like. Good luck.
Regards,
�
Jim Gram
Aircraft owners and Pilots Association
Internet Services Department
421 Aviation Way
Frederick, MD� 20701
(301) 695-2382
FAX: (301) 695-2375
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Chris Jensen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 12:23 AM
To: CF-Server
Subject: Using MERANT oracle 8 client under linux
Hi,
I'm having a fair bit of trouble connecting to an oracle database. I've
installed cold fusion and the apache server under redhat 7 and they seem
to be working fine.
I've installed the oracle 8.1.6 client for linux, configured
tnsnames.ora and sqlnet.ora and I'm able to use sqlplus to open the data
sources.
I've setup ORACLE_HOME, LD_LIBRARY_PATH and VAR_LIST in
$CFHOME/bin/start according to the cold fusion docs.
When I try to verify the datasource in cf adminstrator, it says the
connection to the data source failed.
If anyone can tell me what I've missed I'd really appreciated it
--
---------------------------------------------------------------------
Chris Jensen [EMAIL PROTECTED]
Educational Experience (Australia)
Postal Address: PO Box 860, Newcastle NSW 2300
Freecall: 1-800-025 270 International: +61-2-4923 8222
Fax: (02) 4942 1991 International: +61-2-4942 1991
Visit our online Toy store! http://www.toysandmore.com.au/
---------------------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
