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
Re: Erreur when testing connection |
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: