Skip site navigation (1) Skip section navigation (2)

Re: Access violation - probably not the fault of Postgres

From: David Gardner <david(dot)gardner(at)yucaipaco(dot)com>
To: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Access violation - probably not the fault of Postgres
Date: 2007-03-08 17:43:51
Message-ID: 45F04B57.9010401@yucaipaco.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Could you post the code in question? How are you initializing your 
recordset object? Have you tried feeding the database object an insert 
statement via the execute() function?


Paul Lambert wrote:
> I've got an application written in VB which pipes updates to a 
> database in Postgres. The application is written in MS Visual Basic 
> 6.0 using DAO3.6 via ODBC.
>
> If a record exists in the PG database and my VB app therefore does an 
> Edit/Update, it works without a problem.
>
> If the record doesn't exist and I therefore need to do an 
> AddNew/Update my client application crashes with an access violation 
> on the update.
>
> I'm relatively sure it's something on the VB side that is causing this 
> and nothing to do with PG, but I'm just posting here in case anyone 
> has some thoughts about potential causes within PG or its ODBC driver.
>
> Any thoughts would be welcome.
>
> Thanks,
> Paul.
>


In response to

Responses

pgsql-odbc by date

Next:From: WylieDate: 2007-03-08 18:44:36
Subject: distributing postgresql driver
Previous:From: AndrusDate: 2007-03-08 17:19:53
Subject: Re: examples VFP with Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group