> DataDirect drivers ColdFusion 5.0 Enterprise is using?
>
> Are there updated native (and ODBC for that matter) Oracle
> drivers available for CF 5.0?
I have no idea how you'd find out the driver version, other than poking
around at the various DLLs in your \cfusion\bin directory. I don't think
there are any updates available from Macromedia for those drivers.
> All of a sudden we cannot maintain our Oracle connectivity
> using the native drivers (haven't yet tried switching to
> the ODBC drivers). All data sources using these drivers
> are failing, even ones that we have not used when the
> failures occur. If we restart the ColdFusion Application
> service we get back our connectivity for just a few minutes
> before all the Oracle data sources go down again (the CF
> Application service still shows as running and CF still
> appears to be functioning normally after the data sources
> go down, we just discovered that restarting the service
> restores the Oracle connectivity - for a few minutes) and
> the pattern repeats all through the day. When the Oracle
> data sources in CF Admin are down we can still connect
> to Oracle using the Oracle tools on the server. DB2 data
> sources and Excel data sources are not affected and continue
> to function normally.
>
> The only change (and it's a big one!) to our environment is
> that last Wednesday our Oracle database moved to a new bigger
> and faster server. It was not a db upgrade, just a move to a
> new box. We had no problems Thursday and Friday and the
> performance improved dramatically. When we left Friday
> everything was just fine. When we came in Monday morning we
> could not keep the Oracle connections through ColdFusion open.
This doesn't sound like a CF problem at all - maybe it's a problem with the
underlying network? You might try installing a newer version of the Oracle
client, which is used by CF's native drivers.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
