Fwd: ODBC breaks on some machines

This is a multi-part message in MIME format.
--------------090008030003060204060008
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit



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
*
*

--------------090008030003060204060008
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit











 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







--------------090008030003060204060008--

Re: Fwd: ODBC breaks on some machines

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
> *
> *


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc