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

Re: Need help with Visual Basic 6 and PostgreSQL

From: Finn Lassen <dcio(at)AxiomInt(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Date: 2007-11-23 20:27:37
Message-ID: 474737B9.406@AxiomInt.com (view raw or flat)
Thread:
Lists: pgsql-odbc
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
On 23 Nov 07 9:39 AM, Richard Broersma Jr wrote:
<blockquote cite="mid:861905(dot)97007(dot)qm(at)web31812(dot)mail(dot)mud(dot)yahoo(dot)com"
 type="cite">
  <pre wrap=""><!---->
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.&nbsp; The illegal character is 0FH. <br>
<br>
Since it goes through the loop OK the first time, it is obviously a
bug, and everything points to the ODBC driver.<br>
<blockquote cite="mid:861905(dot)97007(dot)qm(at)web31812(dot)mail(dot)mud(dot)yahoo(dot)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(dot)97007(dot)qm(at)web31812(dot)mail(dot)mud(dot)yahoo(dot)com"
 type="cite">
  <pre wrap="">  I am curious, if the ado recordset is seeing more fields than the table actually has.</pre>
</blockquote>
Nope. I checked that.<br>
<blockquote cite="mid:861905(dot)97007(dot)qm(at)web31812(dot)mail(dot)mud(dot)yahoo(dot)com"
 type="cite">
  <pre wrap="">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?
  </pre>
</blockquote>
<pre wrap="">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.
</pre>
</body>
</html>



Attachment: unknown_filename
Description: text/html (1.9 KB)

In response to

Responses

pgsql-odbc by date

Next:From: Richard Broersma JrDate: 2007-11-23 21:17:33
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Previous:From: Richard Broersma JrDate: 2007-11-23 14:39:19
Subject: Re: Need help with Visual Basic 6 and PostgreSQL

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