Severe problems with ColdFusion 5, ODBC and PostgreSQL 7.2.1

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Severe problems with ColdFusion 5, ODBC and PostgreSQL 7.2.1
Date: 2002-08-10 14:59:04
Message-ID: 2266D0630E43BB4290742247C8910575014CE350@dozer.computec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi!

We've recently migrated our frontend database from Oracle on Win2k to
PostgreSQL 7.2.1 on SuSE Linux 7.2.1. Everything is running - most of
the time. But about once every hour, at least one of our three
webservers running ColdFusion 5 is throwing one of the following errors:

ODBC Error Code = IM005 (Driver's SQLAllocConnect failed)
[Microsoft][ODBC Driver Manager] Fehler beim SQLAllocHandle-Aufruf für
Treiber auf SQL_HANDLE_DBC.
(Error calling SQLAllocHandle for Driver on SQL_HANDLE_DBC).

respectively:

ODBC Error Code = S1000 (General error)
The database does not exist on the server or user authentication failed.

I've got to restart the ColdFusion Application Server service in the
services control panel before the server starts working again. It seems
like it just forgets how to connect to the databases from one moment to
the next. I don't really know what exactly is going on, so could anyone
give me some hints on how to determine the cause of all this and how to
resolve the issue?
Thank you very much!

Regards,
Markus

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Tom Lane 2002-08-10 15:32:15 Re: Severe problems with ColdFusion 5, ODBC and PostgreSQL 7.2.1
Previous Message Hiroshi Inoue 2002-08-09 00:19:34 Re: Select * causes a crash, or How I learned to Hate VB