Re: Need help with Visual Basic 6 and PostgreSQL

On 23 Nov 07 9:39 AM, Richard Broersma Jr wrote: <blockquote cite="mid:861905.97007.qm@web31812.mail.mud.yahoo.com"
type="cite"><prewrap="">
 
Does your table really have all of these field names?</pre></blockquote> 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
characteris 0FH. <br /><br /> Since it goes through the loop OK the first time, it is obviously a bug, and everything
pointsto the ODBC driver.<br /><blockquote cite="mid:861905.97007.qm@web31812.mail.mud.yahoo.com" type="cite"><pre
wrap=""> In addition to the "" field, I am suspicious of the "(" field.</pre></blockquote> There is no "(" field. The
"("is the SQL syntax for enumerating the fields to be populated. <blockquote
cite="mid:861905.97007.qm@web31812.mail.mud.yahoo.com"type="cite"><pre wrap="">  I am curious, if the ado recordset is
seeingmore fields than the table actually has.</pre></blockquote> Nope. I checked that.<br /><blockquote
cite="mid:861905.97007.qm@web31812.mail.mud.yahoo.com"type="cite"><pre wrap="">What version number of PostgreSQL are
yourunning. What is the version number of the ODBC driver that you are using?  Are they the latest released versions?
</pre></blockquote><prewrap="">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
evaluationto determine which database to replace the Borland with. I really should move on to looking at MySQL.
 
</pre>