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

Re: Need help with Visual Basic 6 and PostgreSQL

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org, Finn Lassen <dcio(at)AxiomInt(dot)com>
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Date: 2007-11-22 03:17:36
Message-ID: 523506.48216.qm@web31803.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- On Wed, 11/21/07, Finn Lassen <dcio(at)AxiomInt(dot)com> wrote: 
> It now crashes at the .Update statement.
> Any suggestions on how proceed?
> Do I have to configure the PostgreSQL ANSI driver somehow?

I would look at your PostgreSQL logs to see the exact crashing update statement that VB is sending to PostgreSQL to process (you may need to first turn on query logging in your postgresql.conf file and then restart your PostgreSQL service).  Next I would try to manually run the listed update query in postgres' command line editor psql to see the error message that it generates.  This will probably a very clear indication of what is wrong in your VB generated record-set update. 

Also, give the how-to example for using ADO + ODBC + PG a try that comes with your ODBC installation help documentation?
it is found in this path on my computer: 
C:\Program Files\PostgreSQL\8.2\doc\psqlODBC\howto-vb.html

Also, you may consider using the PostgreSQL Unicode ODBC driver over the ANSI driver since it supports a larger array of character sets.

I wish I could be of more help, but I've never really grown accustom to using Records sets to update or delete records.  I've always manually crafted my own SQL statements that I've passed to the back-end server.

Also at the risk of getting my head bitten off by someone more knowledgeable that disagrees :-), it is a good practice to know your database schema design well enough to know the names of your tables and columns.  It is also good practice to directly call out those column names in your code rather than simply guessing based on the field types.

Regards,
Richard Broersma Jr.

In response to

Responses

pgsql-odbc by date

Next:From: Paul LambertDate: 2007-11-22 03:34:01
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Previous:From: Finn LassenDate: 2007-11-22 02:36:57
Subject: Need help with Visual Basic 6 and PostgreSQL

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