SEO

I am trying to connect to postgresql with crystal reports using psqlodbc. However, the
parameterized query that i am passing takes about 20-30 seconds to return 60 records. I expect
that I have mis-configured the obdc driver somehow, but I am not sure what it would be.

here is the errors that I am seeing in mylog_1036.log

[3764]STATEMENT WARNING: func=PGAPI_GetData, desc='', errnum=-2, errmsg='The buffer was too small
for the GetData.'
[3764][SQLGetDiagRecW][3764]PGAPI_GetDiagRec entering type=3 rec=1
[3764]ER_ReturnError: status = -2, msg = #The buffer was too small for the GetData.#
[3764] szSqlState = '01004',len=41, szError='The buffer was too small for the GetData.'




here are the "global options" listing in the psqlodbc_1036.log

Global Options: Version='08.02.0100', fetch=100, socket=4096, unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=1
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
[ PostgreSQL version string = '8.1.4' ]
[ PostgreSQL version number = '8.1' ]
conn=4453b30, query='select oid, typbasetype from pg_type where typname = 'lo''
[ fetched 0 rows ]
[ Large Object oid = -999 ]
[ Client encoding = 'UTF8' (code = 6) ]
conn=4453b30,
PGAPI_DriverConnect(out)='DSN=PostgreSQL30W;DATABA SE=logs;SERVER=db_server01;PORT=5432;UID=root;PWD= xxxxxxxxxx;SSLmode=disable;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;S howSystemTables=0;ConnSettings=;Fetch=100;Socket=4 096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarch arSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;U seDeclareFetch=1;TextAsLongVarchar=1;UnknownsAsLon gVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt= 0;ExtraSysTablePrefixes=dd_;;LFConversion=1;Updata bleCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI =0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;L owerCaseIdentifier=0;XaOpt=1'
conn=4453b30, query='declare "SQL_CUR044596F0" cursor with hold for select * from metalog where
procname = 'su' ;'

Thanks for any help.

Regards,

Richard Broersma Jr.



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Richard Broersma Jr wrote:
> I am trying to connect to postgresql with crystal reports using psqlodbc. However, the
> parameterized query that i am passing takes about 20-30 seconds to return 60 records. I expect
> that I have mis-configured the obdc driver somehow, but I am not sure what it would be.
>
> here is the errors that I am seeing in mylog_1036.log

Could you semd me directly the Mylog output ?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster