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

Errors using psqlodbc

From: Nelson Andre <nelson(dot)andre(at)maeil(dot)pt>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Errors using psqlodbc
Date: 2010-11-02 16:46:46
Message-ID: 6B48F83ECA0ABA4F9E360E8E0A1CDFFC35E4AE0E@HALLEY.maeil.pt (view raw or flat)
Thread:
Lists: pgsql-odbc
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?

Os melhores cumprimentos,
Nelson André
Senior Software Engineer
Maeil Consultores - Tecnologias de Integração de Empresas, Lda.
http://www.maeil.pt<http://www.maeil.pt/>    http://helpdesk.maeil.pt<http://helpdesk.maeil.pt/>



AVISO DE CONFIDENCIALIDADE
Esta mensagem de correio electrónico e qualquer dos seus ficheiros anexos, caso existam, são confidenciais e destinados apenas à(s) pessoa(s) ou entidade(s) acima referida(s), podendo conter informação confidencial, privilegiada, a qual não deverá ser divulgada, copiada, gravada ou distribuída nos termos da lei vigente. Se não é o destinatário da mensagem, ou se ela lhe foi enviada por engano, agradecemos que não faça uso ou divulgação da mesma. A distribuição ou utilização da informação nela contida é VEDADA. Se recebeu esta mensagem por engano, por favor avise-nos de imediato, por correio electrónico, para o endereço acima e apague este e-mail do seu sistema. Obrigado.
CONFIDENTIALITY NOTICE
This e-mail transmission and eventual attached files are intended only for the use of the individual or entity named above and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in this transmission is strictly VOIDED. If you have received this transmission in error, please immediately notify us by e-mail at the above address and delete this e-mail from your system. Thank you.

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2010-11-02 23:19:27
Subject: Re: Errors using psqlodbc
Previous:From: Nelson AndreDate: 2010-11-02 12:16:03
Subject: Errors using odbc driver

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