We actually ended up using the following procedure which I found in the
archive (should have searched first). Our problem was
that the DBA gave us an alias not the actual service name, so the connection
failed. When we changed that it worked fine.
a. Download Version 9.2.0.1 Oracle JDBC Thin Client Drivers from
http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html. You
only need to download classes12.zip and nls_charset12.zip files.
b. Configure JVM Settings:
Open CFMX Administrator http://127.0.0.1/cfide/administrator/index.cfm
Click on Server Settings->Java and JVM
Add "c:\jdbc_thin_drivers" to the Class Path
Click on "Submit Changes"
NOTE: (the folder jdbc_thin_drivers is just one we made up. They can be
placed anywhere.)
c. Copy the classes12.zip and nls_charset12.zip files into the
"c:\jdbc_thin_drivers" folder.
d. Stop and restart all CFMX Server Services
Driver Configuration Settings when creating datasources:
Note: The settings are case sensitive. The Driver Name setting is optional.
Driver: Other
JDBC URL: jdbc:oracle:thin:@<server name>:<port>:<SID>
Driver Class: oracle.jdbc.OracleDriver
-----Original Message-----
From: Rob Rusher [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 12:19 PM
To: CF-Server
Subject: Re: How to: Using Oracle JDBC drivers instead of MX's
Assuming you haven't found the answer to this yet, I republished a note from
my
old blog to my new one regarding this issue.
Step by step how-to for using the Oracle JDBC drivers:
<http://crawdaddy.blogspot.com>
Second, you can not specify connection strings in CFMX at this time.
(period)
HTH
Regards,
Rob Rusher
--- "Middleton, Andrew" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> How would one get CF MX version 6.1 to recognize the JDBC drivers that
> Oracle uses instead of the default drivers for Oracle MX
> provides?
>
> They have been installed already on a Win2K box and we're using version
> 9.2.0.2.1 of Oracle.
>
> Also, how can one specify a specific connectionstring for the Oracle
driver?
>
> Andrew Middleton
> Senior Technical Consultant
> AT&T Government Solutions
> work: 703-506-5266 / cell: 202-210-0105
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> Integrated Solutions from a Trusted Source
>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
