Thread: Fwd: ODBC breaks on some machines

 Hi,

We  have a strange problem going on. The postgres ODBC breaks down at random at some machines.

What happens is:  Via ODBC we call an postgresql function (as example this: ) :

select getmynumber('abc') as result;

This works fine we can use the result in our application. However, on some of our customers PC's this suddenly stops working. We get an ODBC error Error -1:''  The only thing I can find in the odbc logging that is different opposed to the correct situation: QLExtendedFetch  with return code -1 (SQL_ERROR)

It seems random that this occurs. I cannot relate it to a windows patch, nor another software installation nor our own software.  The problem, over the course of 2 years, happens every now and then on some random pc. The only thing we have found to get it working again is to reinstall Windows. (it has happened now on several XP and several Windows 7 machines)

The client application uses MFC ODBC.

I have logging of odbc, mylog and psqlodc available.

Can somebody help with this?
Kind regards,
Albert Wessel

Hi.

Sorry very late reaction.

The method of CURSOR which you use may influence a result.
Would you be shown the reproducible code, if possible?

and, Please send mylog to Inoue-san with me.
I appreciate your perseverance. thanks.

Regards,
Hiroshi Saito

(2011/09/12 18:54), Albert wrote:
>
>
> Hi,
>
> We have a strange problem going on. The postgres ODBC breaks down at
> random at some machines.
>
> What happens is: Via ODBC we call an postgresql function (as example
> this: ) :
>
> select getmynumber('abc') as result;
>
> This works fine we can use the result in our application. However, on
> some of our customers PC's this suddenly stops working. We get an ODBC
> error Error -1:'' The only thing I can find in the odbc logging that is
> different opposed to the correct situation: QLExtendedFetch with return
> code -1 (SQL_ERROR)
>
> It seems random that this occurs. I cannot relate it to a windows patch,
> nor another software installation nor our own software. The problem,
> over the course of 2 years, happens every now and then on some random
> pc. The only thing we have found to get it working again is to reinstall
> Windows. (it has happened now on several XP and several Windows 7 machines)
>
> The client application uses MFC ODBC.
>
> I have logging of odbc, mylog and psqlodc available.
>
> Can somebody help with this?
> Kind regards,
> Albert Wessel
> *
> *