Re: psqlODBC Experimental Enhanced branch

From: "Dave Page"

>Please test and evaluate it, examine the source code, benchmark it and
>anything else you can think of, and post any opinions to the mailing
>list.

Hi Dave;

I have experienced an inconsistent error with all versions of  the 8.1
driver up to an including 8.1.1.1.  I don't get any error via ODBC but the
Microsoft "Unfortunately Microsoft has encountered an error and must exit
the application..." dialog box.

I have never experienced this problem with the 7.02 branch up to 7.02.00.05.

I installed 7.02.026 on February 22 and did not encounter any problem until
this morning.

I am running PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe
(GCC) 3.4.2 (mingw-special).

I am running a VB.NET 2003 application accessing the database (obviously)
via ODBC.

I cannot find any error notification in mylog or the psqlodbc log.  In the
Windows event viewer the error message is:

    Event Type: Error
    Event Source: COM+
    Event Category: Unknown
    Event ID: 4786
    Date: 28/02/2006
    Time: 10:18:37 AM
    User: N/A
    Computer: DELL4500
    Description:
    The system has called a custom component and that component has failed
and generated an exception. This indicates a problem with the custom
component. Notify the developer of this component that a failure has
occurred and provide them with the information below.
    Component Prog ID: 0[ODBC][C:\Program
Files\psqlODBC+\bin\psqlodbc35w.dll]
    Method Name: IDispenserDriver::CreateResource
    Process Name: FormsTest.exe
    Exception: C0000005
    Address: 0x036F5AFF
    Call Stack:
    psqlodbc35w!SQLGetDiagFieldW + 0x2AF

The error is totally inconsistent - I can go for days without experiencing
any problem; at other times it occurs frequently.

Any thoughts?

Regards,
George