Re: Need help with Visual Basic 6 and PostgreSQL

--- On Wed, 11/21/07, Finn Lassen <dcio@AxiomInt.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
errormessage that it generates.  This will probably a very clear indication of what is wrong in your VB generated
record-setupdate.  

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
ofcharacter 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
toknow your database schema design well enough to know the names of your tables and columns.  It is also good practice
todirectly call out those column names in your code rather than simply guessing based on the field types. 

Regards,
Richard Broersma Jr.