Re: Need help with Visual Basic 6 and PostgreSQL

[Finn Lassen <dcio(at)AxiomInt(dot)com>]

On 23 Nov 07 9:39 AM, Richard Broersma Jr wrote:

Does your table really have all of these field names?

Yes. In fact there are 40 fields, the first four ("AccountNo", "Company", "Contact" and "LastName") appear to be replaced by the illegal character.  The illegal character is 0FH.

Since it goes through the loop OK the first time, it is obviously a bug, and everything points to the ODBC driver.

  In addition to the "" field, I am suspicious of the "(" field.

There is no "(" field. The "(" is the SQL syntax for enumerating the fields to be populated.

  I am curious, if the ado recordset is seeing more fields than the table actually has.

Nope. I checked that.

What version number of PostgreSQL are you running. What is the version number of the ODBC driver that you are using?  Are they the latest released versions?
  

pg_ctl.exe is version 8.2.5.7260
psqlodbc30a.dll is version 8.2.4.0

I downloaded them a couple of days ago, so I have to assume they are the latest.

How do I contact the developers?

Finn

P.S. Unfortunately I have already spent way more time on this than I can afford. This was supposed to be a quick evaluation to determine which database to replace the Borland with. I really should move on to looking at MySQL.