pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedProblems in ODBC driver
2+ messages / 2 participants
[nested] [flat]
* Problems in ODBC driver
@ 2000-02-21 15:18 richard clark <richard@elysium.ltd.uk>
0 siblings, 0 replies; 2+ messages in thread
From: richard clark @ 2000-02-21 15:18 UTC (permalink / raw)
To: pgsql-interfaces
Thanks in advance for any feedback....
I have just installed the latest version I can find of the ODBC driver for
Windows for PostgreSQL 6.40.0008.
I have tried accessing PostgreSQL on two machines. Version is 6.5.2
This is implemented on a Windows 98 second edition system - all the ODBC
DLLs seem to be 3.510.3711.
It apparently installs correctly, and I can specify a data source in the
ODBC applet - the advanced options show up and can be changed.
If I specify an incorrect database name or invalid username/pw I get the
correct prompts.
If I am not authenticated to use the database in pg_hba.conf, I am told so
correctly.
If I do have access to the database and everything is apparently correct
then poof...
a GPF...
MSQRY32 caused a stack fault in module PSQLODBC.DLL at 017f:016b5247.
Anyone got any ideas - this even happens with the Template1 default database.
Below is the psqlodbc.log trace...
conn=23986296, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info:
DSN='PostgreSQL',server='192.168.1.68',port='5432',dbase='mmsig',user='nobod
y',passwd=''
readonly='1',protocol='6.4',showoid='0',fakeoidindex='0',showsyst
readonly='1',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0008', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=0,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=23986296, query=' '
conn=23986296, query='set DateStyle to 'ISO''
conn=23986296, query='set geqo to 'OFF''
conn=23986296, query='set ksqo to 'ON''
conn=23986296, query='select oid from pg_type where typname='lo''
the SQL.LOG file doesn't seem meaningful last few entries in it are..
msqry32 fff7d88f:fff60507 ENTER SQLAllocConnect
HENV 0x00d3ff1c
HDBC * 0x0060ed88
msqry32 fff7d88f:fff60507 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 0x00d3ff1c
HDBC * 0x0060ed88 ( 0x00c402f4)
msqry32 fff7d88f:fff60507 ENTER SQLSetConnectOption
HDBC 0x00c402f4
UWORD 103 <SQL_LOGIN_TIMEOUT>
UDWORD 45
msqry32 fff7d88f:fff60507 EXIT SQLSetConnectOption with return
code 0 (SQL_SUCCESS)
HDBC 0x00c402f4
UWORD 103 <SQL_LOGIN_TIMEOUT>
UDWORD 45
msqry32 fff7d88f:fff60507 ENTER SQLDriverConnectW
HDBC 0x00c402f4
HWND 0x0000079c
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1f4be068
SWORD 8
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
FWIW, I can access the database using the Zeus Windows app.....but a
select * from users gives incorrect results in
part of the table (a number of columns duplicate a userid column raher than
containing the correct value). Selecting individual columns with a select
column from table query works though....
Richard Clark: richard@elysium.ltd.uk
Elysium Ltd, Crowborough, UK - JPEG Editor and WebMaster
'Let standard-authors, thus, like trophies borne - The Dunciad
Appear more glorious as more hacked and torn' ;<{) - Alexander
Pope (1688-1744)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problems in ODBC driver
@ 2000-03-02 12:44 Kardos, Dr. Andreas <kardos@repas-aeg.de>
0 siblings, 0 replies; 2+ messages in thread
From: Kardos, Dr. Andreas @ 2000-03-02 12:44 UTC (permalink / raw)
To: richard@elysium.ltd.uk; +Cc: pgsql-interfaces
The problem is probably MSQRY32.EXE itself, not the ODBC driver.
MSQRY32.EXE from Office 95 and 97 has been linked with a stack of only 32
KB. In Office 2000 the stack size has been set to the default value of 1 MB.
You can set the stack size to the default value with
EDITBIN /STACK:0x100000 Msqry32.exe
EDITBIN comes with the developer studio.
Andreas Kardos
--------------------------------------------------
richard clark <richard@elysium.ltd.uk> wrote:
Thanks in advance for any feedback....
If I do have access to the database and everything is apparently correct
then poof...
a GPF...
MSQRY32 caused a stack fault in module PSQLODBC.DLL at 017f:016b5247.
Anyone got any ideas - this even happens with the Template1 default
database.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-03-02 12:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-21 15:18 Problems in ODBC driver richard clark <richard@elysium.ltd.uk>
2000-03-02 12:44 Re: Problems in ODBC driver Kardos, Dr. Andreas <kardos@repas-aeg.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox