From: | Pierre Couderc <pierre(at)couderc(dot)eu> |
---|---|
To: | pgsql-odbc(at)lists(dot)postgresql(dot)org |
Subject: | Erreur when testing connection |
Date: | 2019-01-28 22:57:45 |
Message-ID: | 6571d3d4-a5ba-e467-e212-166698bc94e8@couderc.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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'
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre Couderc | 2019-01-30 07:50:02 | Re: Erreur when testing connection |
Previous Message | Ramesh Rajendran | 2019-01-21 12:14:23 | Re: Help in Exporting PostgreSQL DB to SQL Server |