psqlodbc driver issue with Win10 Update 1803
От | BGoebel |
---|---|
Тема | psqlodbc driver issue with Win10 Update 1803 |
Дата | |
Msg-id | 1528123102349-0.post@n3.nabble.com обсуждение исходный текст |
Ответы |
Re: psqlodbc driver issue with Win10 Update 1803
(Clemens Ladisch <clemens@ladisch.de>)
Re: psqlodbc driver issue with Win10 Update 1803 (BGoebel <b.goebel@prisma-computer.de>) |
Список | pgsql-odbc |
After updating their PCs several of our customers have heavy difficulties to connect to their postgresql servers. MyLog is showing that libpq returns 'could not translate host name "SERVER" to address: Unknown server error', see appended log. NB #1: not every updated PC is affected NB #2: after several times (10-50) on some PCs DBDriverConnect is successful NB #3: we never have had this issue since we use postgreSQL (>5 years) Setup: Win10 (Update 1803) 32bit DLL : psqlodbc30a.dll v 9.3.4.0 Server: posgresql 9.4 Error exists too with the brandnew psqldobc 10.3.0.0 Any help will be greatly appreciated regards bG -------------------- myLog [6336-4.817]attribute = 'debug', value = '1' [6336-4.817]copyAttributes: DSN='',server='SERVER',dbase='MyDB',user='postgres',passwd='xxxxx',port='3456',onlyread='',conn_settings='(null)') [6336-4.817]attribute = 'commlog', value = '1' [6336-4.817]copyAttributes: DSN='',server='SERVER',dbase='MyDB',user='postgres',passwd='xxxxx',port='3456',onlyread='',conn_settings='(null)') [6336-4.817]getDSNinfo: DSN= overwrite=0 [6336-4.817]our_connect_string = 'Driver={PostgreSQL};SERVER=SERVER;PORT=3456;DATABASE=MyDB;UID=postgres;PWD=MyDB;UpdatableCursors=1;usedeclarefetch=1;UseServerSidePrepare=1;MaxVarcharSize=4000;debug=1;commlog=1' [6336-4.817]attribute = 'Driver', value = '{PostgreSQL}' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'SERVER', value = 'SERVER' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'PORT', value = '3456' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'DATABASE', value = 'MyDB' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'UID', value = 'postgres' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'PWD', value = 'MyDB' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'UpdatableCursors', value = '1' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'usedeclarefetch', value = '1' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'UseServerSidePrepare', value = '1' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'MaxVarcharSize', value = '4000' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=4000;B1=8190;B2=0;B3=0;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'debug', value = '1' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=4000;B1=8190;B2=1;B3=0;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute = 'commlog', value = '1' [6336-4.817]copyCommonAttributes: A7=100;A9=0;B0=4000;B1=8190;B2=1;B3=1;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.832]calling getDSNdefaults [6336-4.832]CC_connect: entering... [6336-4.832]sslmode=disable [6336-4.832]LIBPQ_CC_connect: entering... [6336-4.832]Driver Version='09.05.0300,Jun 17 2016' linking 1800 dynamic Multithread library [6336-4.832]LIBPQ_CC_connect: DSN = '', server = 'SERVER', port = '3456', database = 'MyDB', username = 'postgres', password='xxxxx' [6336-4.832]connecting to the database using SERVER as the server [6336-4.832]CC_error_statements: self=0122A300 [6336-4.832]CONN ERROR: func=LIBPQ_connect, desc='', errnum=101, errmsg='could not translate host name "SERVER" to address: Unknown server error ' [6336-4.848]Could not establish connection to the database; LIBPQ returned -> could not translate host name "SERVER" to address: Unknown server error [6336-4.848]LIBPQ_connect: retuning 0 [6336-4.848]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum=101, errmsg='could not translate host name "SERVER" to address: Unknown server error ' -- Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html
В списке pgsql-odbc по дате отправления: