Re: Access violation - probably not the fault of Postgres

Hiroshi Inoue wrote:
> 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.
> 
> Could you try the snapshot driver at
>  http://www.geocities.jp/inocchichichi/psqlodbc/index.html
> ?
> 
> regards,
> Hiroshi Inoue
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
> 
>                http://www.postgresql.org/about/donate
> 
> 

Still crashing.


Regards,
Paul.



-- 
Paul Lambert
Technical Support Team Leader and Database Administrator
AutoLedgers
Level 3, 823 Wellington Street, West Perth, W.A. 6005
Postal: P.O. Box 106, West Perth, W.A. 6872
Ph: 08 9217 5086 Fax: 08 9217 5055
AutoLedgers Technical Support Desk: 1800 649 987 (Free call) 08 9217 
5050 (Perth local and mobile)
Email: paul.lambert@autoledgers.com.au 
------------------------------------------------------------------------------------
For AutoLedgers technical support, please send an email to 
helpdesk@autoledgers.com.au.