bug report (i think :-/ )

From: bugman(at)liza(dot)net(dot)mx
To: pgsql-interfaces(at)postgresql(dot)org
Subject: bug report (i think :-/ )
Date: 1998-10-07 09:26:26
Message-ID: 361B33C2.A3538A0F@liza.net.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

hi i'm having problems connecting BDE with postgreSQL.

my problem comes wen i try to use "parsed" parameter in the odbc config.

i'm using the recomended config for the odbc in the FAQ:

this is my psqlodbc.log:
=====================================
DSN info:
DSN='siaPostgreSQL',server='192.168.1.1',port='5432',dbase='sia',user='postgres',passwd=''

readonly='1',protocol='',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
conn = 50202748, SQLConnect(DSN='siaPostgreSQL', UID='postgres', PWD='')

Global Options: Version='06.30.0250', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=0, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=50202748, query=' '
conn=50202748, query='set DateStyle to 'ISO''
conn=50202748, query='set geqo to 'OFF''
conn=50202748, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=50202748, query='select relname, usename, relhasrules from
pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and
int4out(usesysid) = int4out(relowner)order by relname'
[ fetched 41 rows ]
conn=50202748, query='select * from clientes;
'
[ fetched 0 rows ]
conn=50202748, query='select u.usename, c.relname, a.attname,
a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from
pg_user u, pg_class c, pg_attribute a, pg_type t where
int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and
a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'clientes'
order by attnum'
[ fetched 34 rows ]
================================
crash report ofr dbExplorer produced when i try to do any simple sql
statement
"select * from products"

DBEXPLOR caused an invalid page fault in
module IDODBC32.DLL at 015f:4da2ddcd.
Registers:
EAX=bff89dac CS=015f EIP=4da2ddcd EFLGS=00010292
EBX=0063f888 SS=0167 ESP=00540094 EBP=005400d4
ECX=00640000 DS=0167 ESI=81655974 FS=4bef
EDX=388b5708 ES=0167 EDI=4da423cc GS=0000
Bytes at CS:EIP:
83 3a 00 74 63 e8 39 10 00 00 64 8b 0d 04 00 00
Stack dump:
005401a4 81655974 0063f888 00000000 00000000 00000000 00000000 00000000
00000000 0063f870 0063f8ac 00000000 0001001f 005401c0 0063f888 005401a4
=======================================

Browse pgsql-interfaces by date

  From Date Subject
Next Message bugman 1998-10-07 09:29:45 extra information of the problem i discovered.
Previous Message Josh Friess 1998-10-07 08:22:02 RE: [INTERFACES] RE: libpq++ and gcc