Re: Values in the select

Dear Luf,

The connectionstring that is used is the following:

Provider=MSDASQL.1;Password=<snip>;Persist Security Info=True;User
ID=intwis2;Data Source=PostgreSQL;Extended
Properties="DSN=PostgreSQL;DATABASE=intwis9;SERVER=localhost;PORT=5432;SSLMO
DE=prefer;UID=intwis2;PWD=intwis2;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;Sho
wOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Sock
et=8192;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;Co
mmLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsL
ongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=
dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI
=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0"

The contents of psqlodbc_2972.log:

conn=120025968, PGAPI_DriverConnect(
in)='DSN=PostgreSQL;UID=intwis2;PWD=xxxxxxx;', fDriverCompletion=0
DSN info:
DSN='PostgreSQL',server='localhost',port='5432',dbase='intwis9',user='intwis
2',passwd='xxxxx'

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''

And of mylog_2972.log

[144]globals.extra_systable_prefixes = 'dd_;'
[144][[SQLAllocHandle]][144]**** in PGAPI_AllocEnv **
[144]** exit PGAPI_AllocEnv: phenv = 120063888 **
[144][[SQLSetEnvAttr]] att=200,2
[144][[SQLAllocHandle]][144]PGAPI_AllocConnect: entering...
[144]**** PGAPI_AllocConnect: henv = 120063888, conn = 120025968
[144]EN_add_connection: self = 120063888, conn = 120025968
[144] added at i =0, conn->henv = 120063888, conns[i]->henv =
120063888
[144][SQLGetInfo(30)][144]PGAPI_GetInfo: entering...fInfoType=77
[144]PGAPI_GetInfo: p='03.00', len=5, value=0, cbMax=12
[144][[SQLSetConnectAttr]] 103
[144]PGAPI_SetConnectAttr 103
[144]PGAPI_SetConnectOption: entering fOption = 103 vParam = 15
[144][SQLDriverConnect][144]PGAPI_DriverConnect: entering...
[144]**** PGAPI_DriverConnect: fDriverCompletion=0,
connStrIn='DSN=PostgreSQL;UID=intwis2;PWD=xxxxxxx;'
[144]our_connect_string = 'DSN=PostgreSQL;UID=intwis2;PWD=xxxxxxx;'
[144]attribute = 'DSN', value = 'PostgreSQL'
[144]copyAttributes:
DSN='PostgreSQL',server='',dbase='',user='',passwd='xxxxx',port='',sslmode='
',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[144]attribute = 'UID', value = 'intwis2'
[144]copyAttributes:
DSN='PostgreSQL',server='',dbase='',user='intwis2',passwd='xxxxx',port='',ss
lmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[144]attribute = 'PWD', value = 'xxxxx'
[144]copyAttributes:
DSN='PostgreSQL',server='',dbase='',user='intwis2',passwd='xxxxx',port='',ss
lmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[144]globals.extra_systable_prefixes = 'dd_;'
[144]globals.extra_systable_prefixes = 'dd_;'
[144]our_connect_string = 'DSN=PostgreSQL;UID=intwis2;PWD=xxxxxxx;'
[144]attribute = 'DSN', value = 'PostgreSQL'
[144]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[144]attribute = 'UID', value = 'intwis2'
[144]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[144]attribute = 'PWD', value = 'xxxxx'
[144]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[144]PGAPI_Disconnect: about to CC_cleanup
[144]in CC_Cleanup, self=120025968
[144]after CC_abort
[144]entering PGCONN_Destructor
[144]exiting PGCONN_Destructor
[144]after LIBPQ destructor
[144]exit CC_Cleanup
[144]PGAPI_Disconnect: done CC_cleanup
[144]PGAPI_Disconnect: returning...
[144][[SQLFreeHandle]][144]PGAPI_FreeConnect: entering...
[144]**** in PGAPI_FreeConnect: hdbc=120025968
[144]enter CC_Destructor, self=120025968
[144]in CC_Cleanup, self=120025968
[144]after LIBPQ destructor
[144]exit CC_Cleanup
[144]after CC_Cleanup
[144]after free statement holders
[144]exit CC_Destructor
[144]PGAPI_FreeConnect: returning...
[144][[SQLFreeHandle]][144]**** in PGAPI_FreeEnv: env = 120063888 **
[144]in EN_Destructor, self=120063888
[144]exit EN_Destructor: rv = 1
[144] ok

Unfortunately I did not find version 08.01.0104 on the postgresql web site
(http://www.postgresql.org/ftp/odbc/versions/msi/), where can I find it?

I've tested it with the Unicode version and the same problem occours.

Yours,

Aarjan

----- Original Message -----
From: "Ludek Finstrle" <luf(at)pzkagis(dot)cz>
To: "A.j. Langereis" <a(dot)j(dot)langereis(at)inter(dot)nl(dot)net>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Sent: Friday, December 23, 2005 10:52 AM
Subject: Re: [ODBC] Values in the select

> > The version of ODBC that I've got installed is 08.00.0102 (via MSI
installed).
>
> Has Unicode version same problem? Could you try psqlodbc 08.01.0104?
> Do you get same result?
>
> If there is still the problem could you send here mylog output?
>
> I can't see how you connect to pgsql (what options do you use?).
>
> Regards,
>
> Luf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>