Re: figuring out why I am having this issue - Mailing list pgsql-odbc

I did try looking at it a bit and did not resolve the issue.
I used a snapshot build (was a few days older then my build) and it did not
seem to have any issue with the specific text field, but the asp page was
not formatting correctly, so maybe it was doing something else.

I also tried setting TextAsLongVarchar=0
Which worked on my development box running XP pro, but did not work in
production running win2k.

I will look more tomorrow, but I could not even see what the variable was
being set to, to look at the other modules.
In my log file I could only see references to it :
MaxLongVarcharSize=16280;

Looking for the value 16280 I could see :
Just now cutting this out I thought it was weird that it says
B1 = 8k in one line (the line that mentions maxvarcharlength and in another
line it has B1=16k?

CopyCommonAttributes:
A7=100;A8=4096;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_;attribute = 'MaxVarcharSize', value = '254'

And

CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'TextAsLongVarchar', value = '1'


our_connect_string =
'DRIVER={PostgreSQL};UID=postgres;PWD=xxxxxx;DATABASE=wazagua;SERVER=192.168
.123.121;PORT=5432;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;Ro
wVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;Unknown
Sizes=0;MaxVarcharSize=254;MaxLongVarcharSize=16280;Debug=1;CommLog=0;Optimi
zer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;B
oolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversi
on=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongV
arBinary=0;UseServerSidePrepare=0;'
attribute = 'DRIVER', value = '{PostgreSQL}'
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_;attribute = 'UID', value = 'postgres'
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_;attribute = 'PWD', value = 'xxxxx'
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_;attribute = 'DATABASE', value = 'wazagua'
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_;attribute = 'SERVER', value = '192.168.123.121'
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_;attribute = 'PORT', value = '5432'
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_;attribute = 'ReadOnly', value = '0'
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_;attribute = 'Protocol', value = '6.4'
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_;attribute = 'FakeOidIndex', value = '0'
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_;attribute = 'ShowOidColumn', value = '0'
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_;attribute = 'RowVersioning', value = '0'
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_;attribute = 'ShowSystemTables', value = '0'
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_;attribute = 'ConnSettings', value = ''
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_;attribute = 'Fetch', value = '100'
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_;attribute = 'Socket', value = '4096'
CopyCommonAttributes:
A7=100;A8=4096;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_;attribute = 'UnknownSizes', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;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_;attribute = 'MaxVarcharSize', value = '254'
CopyCommonAttributes:
A7=100;A8=4096;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_;attribute = 'MaxLongVarcharSize', value = '16280'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'Debug', value = '1'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'CommLog', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'Optimizer', value = '1'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'Ksqo', value = '1'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'UseDeclareFetch', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'TextAsLongVarchar', value = '1'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'UnknownsAsLongVarchar', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'BoolsAsChar', value = '1'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'Parse', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'CancelAsFreeStmt', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_;attribute = 'ExtraSysTablePrefixes', value = 'dd_'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_attribute = 'LFConversion', value = '1'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_attribute = 'UpdatableCursors', value = '1'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_attribute = 'DisallowPremature', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_attribute = 'TrueIsMinus1', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_attribute = 'BI', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_attribute = 'ByteaAsLongVarBinary', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_attribute = 'UseServerSidePrepare', value = '0'
CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=16280;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;
C0=0;C1=0;C2=dd_CC_connect: entering...
CC_connect(): DSN = '', server = '192.168.123.121', port = '5432', sslmode =
'prefer' database = 'wazagua', username = 'postgres', password='xxxxx'

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information.  Any unauthorized review,
use, disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.




-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Dave Page
Sent: Wednesday, August 31, 2005 3:34 PM
To: jfradkin@wazagua.com; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] figuring out why I am having this issue


Joel,

The problem is not that we won't help, but mainly I suspect we're in
timezones some way east of you. For example, I'm watching telly, eating a
popadom, and thinking about having a beer and going to bed!! (I'm also on my
pda, and don't have the source right now).

A hint though - look in the connectionstring in mylog, and find the actual
option name/code. Then, look in options.c (iirc), and see if you can figure
out the variable that the value gets assigned to in the ConnectionClass
object. Then, look at where that is used. The problem is /probably/ in
qresult.c, connection.c (not the #ifndef USE_LIBPQ bits), or, if you're
really unlucky, copy_and_convert_field in convert.c

Good luck, and be sure to let someone know what you're doing so they can
send dogs when you don't come back...

/D

-----Original Message-----
From: "Joel Fradkin"<jfradkin@wazagua.com>
Sent: 31/08/05 20:07:46
To: "pgsql-odbc@postgresql.org"<pgsql-odbc@postgresql.org>
Subject: [ODBC] figuring out why I am having this issue

I do not mind researching the text field problem myself, but looking at the
source code I have no idea where to look or how to approach this.

I have seen a few email where some of the developers talked about how they
were getting feed back, but to be honest never paid much attention.

I can look in the archive (and probably will), but if any of you who has
worked on the code could maybe point me in the right direction like which .c
file would be looking at

MaxLongVarcharSize I did a search and only saw it referenced in one file and
it does not look to me like it is doing anything with text fields, so I must
be missing something.



Any ideas would be a big help.



Joel Fradkin








-----Unmodified Original Message-----
I do not mind researching the text field problem myself, but looking at the
source code I have no idea where to look or how to approach this.

I have seen a few email where some of the developers talked about how they
were getting feed back, but to be honest never paid much attention.

I can look in the archive (and probably will), but if any of you who has
worked on the code could maybe point me in the right direction like which .c
file would be looking at

MaxLongVarcharSize I did a search and only saw it referenced in one file and
it does not look to me like it is doing anything with text fields, so I must
be missing something.



Any ideas would be a big help.



Joel Fradkin






---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org