my first attempt with ODBC

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 wha=
t it would be.

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

[3764]STATEMENT WARNING: func=3DPGAPI_GetData, desc=3D'', errnum=3D-2, er=
rmsg=3D'The buffer was too small
for the GetData.'
[3764][SQLGetDiagRecW][3764]PGAPI_GetDiagRec entering type=3D3 rec=3D1
[3764]ER_ReturnError: status =3D -2, msg =3D #The buffer was too small fo=
r the GetData.#
[3764] szSqlState =3D '01004',len=3D41, szError=3D'The buffer was to=
o small for the GetData.'




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

Global Options: Version=3D'08.02.0100', fetch=3D100, socket=3D4096, unkno=
wn_sizes=3D0,
max_varchar_size=3D254, max_longvarchar_size=3D8190
disable_optimizer=3D1, ksqo=3D1, unique_index=3D1, use_de=
clarefetch=3D1
text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, boo=
ls_as_char=3D1 NAMEDATALEN=3D64
extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=
_encoding=3D'OTHER'
[ PostgreSQL version string =3D '8.1.4' ]
[ PostgreSQL version number =3D '8.1' ]
conn=3D4453b30, query=3D'select oid, typbasetype from pg_type where typna=
me =3D 'lo''
[ fetched 0 rows ]
[ Large Object oid =3D -999 ]
[ Client encoding =3D 'UTF8' (code =3D 6) ]
conn=3D4453b30,
PGAPI_DriverConnect(out)=3D'DSN=3DPostgreSQL30W;DATABASE=3Dl ogs;SERVER=3D=
db_server01;PORT=3D5432;UID=3Droot;PWD=3Dxxxxxxxxxx;SSLmode= 3Ddisable;Rea=
dOnly=3D0;Protocol=3D7.4-1;FakeOidIndex=3D0;ShowOidColumn=3D 0;RowVersioni=
ng=3D0;ShowSystemTables=3D0;ConnSettings=3D;Fetch=3D100;Sock et=3D4096;Unk=
nownSizes=3D0;MaxVarcharSize=3D254;MaxLongVarcharSize=3D8190 ;Debug=3D1;Co=
mmLog=3D1;Optimizer=3D1;Ksqo=3D1;UseDeclareFetch=3D1;TextAsL ongVarchar=3D=
1;UnknownsAsLongVarchar=3D0;BoolsAsChar=3D1;Parse=3D0;Cancel AsFreeStmt=3D=
0;ExtraSysTablePrefixes=3Ddd_;;LFConversion=3D1;UpdatableCur sors=3D1;Disa=
llowPremature=3D0;TrueIsMinus1=3D0;BI=3D0;ByteaAsLongVarBina ry=3D0;UseSer=
verSidePrepare=3D0;LowerCaseIdentifier=3D0;XaOpt=3D1'
conn=3D4453b30, query=3D'declare "SQL_CUR044596F0" cursor with hold for s=
elect * from metalog where
procname =3D 'su' ;'

Thanks for any help.

Regards,

Richard Broersma Jr.



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

Re: my first attempt with ODBC

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