Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem with updates

Problem with updates

From
pcross@trusecure.com
Date:

I have been trying to get updates to work via VB6 and ODBC and the machine hangs whenever I try. I have also tried doing updates via MSQuery and Access linked tables with the same result.

I am running Postgres 7.2.1 on Red Hat and windows 2000 for the ODBC client.

I tried the code under the VB example and it also hung when I tried an execute (I was originally trying ADO command objects).

With the recordset updates they appear to take but then updates don't appear when I select directly from postgres (though I didn't spend too much time on this).

Any ideas or additional things to try?

Re: Problem with updates

From
Hiroshi Inoue
Date:
> pcross@trusecure.com wrote:
>
> I have been trying to get updates to work via VB6 and ODBC and the
> machine hangs whenever I try. I have also tried doing updates via
> MSQuery and Access linked tables with the same result.
>
> I am running Postgres 7.2.1 on Red Hat and windows 2000 for the ODBC
> client.
>
> I tried the code under the VB example and it also hung when I tried an
> execute (I was originally trying ADO command objects).

Could you show us the example ?

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

Re: Problem with updates

From
"Corey W. Gibbs"
Date:
Could you give an example?    Without seeing any code it's kind of tough
corey
 
----- Original Message -----
Sent: Thursday, June 27, 2002 2:55 PM
Subject: [ODBC] Problem with updates

I have been trying to get updates to work via VB6 and ODBC and the machine hangs whenever I try. I have also tried doing updates via MSQuery and Access linked tables with the same result.

I am running Postgres 7.2.1 on Red Hat and windows 2000 for the ODBC client.

I tried the code under the VB example and it also hung when I tried an execute (I was originally trying ADO command objects).

With the recordset updates they appear to take but then updates don't appear when I select directly from postgres (though I didn't spend too much time on this).

Any ideas or additional things to try?

Re: Problem with updates

From
pcross@trusecure.com
Date:
Thanks for the replies, but it apparently was some sort of configuration issue with Postgres. Not sure exactly why it is working now (changed so many things), but seems to be performing as expected.
 
 

 

-----Original Message-----
From: Corey W. Gibbs [mailto:cascadia@nventure.com]
Sent: Monday, July 01, 2002 10:42 PM
To: Cross, Patrick; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Problem with updates

Could you give an example?    Without seeing any code it's kind of tough
corey
 
----- Original Message -----
Sent: Thursday, June 27, 2002 2:55 PM
Subject: [ODBC] Problem with updates

I have been trying to get updates to work via VB6 and ODBC and the machine hangs whenever I try. I have also tried doing updates via MSQuery and Access linked tables with the same result.

I am running Postgres 7.2.1 on Red Hat and windows 2000 for the ODBC client.

I tried the code under the VB example and it also hung when I tried an execute (I was originally trying ADO command objects).

With the recordset updates they appear to take but then updates don't appear when I select directly from postgres (though I didn't spend too much time on this).

Any ideas or additional things to try?