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: (view raw, whole thread or download thread mbox)
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, query='declare "SQL_CUR044596F0" cursor with hold for select * from metalog where
procname = 'su' ;'

Thanks for any help.


Richard Broersma Jr.


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-2017 The PostgreSQL Global Development Group