Erreur when testing connection - Mailing list pgsql-odbc

From Pierre Couderc
Subject Erreur when testing connection
Date
Msg-id 6571d3d4-a5ba-e467-e212-166698bc94e8@couderc.eu
Whole thread Raw
Responses Re: Erreur when testing connection  (Pierre Couderc <pierre@couderc.eu>)
Re: Erreur when testing connection  (Clemens Ladisch <clemens@ladisch.de>)
List pgsql-odbc
Hi,

I have a problem on W7 (inside  a qemu/kvm vm) with last ANSI odbc 
driver (psqlodbc_11_00_0000-x86.zip) when trying  to connect to 
postgresql 11 (from buster debian package).

The db has been created but is empty.

I use the test button of psqlodbc_x86 with  odbcad32 (32bits version).

Sometimes the test successes, but most of the time, I get :

(...) could not send startup packet Connection reset by peer.

Thnks for any help

PC



Log here :

[2360-0.000]   mylog.c[logs_on_off]274: mylog_on=1 qlog_on=0
[2360-0.000]    start_logging:Global.debug&commlog=1&0
[2360-0.000]psqlodbc.c[DllMain]130: exe name=odbcad32
[2360-0.000]dlg_specif[CC_conninfo_init]1714: entering opt=2
[2360-0.000]   setup.c[ParseAttributes]618: aszKey='DSN', 
value='TOLfabDatabase'
[2360-0.000]dlg_specif[copyConnAttributes]777: key='DSN' 
value='TOLfabDatabase'
[2360-0.000]dlg_specif[CC_conninfo_init]1714: entering opt=3
[2360-0.000]dlg_specif[getDSNinfo]892: entering DSN=TOLfabDatabase 
driver=&PostgreSQL ANSI
[2360-0.000]dlg_specif[getCiDefaults]786: entering
[2360-0.000]dlg_specif[getDSNinfo]913: drivername=PostgreSQL ANSI
[2360-0.000]dlg_specif[getDriversDefaults]867: 003DAFA4 of the driver 
PostgreSQL ANSI
[2360-0.000]dlg_specif[get_Ci_Drivers]1430: comval=003DAFA4 
comval->extra_systable_prefixes = ''
[2360-0.000]dlg_specif[getDSNinfo]1064: force_abbrev=0 bde=0 cvt_null_date=0
[2360-0.000]dlg_specif[get_Ci_Drivers]1346: setting ODBC.INI position of 
TOLfabDatabase(003DAFA4)
[2360-0.000]dlg_specif[get_Ci_Drivers]1430: comval=003DAFA4 
comval->extra_systable_prefixes = ''
[2360-0.000]   setup.c[ParseAttributes]618: aszKey='DSN', 
value='TOLfabDatabase'
[2360-0.000]dlg_specif[copyConnAttributes]777: key='DSN' 
value='TOLfabDatabase'
[2360-3.198]dlg_specif[makeConnectString]295: makeConnectString 
row_versioning=0
[2360-3.198]   setup.c[test_connection]476: 
conn_string=DRIVER=PostgreSQL 

ANSI;DATABASE=tolfabdatabase;SERVER=192.168.163.65;PORT=;UID=;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;D6=-101;XaOpt=1
[2360-3.198]odbcapi30.[SQLAllocHandle]40: Entering
[2360-3.198] environ.c[PGAPI_AllocEnv]69: entering
[2360-3.198] environ.c[PGAPI_AllocEnv]88: leaving phenv=003C97A8
[2360-3.198]odbcapi30.[SQLSetEnvAttr]477: Entering att=200,3
[2360-3.198]odbcapi30.[SQLAllocHandle]40: Entering
[2360-3.198]connection[PGAPI_AllocConnect]87: entering...
[2360-3.198]connection[PGAPI_AllocConnect]90: **** henv = 003C97A8, conn 
= 003D36E8
[2360-3.198] environ.c[EN_add_connection]589: entering self = 003C97A8, 
conn = 003D36E8
[2360-3.198] environ.c[EN_add_connection]613:        added at 0, 
conn->henv = 003C97A8, conns[0]->henv = 003C97A8
[2360-3.198] odbcapi.c[SQLDriverConnect]209: Entering
[2360-3.198] drvconn.c[PGAPI_DriverConnect]119: entering...
[2360-3.198] drvconn.c[PGAPI_DriverConnect]130: **** 
fDriverCompletion=0, connStrIn='DRIVER=PostgreSQL 

ANSI;DATABASE=tolfabdatabase;SERVER=192.168.163.65;PORT=;UID=;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;D6=-101;XaOpt=1'
[2360-3.198]dlg_specif[CC_conninfo_init]1714: entering opt=2
[2360-3.198] drvconn.c[dconn_get_attributes]467: our_connect_string = 
'DRIVER=PostgreSQL 

ANSI;DATABASE=tolfabdatabase;SERVER=192.168.163.65;PORT=;UID=;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;D6=-101;XaOpt=1'
[2360-3.198]dlg_specif[getDSNinfo]892: entering DSN= driver=PostgreSQL 
ANSI&(null)
[2360-3.198]dlg_specif[getCiDefaults]786: entering
[2360-3.198]dlg_specif[getDSNinfo]913: drivername=PostgreSQL ANSI
[2360-3.198]dlg_specif[getDriversDefaults]867: 003D3EFC of the driver 
PostgreSQL ANSI
[2360-3.198]dlg_specif[get_Ci_Drivers]1430: comval=003D3EFC 
comval->extra_systable_prefixes = ''
[2360-3.198] drvconn.c[dconn_get_attributes]467: our_connect_string = 
'DRIVER=PostgreSQL 

ANSI;DATABASE=tolfabdatabase;SERVER=192.168.163.65;PORT=;UID=;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;D6=-101;XaOpt=1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='DRIVER' 
value='PostgreSQL ANSI'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='DATABASE' 
value='tolfabdatabase'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='SERVER' 
value='192.168.163.65'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='PORT' value=''
[2360-3.198]dlg_specif[copyConnAttributes]777: key='UID' value=''
[2360-3.198]dlg_specif[copyConnAttributes]606: key='PWD' value='xxxxxxxx'
[2360-3.198]dlg_specif[copyConnAttributes]709: key='SSLmode' 
value='disable' set to 'disable'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='ReadOnly' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='Protocol' value='7.4'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='FakeOidIndex' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='ShowOidColumn' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='RowVersioning' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='ShowSystemTables' 
value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='Fetch' value='100'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='UnknownSizes' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='MaxVarcharSize' 
value='255'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='MaxLongVarcharSize' 
value='8190'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='Debug' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='CommLog' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='UseDeclareFetch' 
value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='TextAsLongVarchar' 
value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: 
key='UnknownsAsLongVarchar' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='BoolsAsChar' value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='Parse' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: 
key='ExtraSysTablePrefixes' value=''
[2360-3.198]dlg_specif[copyConnAttributes]777: key='LFConversion' value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='UpdatableCursors' 
value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='TrueIsMinus1' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='BI' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: 
key='ByteaAsLongVarBinary' value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: 
key='UseServerSidePrepare' value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='LowerCaseIdentifier' 
value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='D6' value='-101'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='XaOpt' value='1'



pgsql-odbc by date:

Previous
From: Ramesh Rajendran
Date:
Subject: Re: Help in Exporting PostgreSQL DB to SQL Server
Next
From: Pierre Couderc
Date:
Subject: Re: Erreur when testing connection