Suzanne
First of all, thanks for you helping.
Sorry I have informed wrong my CF Version...
It's acctually the Professional Edition.
To use "Oracle ODBC driver" instead of "Microsoft ODBC for
Oracle" I installed
full Oracle 8.1.7 client on my appl Server (even though my DB
server is a 8.1.5
oracle).
I have dowlnoaded from Oracle OTN the 9.1.0.2 classes.zip (jdk
1.1 & 1.2)
files and put on
\oracle\ora81\jdbc\lib
No improvement.
I'm still using "Oracle ODBC driver" configured on ODBC
stamped 8.01.07.00.
I'm thinking about download full 9.1.0.2 client (~600MB) and
install
full client.
I thought about migrate to direct oracle connection but
it's a huge sistem lots of CFM files that have been on
developing for more than 4 years... It would be crazy
to change all "odbcdatetime" and other odbc functions
present on application.
Orison Almeida
-----Mensagem original-----
De: Suzanne Capener [mailto:[EMAIL PROTECTED]
Enviada em: ter�a-feira, 18 de mar�o de 2003 23:08
Para: CF-Server
Assunto: Re: RES: Database connection problem
If you are using the Oracle driver that comes with CFMX Enterprise
edition, then I don't think that it is your client. The client mattered
in our situation because we are using CFMX Pro and the Pro edition does
not come with Oracle drivers so we had to download and use the Oracle
JDBC thin client drivers from Oracle.
It could be that the Oracle driver is now JDBC to ODBC bridged. I would
also search or list this problem on the macromedia forums for
coldfusion. Orison Almeida <[EMAIL PROTECTED]> wrote:Thanks ppl
I'm using MXEnterprise on WIN2K sever (app sever) conecting using a
8.1.7 client to another WIN2K sever with oracle 8.1.5. I applied CFMX
updater 2 but this problem (that I had before it) continues. I'm using
Oracle ODBC Driver (this is not the "Microsoft ODBC for Oracle").
As advised, I'll try other clients.
thanks
Orison.
re2========
Looks like you are using an ODBC Driver, yes CFMX will fail with ODBC
Connections under load. What Oracle version? You can get the Type IV
driver from otn.oracle.com, use that.
Joe Eugene
re1========
Suzanne Capener [mailto:[EMAIL PROTECTED]
Are you running CFMX Enterprise or Pro?
We are running CFMX pro on Win2K and WinXP against an Oracle 8.1.5 & .7
databases and have not had any trouble with connections. We use the
Oracle jdbc thin driver. The trick to using the Oracle thin driver is to
use the 9.2.0.1 version. (Even though we are running an Oracle 8.x
database, the 9.2.0.1 driver is backward compatible and is the only one
that works.) No ideas on why the your system would be loosing the
database coonection. Have you applied the CFMX updater 2?
Suzanne
============
Orison Almeida wrote:My CFMX application works well
(and worked perfectly last 2 years in CF45).
In MX sometimes loose DB connection, with the following message:
[MERANT][SequeLink JDBC Driver]An internal error occurred
Some "RELOAD" and it comes back normally as nothing had happened
Any ideas???
btw: CFMX / WIN2k / Oracle
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or
visit the list page at www.houseoffusion.com
