| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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. 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 | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2007-11-23 21:17:33 | Re: Need help with Visual Basic 6 and PostgreSQL |
| Previous Message | Richard Broersma Jr | 2007-11-23 14:39:19 | Re: Need help with Visual Basic 6 and PostgreSQL |