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

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 (view raw or flat)
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 |
+----------------------------------+----------------------------------+-----
--+

pgsql-interfaces by date

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

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