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 по дате отправления:

Предыдущее
От: "Tobias Wendorff"
Дата:
Сообщение: Re: NUMERIC type makes trouble in MS Access
Следующее
От: Clemens Ladisch
Дата:
Сообщение: Re: psqlodbc driver issue with Win10 Update 1803