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

Re: Errors using psqlodbc

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Nelson Andre <nelson(dot)andre(at)maeil(dot)pt>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Errors using psqlodbc
Date: 2010-11-02 23:19:27
Message-ID: 4CD09C7F.9070403@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
(2010/11/03 1:46), Nelson Andre wrote:
> Hi there ,
>
> I’m using psqlodbc version 9.00.01.01 UNICODE , in Windows Server 2003.
>
> Have created a new data source and activated the logs.
>
> In the psqlodbc logs I get the following error messages:
>
> [0.002]conn=026B40E0, PGAPI_DriverConnect( in)='DSN=PostgresTeste;',
> fDriverCompletion=1
>
> [0.011]DSN info:
> DSN='PostgresTeste',server='libra',port='5432',dbase='mtransteste',user='minimal',passwd='xxxxx'
>
> [0.021]
> onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0'
>
> [0.028] conn_settings='', conn_encoding='(null)'
>
> [0.032] translation_dll='',translation_option=''
>
> [0.053]Driver Version='09.00.0101,201010160001' linking 1500 static
> Multithread library
>
> [0.074]Global Options: fetch=100, socket=4096, unknown_sizes=0,
> max_varchar_size=255, max_longvarchar_size=8190
>
> [0.099] disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1
>
> [0.106] text_as_longvarchar=1, unknowns_as_longvarchar=0,
> bools_as_char=1 NAMEDATALEN=64
>
> [0.113] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding=''
>
> [0.250] [ PostgreSQL version string = '8.4.4' ]
>
> [0.252] [ PostgreSQL version number = '8.4' ]
>
> [0.316]conn=026B40E0, query='select oid, typbasetype from pg_type where
> typname = 'lo''
>
> [0.377] [ fetched 0 rows ]
>
> [0.417] [ Large Object oid = -999 ]
>
> [0.422] [ Client encoding = 'UTF8' (code = 6) ]
>
> [0.443]conn=026B40E0,
> PGAPI_DriverConnect(out)='DSN=PostgresTeste;DATABASE=mtransteste;SERVER=libra;PORT=5432;UID=minimal;PWD=xxxxxxx;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1c54ebb;A1=7.4-1'
>
> [6.044]CONN ERROR: func=set_statement_option, desc='', errnum=-1,
> errmsg='Requested value changed.'
>
> [6.057] ------------------------------------------------------------
>
> [6.062] henv=026B2150, conn=026B40E0, status=1, num_stmts=16
>
> [6.067] sock=026B2180, stmts=026B2250, lobj_type=-999
>
> [6.071] ---------------- Socket Info -------------------------------
>
> [6.075] socket=612, reverse=0, errornumber=0, errormsg='(NULL)'
>
> [6.080] buffer_in=40594504, buffer_out=40598608
>
> [6.083] buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
>
> [6.090]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=-1,
> errmsg='Requested value changed.'
>
> [6.104] ------------------------------------------------------------
>
> [6.108] henv=026B2150, conn=026B40E0, status=1, num_stmts=16
>
> [6.112] sock=026B2180, stmts=026B2250, lobj_type=-999
>
> [6.115] ---------------- Socket Info -------------------------------
>
> [6.120] socket=612, reverse=0, errornumber=0, errormsg='(NULL)'
>
> [6.125] buffer_in=40594504, buffer_out=40598608
>
> [6.128] buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
>
> [6.160]CONN ERROR: func=set_statement_option, desc='', errnum=-1,
> errmsg='Requested value changed.'
>
> [6.172] ------------------------------------------------------------
>
> [6.177] henv=026B2150, conn=026B40E0, status=1, num_stmts=16
>
> [6.181] sock=026B2180, stmts=026B2250, lobj_type=-999
>
> [6.186] ---------------- Socket Info -------------------------------
>
> [6.191] socket=612, reverse=0, errornumber=0, errormsg='(NULL)'
>
> [6.195] buffer_in=40594504, buffer_out=40598608
>
> [6.199] buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
>
> [6.207]CONN ERROR: func=PGAPI_SetConnectOption, desc='', errnum=-1,
> errmsg='Requested value changed.'
>
> [6.218] ------------------------------------------------------------
>
> [6.222] henv=026B2150, conn=026B40E0, status=1, num_stmts=16
>
> [6.226] sock=026B2180, stmts=026B2250, lobj_type=-999
>
> [6.232] ---------------- Socket Info -------------------------------
>
> [6.237] socket=612, reverse=0, errornumber=0, errormsg='(NULL)'
>
> [6.242] buffer_in=40594504, buffer_out=40598608
>
> [6.246] buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
>
> I get those 4 CONN ERROR and can’t find anything related to them
>
> Any help?

Those messages are warnings not errors.

regards,
Hiroshi Inoue


In response to

Responses

pgsql-odbc by date

Next:From: Adrien de CroyDate: 2010-11-03 03:22:44
Subject: Various errors in psqlodbc: SQLGetTypeInfo, SQLTables, bigint, and double vs float
Previous:From: Nelson AndreDate: 2010-11-02 16:46:46
Subject: Errors using psqlodbc

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