Skip site navigation (1) Skip section navigation (2)

my first attempt with ODBC

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: my first attempt with ODBC
Date: 2006-10-21 19:39:20
Message-ID: 20061021193920.94652.qmail@web31806.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: 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.



Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2006-10-21 22:56:49
Subject: Re: my first attempt with ODBC
Previous:From: Hiroshi InoueDate: 2006-10-21 03:45:31
Subject: Re: User authentication process

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group