PSQLODBC error - Mailing list pgsql-interfaces

From Ken J. Wright
Subject PSQLODBC error
Date
Msg-id 3.0.32.19990308151359.007f1300@ren.cncware.com
Whole thread Raw
List pgsql-interfaces
-----------------------------------------------------------
An update here Byron,

If I remove fields cl9 thru the end, the problem goes away.
Try to add one more field back & it blows.
The table as shown here is no trouble in psql or libpq.
-----------------------------------------------------------

Hello Byron,

I'm getting the following error when opening a particular PostgreSQL table.

Access violation at adress 10001EF6 in module 'PSQLODBC'. Read of address
FFFFFFFF.

This does not happen with any other table. I have dropped and re-created,
but no help. I've attached sql1.log. Following is the schema.
PostgreSQL 6.4, psqlodbc 6.40.0004. Any clues?

Thanks,

Ken

Table    = tk_cfg
+----------------------------------+----------------------------------+-----
--+
|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-----
--+
| config_id                        | varchar()                        |
16 |
| tkpath                           | varchar()                        |
0 |
| netpath                          | varchar()                        |
0 |
| workpath                         | varchar()                        |
0 |
| temppath                         | varchar()                        |
0 |
| execpath                         | varchar()                        |
0 |
| applpath                         | varchar()                        |
0 |
| statid                           | varchar()                        |
16 |
| menudb                           | varchar()                        |
8 |
| stepdb                           | varchar()                        |
8 |
| procdb                           | varchar()                        |
8 |
| typedb                           | varchar()                        |
8 |
| cmnddb                           | varchar()                        |
8 |
| conddb                           | varchar()                        |
8 |
| pwdb                             | varchar()                        |
8 |
| varfil                           | varchar()                        |
12 |
| decprec                          | int2                             |
2 |
| touchcrt                         | char()                           |
1 |
| refresh                          | int2                             |
2 |
| tempscript                       | varchar()                        |
8 |
| appltemppath                     | varchar()                        |
0 |
| applmenudb                       | varchar()                        |
8 |
| applmenuid                       | varchar()                        |
25 |
| applmenuexe                      | varchar()                        |
0 |
| cl1                              | int2                             |
2 |
| cl2                              | int2                             |
2 |
| cl3                              | int2                             |
2 |
| cl4                              | int2                             |
2 |
| cl5                              | int2                             |
2 |
| cl6                              | int2                             |
2 |
| cl7                              | int2                             |
2 |
| cl8                              | int2                             |
2 |
| cl9                              | int2                             |
2 |
| cl10                             | int2                             |
2 |
| cl11                             | int2                             |
2 |
| cl12                             | int2                             |
2 |
| cl21                             | int2                             |
2 |
| cl22                             | int2                             |
2 |
| cl23                             | int2                             |
2 |
| cl24                             | int2                             |
2 |
| rptlen                           | int2                             |
2 |
| rptwid                           | int2                             |
2 |
| rptcmd                           | varchar()                        |
80 |
+----------------------------------+----------------------------------+-----
--+
pioneer=> \d tk_cfg_idx

Table    = tk_cfg_idx
+----------------------------------+----------------------------------+-----
--+
|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-----
--+
| config_id                        | varchar()                        |
-4 |
+----------------------------------+----------------------------------+-----
--+


Attachment

pgsql-interfaces by date:

Previous
From: Matthew Hagerty
Date:
Subject: [off topic] Date and time fields
Next
From: secret
Date:
Subject: Perl Interface(Pg.pm) -- How to free $result