my first attempt with ODBC
От | Richard Broersma Jr |
---|---|
Тема | my first attempt with ODBC |
Дата | |
Msg-id | 20061021193920.94652.qmail@web31806.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: my first attempt with ODBC
|
Список | pgsql-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 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;DATABASE=logs;SERVER=db_server01;PORT=5432;UID=root;PWD=xxxxxxxxxx;SSLmode=disable;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=1;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=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.
В списке pgsql-odbc по дате отправления: