PSQLODBC error

From: "Ken J(dot) Wright" <ken(at)ori-ind(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: PSQLODBC error
Date: 1999-03-08 23:47:53
Message-ID: 3.0.32.19990308154751.007bc580@ren.cncware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
Sql1.log text/plain 30.3 KB
unknown_filename text/plain 1 byte

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thomas G. Lockhart 1999-03-09 04:15:59 Re: [INTERFACES] [off topic] Date and time fields
Previous Message secret 1999-03-08 23:24:36 Perl Interface(Pg.pm) -- How to free $result