You need to install the Oracle8i client on your machine and then modify two
files - tnsnames.ora and sqlnet.ora
This is a sample of what you should have in the tnsnames.ora file (assuming
rate is the name of your oracle box) - you may have more than 1 of these
depending on how many oracle servers you are connecting to.
RATE.FENICS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.30.31)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rate.fenics.com )
)
)
Here is the sqlnet.ora file example
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = off
NAMES.DEFAULT_DOMAIN = FENICS.COM
NAMES.DIRECTORY_PATH = (TNSNAMES,ONAMES)
Then you will be able to connect with the native driver.
Scott
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 12:26 AM
To: Coldfusion
Subject: Problem to connect Oracle8i through ODBC
Hi,
I have problem to connect Coldfusion to Oracle8i through ODBC. I have
installed Oracle ODBC driver 8.01.55.00, but I can't even see this driver in
ODBC dirver list when I want to add a new data source in Coldfusion
Administrator. Anyone have an idea?? Please help. Thanx in advance.
Albert
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.