On Tuesday, Nov 12, 2002, at 08:06 US/Pacific, Robert Shaw wrote:
> I've installed CFMX (upgrade from 5) and can not connect to the Oracle
> 8.1.7
> database using the native cold fusion driver, OCI, or the thin type.
> The
> error is:
>
> Connection verification failed for data source: admin_dept_dba
> []java.sql.SQLException: SQLException occurred in JDBCPool
> while attempting to connect, please check your username,
> password, URL, and other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException
> occurred in JDBCPool while attempting to connect, please check
> your username, password, URL, and other connectivity info.
If you're using the default Macromedia-supplied driver (which for
Oracle 8i), then you need to specify the following data:
Data Source Name (admin_dept_dba)
SID Name: whatever your Oracle instance is known by in the TNS setup
Server: IP or fully-qualified domain name of server hosting the database
Port: 1521 (usually)
Username: your Oracle login name
Password: your Oracle password
Description: can leave blank
Under Advanced Settings, you may or may not need to change stuff. I
have Maintain Connections checked (and CLOB, plus all the Allowed SQL
options).
If you can connect to the database using sqlplus from that server, CF
ought to be able to connect:
sqlplus oracleloginname/oraclepassword@sidname
For the Thin Client, your JDBC URL should look like:
jdbc:oracle:thin:@servername:1521:sidname
and Driver Class should be:
oracle.jdbc.OracleDriver
(or oracle.jdbc.driver.OracleDriver)
> 1. Does anyone have any tips or tricks for connecting to Oracle
Does the above help? I've effectively copied settings from the two data
sources I have setup here which work fine.
> 2. Is there a recommendation for using Native, OCI or thin?
The supplied driver should be fine for most Oracle 8i work. If you are
working extensively with CLOB/BLOB data, you will probably find the OCI
driver (which is a 'native' driver!) will be faster / more reliable.
Otherwise you may find the Thin Client driver faster (than the supplied
8i driver). I've used all three but it really depends on what you're
doing with data...
Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/
Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
