Обсуждение: psqlodbc driver issue with Win10 Update 1803

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

BGoebel wrote:
> 'could not translate host name "SERVER" to address: Unknown server error'

Does "nslookup SERVER" executed on the command line work?


Regards,
Clemens

Am 04.06.2018 um 20:05 schrieb Clemens Ladisch:

> BGoebel wrote:
>> 'could not translate host name "SERVER" to address: Unknown server error'
>
> Does "nslookup SERVER" executed on the command line work?
>

You should replace SERVER with a real domain name like yourserver.domain.de

Example:

My server name is yedi.behrens.de and thus

nslookup yedi.behrens.de should be looking up that server correctly. If not, the DNS configuration
is missing an entry.

Regards,

Lothar

>
> Regards,
> Clemens
>
>

Clemens Ladisch wrote
> BGoebel wrote:
>> 'could not translate host name "SERVER" to address: Unknown server error'
> 
> Does "nslookup SERVER" executed on the command line work?
> 
> 
> Regards,
> Clemens

Yes, nslookup works.

Regards
BGoebel



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html

...as a workaround, we lookup for the ip address via getHostbyName and using
the ip address in connection string for the SERVER param instead of the
domain name.

Regards
BGoebel



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html