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 <http://www.reynolds.com.au>
------------------------------------------------------------------------------------
For AutoLedgers technical support, please send an email to
helpdesk@autoledgers.com.au.