Problem with NT 4.0 / driver 08.01.0102
Problem with NT 4.0 / driver 08.01.0102
am 23.01.2006 13:54:03 von Philippe Lang
This is a multi-part message in MIME format.
------=_NextPart_000_0118_01C62024.77FFC480
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
I get an error under Windows NT 4.0, and driver version 08.01.0102.
Here it is:
CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption=30002', errnum=205,
errmsg='Unknown connect option (Get)'
------------------------------------------------------------
henv=169348848, conn=151350640, status=0, num_stmts=16 conn=151350640,
PGAPI_DriverConnect( in)='DSN=testdb;UID=aaaa;PWD=;APP=Microsoft
Access;DATABASE=testdb;TABLE=adresses;', fDriverCompletion=1 DSN info:
DSN='testdb',server='172.17.0.4',port='',dbase='testdb',user ='aaaa',passwd='
xxxxx'
onlyread='',protocol='',showoid='',fakeoidindex='',showsysta ble=''
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
Global Options: Version='08.01.0102', fetch=100, socket=0,
unknown_sizes=254, max_varchar_size=8190, max_longvarchar_size=20250962
disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=113, errmsg='could not translate host name "172.17.0.4" to address:
Unknown host '
------------------------------------------------------------
henv=169348848, conn=151350640, status=0, num_stmts=16
No problem of this type arise with both Windows 2000 and XP.
And the old 7.030.208 version does not have this problem. It runs fine under
NT.
Philippe Lang
Attik System
------=_NextPart_000_0118_01C62024.77FFC480
Content-Type: application/x-pkcs7-signature;
name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="smime.p7s"
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIII/zCCAocw
ggHwoAMCAQICEFpaIYarXomyBeuKGjRG04swDQYJKoZIhvcNAQEEBQAwYjEL MAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNV BAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA1MTIyMDEzNDAyNloX DTA2MTIyMDEzNDAy
NlowZzENMAsGA1UEBBMETGFuZzERMA8GA1UEKhMIUGhpbGlwcGUxFjAUBgNV BAMTDVBoaWxpcHBl
IExhbmcxKzApBgkqhkiG9w0BCQEWHHBoaWxpcHBlLmxhbmdAYXR0aWtzeXN0 ZW0uY2gwgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBAJsLuUD6Q3LdQfy6UKzYyhLAyhzocE3L j7oaJLBvFQk0rQHf
j14K6A39OW5pBil2aw/B93JalSJVkasS3FsjAFs1LvQS8xY0mgB2CtthT3Fa jV0bB424LQdZ2KhG
tHbPEm/68S0ARXlTZaD4I5ixwFX+Zaa0uuPFhWfZems0B7nBAgMBAAGjOTA3 MCcGA1UdEQQgMB6B
HHBoaWxpcHBlLmxhbmdAYXR0aWtzeXN0ZW0uY2gwDAYDVR0TAQH/BAIwADAN BgkqhkiG9w0BAQQF
AAOBgQA3w0be0GoD+dBCQ0JuV0l2gpBC8KcKaym1zGiRLn7C1ojGuXsw/TSh xor7f63H3CUZq+aL
zdLtUpFm4a/LdO/1GLKs4ZJSY1WKzeNHiyXGjnkvuzKjRwzVA94McLeBpg8f DocaH3Z0Go9dg/f6
d0sMTmKAxRDYMeNtWjUuAGod+DCCAy0wggKWoAMCAQICAQAwDQYJKoZIhvcN AQEEBQAwgdExCzAJ
BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNh cGUgVG93bjEaMBgG
A1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRp b24gU2VydmljZXMg
RGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBD QTErMCkGCSqGSIb3
DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw05NjAxMDEw MDAwMDBaFw0yMDEy
MzEyMzU5NTlaMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBD YXBlMRIwEAYDVQQH
EwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYD VQQLEx9DZXJ0aWZp
Y2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1h
aWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0 ZS5jb20wgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBANRp19SwlGRbcelH2AxRtupykbCEXn0t DY97Et+FJXUodDpC
LGMnn5V7S+9+GYcdhuqj3bnOlmQawhRuRKx85o/oTQ9xH0A4pgCjh3j2+ZSG Xq3qwF5269kUo11u
enwMpUtVfwYZKX+emibVars4JAhqmMex2qOYkf152+VaxBy5AgMBAAGjEzAR MA8GA1UdEwEB/wQF
MAMBAf8wDQYJKoZIhvcNAQEEBQADgYEAx+ySfk749ZalZ2IqpPBNEWDQb41g WGGsJrtSNVwIzzD7
qEqWih9iQiOMFw/0umScF6xHKd+dmF7SbGBxXKKs3Hnj524ARx+1DSjoAp3k mv0T9KbZfLH43F8j
JgmRgHPQFBveQ6mDJfLmnC8Vyv6mq4oHdYsM3VGEa+T40c53ooEwggM/MIIC qKADAgECAgENMA0G
CSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVy biBDYXBlMRIwEAYD
VQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgw JgYDVQQLEx9DZXJ0
aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUg UGVyc29uYWwgRnJl
ZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcN
MDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSm PFVzVftOucqZWh5o
wHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnw K4Vaqj9xVsuvPAsH
5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e2 0TxhBEAeZBlyYLf7
AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDig NqA0hjJodHRwOi8v
Y3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDAL BgNVHQ8EBAMCAQYw
KQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0G CSqGSIb3DQEBBQUA
A4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQc UCCTcDz9reFhYsPZ
Ohl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u 9uo05RAaWzVNd+NW
IXiC3CEZNd4ksdMdRv9dX2VPMYIC+DCCAvQCAQEwdjBiMQswCQYDVQQGEwJa QTElMCMGA1UEChMc
VGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3Rl IFBlcnNvbmFsIEZy
ZWVtYWlsIElzc3VpbmcgQ0ECEFpaIYarXomyBeuKGjRG04swCQYFKw4DAhoF AKCCAdgwGAYJKoZI
hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDYwMTIzMTI1 NDAzWjAjBgkqhkiG
9w0BCQQxFgQUFhmNDdlOSUMCYwVTfklI7xvb/RAwZwYJKoZIhvcNAQkPMVow WDAKBggqhkiG9w0D
BzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYI KoZIhvcNAwICASgw
BwYFKw4DAhowCgYIKoZIhvcNAgUwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkG A1UEBhMCWkExJTAj
BgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJz
b25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBaWiGGq16JsgXriho0RtOLMIGH BgsqhkiG9w0BCRAC
CzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0 aW5nIChQdHkpIEx0
ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5n IENBAhBaWiGGq16J
sgXriho0RtOLMA0GCSqGSIb3DQEBAQUABIGAclmwJtqGLqhyfRH0CNJrd36B z0WwzJq+tONYpuHm
GmVad3OPMD2pI5Y34JVEY8ZeJUuUP+qSZRJE0z1rmaRwMwataYYi8xIQo6Qc IjjzKPOhXUGqlBa2
K8B+nXeXlFdUSPL12YQzV5EQg1Bv5fHKaWSB/9QVqlcJ9SPtb5PU4H4AAAAA AAA=
------=_NextPart_000_0118_01C62024.77FFC480--
Re: Problem with NT 4.0 / driver 08.01.0102
am 23.01.2006 14:46:53 von Ludek Finstrle
> CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption=30002', errnum=205,
> errmsg='Unknown connect option (Get)'
I think the real problem is described later.
> CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
> errnum=113, errmsg='could not translate host name "172.17.0.4" to address:
> Unknown host '
I don't know why but it can't get IP address. It means that 172.17.0.4
is name not IP. Could you check DNS server or lmhosts file?
Do you have correct route table on the host? Could you ping/reach
172.17.0.4 host?
> No problem of this type arise with both Windows 2000 and XP.
> And the old 7.030.208 version does not have this problem. It runs fine
> under NT.
It run in same situation (same host, same app, ...)? The newer driver
is using libpq to connect to server. So it could be the problem. I have
no WinNT 4.0 box here.
BTW maybe mylog output could be mo0re helpful.
Regards,
Luf
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Re: Problem with NT 4.0 / driver 08.01.0102
am 23.01.2006 16:34:44 von Philippe Lang
This is a multi-part message in MIME format.
------=_NextPart_000_0135_01C6203A.EA940900
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I guess the problem comes from libpq, because on this exact same =
computer, a
simple switch from psqlodbc 7.030.208 to 08.01.0102 and the problem =
arises.
172.17.0.4 is accessible and used by many people, no problem on the =
server
side.
Is libpq maybe incompatible with Windows NT 4.0? Or may a bug with name
resolution under NT 4.0?
Here is the mylog output:
[158]Could not establish connection to the database; LIBPQ returned -> =
could
not translate host name "172.17.0.4" to address: Unknown host
=20
[158]CONN ERROR: func=3DPGAPI_DriverConnect, desc=3D'Error from =
CC_Connect',
errnum=3D113, errmsg=3D'could not translate host name "172.17.0.4" to =
address:
Unknown host
'
[158][[SQLGetDiagRec]]
[158]PGAPI_GetDiagRec entering rec=3D1[158]**** PGAPI_ConnectError:
hdbc=3D151350640 <0>
[158]enter CC_get_error
[158]enter CC_create_errormsg
[158]msg =3D 'could not translate host name "172.17.0.4" to address: =
Unknown
host
'
[158]exit CC_create_errormsg
[158]exit CC_get_error
[158]CC_get_error: status =3D 113, msg =3D #could not translate host =
name
"172.17.0.4" to address: Unknown host
#
[158] szSqlState =3D 'S1000',len=3D68, szError=3D'(null)'
[158]PGAPI_GetDiagRec exiting 1
[158][[SQLGetDiagRec]]
[158]PGAPI_GetDiagRec entering rec=3D1[158]**** PGAPI_ConnectError:
hdbc=3D151350640 <70>
[158]enter CC_get_error
[158]exit CC_get_error
[158]CC_get_error: status =3D 113, msg =3D #could not translate host =
name
"172.17.0.4" to address: Unknown host
#
[158] szSqlState =3D 'S1000',len=3D68, szError=3D'could not =
translate host
name "172.17.0.4" to address: Unknown host
'
[158]PGAPI_GetDiagRec exiting 0
[158][[SQLGetDiagField]] Handle=3D(2,9056d70) Rec=3D1 Id=3D8
[158]PGAPI_GetDiagField entering rec=3D1[158]PGAPI_GetDiagField exiting =
0
[158][[SQLGetDiagField]] Handle=3D(2,9056d70) Rec=3D1 Id=3D9
[158]PGAPI_GetDiagField entering rec=3D1[158]PGAPI_GetDiagField exiting =
0
[158][[SQLGetDiagField]] Handle=3D(2,9056d70) Rec=3D1 Id=3D10
[158]PGAPI_GetDiagField entering rec=3D1[158]PGAPI_GetDiagField exiting =
0
[158][[SQLGetDiagField]] Handle=3D(2,9056d70) Rec=3D1 Id=3D11
[158]PGAPI_GetDiagField entering rec=3D1[158]PGAPI_GetDiagField exiting =
0
[158][[SQLGetDiagRec]]
[158]PGAPI_GetDiagRec entering rec=3D2[158]**** PGAPI_ConnectError:
hdbc=3D151350640 <0>
[158]PGAPI_GetDiagRec exiting 100
[158][[SQLFreeHandle]][158]PGAPI_FreeConnect: entering...
[158]**** in PGAPI_FreeConnect: hdbc=3D151350640
[158]enter CC_Destructor, self=3D151350640
[158]in CC_Cleanup, self=3D151350640
[158]after LIBPQ destructor
[158]exit CC_Cleanup
[158]after CC_Cleanup
[158]after free statement holders
[158]exit CC_Destructor
[158]PGAPI_FreeConnect: returning...
[158][[SQLFreeHandle]][158]**** in PGAPI_FreeEnv: env =3D 169348848 **=20
[158]in EN_Destructor, self=3D169348848
[158]exit EN_Destructor: rv =3D 1
[158] ok=20
-----Message d'origine-----
De : Ludek Finstrle [mailto:luf@pzkagis.cz]=20
Envoy=E9 : lundi, 23. janvier 2006 14:47
=C0 : Philippe Lang
Cc : pgsql-odbc@postgresql.org
Objet : Re: [ODBC] Problem with NT 4.0 / driver 08.01.0102
> CONN ERROR: func=3DPGAPI_GetConnectOption, desc=3D'fOption=3D30002',=20
> errnum=3D205, errmsg=3D'Unknown connect option (Get)'
I think the real problem is described later.
> CONN ERROR: func=3DPGAPI_DriverConnect, desc=3D'Error from =
CC_Connect',=20
> errnum=3D113, errmsg=3D'could not translate host name "172.17.0.4" to =
address:
> Unknown host '
I don't know why but it can't get IP address. It means that 172.17.0.4 =
is
name not IP. Could you check DNS server or lmhosts file?
Do you have correct route table on the host? Could you ping/reach
172.17.0.4 host?
> No problem of this type arise with both Windows 2000 and XP.
> And the old 7.030.208 version does not have this problem. It runs fine =
> under NT.
It run in same situation (same host, same app, ...)? The newer driver is
using libpq to connect to server. So it could be the problem. I have no
WinNT 4.0 box here.
BTW maybe mylog output could be mo0re helpful.
Regards,
Luf
------=_NextPart_000_0135_01C6203A.EA940900
Content-Type: application/x-pkcs7-signature;
name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="smime.p7s"
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIII/zCCAocw
ggHwoAMCAQICEFpaIYarXomyBeuKGjRG04swDQYJKoZIhvcNAQEEBQAwYjEL MAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNV BAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA1MTIyMDEzNDAyNloX DTA2MTIyMDEzNDAy
NlowZzENMAsGA1UEBBMETGFuZzERMA8GA1UEKhMIUGhpbGlwcGUxFjAUBgNV BAMTDVBoaWxpcHBl
IExhbmcxKzApBgkqhkiG9w0BCQEWHHBoaWxpcHBlLmxhbmdAYXR0aWtzeXN0 ZW0uY2gwgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBAJsLuUD6Q3LdQfy6UKzYyhLAyhzocE3L j7oaJLBvFQk0rQHf
j14K6A39OW5pBil2aw/B93JalSJVkasS3FsjAFs1LvQS8xY0mgB2CtthT3Fa jV0bB424LQdZ2KhG
tHbPEm/68S0ARXlTZaD4I5ixwFX+Zaa0uuPFhWfZems0B7nBAgMBAAGjOTA3 MCcGA1UdEQQgMB6B
HHBoaWxpcHBlLmxhbmdAYXR0aWtzeXN0ZW0uY2gwDAYDVR0TAQH/BAIwADAN BgkqhkiG9w0BAQQF
AAOBgQA3w0be0GoD+dBCQ0JuV0l2gpBC8KcKaym1zGiRLn7C1ojGuXsw/TSh xor7f63H3CUZq+aL
zdLtUpFm4a/LdO/1GLKs4ZJSY1WKzeNHiyXGjnkvuzKjRwzVA94McLeBpg8f DocaH3Z0Go9dg/f6
d0sMTmKAxRDYMeNtWjUuAGod+DCCAy0wggKWoAMCAQICAQAwDQYJKoZIhvcN AQEEBQAwgdExCzAJ
BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNh cGUgVG93bjEaMBgG
A1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRp b24gU2VydmljZXMg
RGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBD QTErMCkGCSqGSIb3
DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw05NjAxMDEw MDAwMDBaFw0yMDEy
MzEyMzU5NTlaMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBD YXBlMRIwEAYDVQQH
EwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYD VQQLEx9DZXJ0aWZp
Y2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1h
aWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0 ZS5jb20wgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBANRp19SwlGRbcelH2AxRtupykbCEXn0t DY97Et+FJXUodDpC
LGMnn5V7S+9+GYcdhuqj3bnOlmQawhRuRKx85o/oTQ9xH0A4pgCjh3j2+ZSG Xq3qwF5269kUo11u
enwMpUtVfwYZKX+emibVars4JAhqmMex2qOYkf152+VaxBy5AgMBAAGjEzAR MA8GA1UdEwEB/wQF
MAMBAf8wDQYJKoZIhvcNAQEEBQADgYEAx+ySfk749ZalZ2IqpPBNEWDQb41g WGGsJrtSNVwIzzD7
qEqWih9iQiOMFw/0umScF6xHKd+dmF7SbGBxXKKs3Hnj524ARx+1DSjoAp3k mv0T9KbZfLH43F8j
JgmRgHPQFBveQ6mDJfLmnC8Vyv6mq4oHdYsM3VGEa+T40c53ooEwggM/MIIC qKADAgECAgENMA0G
CSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVy biBDYXBlMRIwEAYD
VQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgw JgYDVQQLEx9DZXJ0
aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUg UGVyc29uYWwgRnJl
ZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcN
MDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSm PFVzVftOucqZWh5o
wHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnw K4Vaqj9xVsuvPAsH
5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e2 0TxhBEAeZBlyYLf7
AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDig NqA0hjJodHRwOi8v
Y3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDAL BgNVHQ8EBAMCAQYw
KQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0G CSqGSIb3DQEBBQUA
A4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQc UCCTcDz9reFhYsPZ
Ohl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u 9uo05RAaWzVNd+NW
IXiC3CEZNd4ksdMdRv9dX2VPMYIC+DCCAvQCAQEwdjBiMQswCQYDVQQGEwJa QTElMCMGA1UEChMc
VGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3Rl IFBlcnNvbmFsIEZy
ZWVtYWlsIElzc3VpbmcgQ0ECEFpaIYarXomyBeuKGjRG04swCQYFKw4DAhoF AKCCAdgwGAYJKoZI
hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDYwMTIzMTUz NDQ0WjAjBgkqhkiG
9w0BCQQxFgQUNDoQG2yFlNQhdc2cg17/b+nJaiswZwYJKoZIhvcNAQkPMVow WDAKBggqhkiG9w0D
BzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYI KoZIhvcNAwICASgw
BwYFKw4DAhowCgYIKoZIhvcNAgUwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkG A1UEBhMCWkExJTAj
BgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJz
b25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBaWiGGq16JsgXriho0RtOLMIGH BgsqhkiG9w0BCRAC
CzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0 aW5nIChQdHkpIEx0
ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5n IENBAhBaWiGGq16J
sgXriho0RtOLMA0GCSqGSIb3DQEBAQUABIGAhWS4Nk7hXBkhOS2impTPKLRx nKzzAeJbzKsTQrCd
FqNeemvmmxvV1C75cIqhYgRx80CEuyfTV6Gtm1o+e+KsoW2yqZZKtTbqm1RM e+F+tsPYnvRCyMP8
CkgFZ4mtlXK+VGkJHUQdblV2nftWMjwZFjuhLks44OjFafrjcZQtDPcAAAAA AAA=
------=_NextPart_000_0135_01C6203A.EA940900--
Re: Problem with NT 4.0 / driver 08.01.0102
am 23.01.2006 17:14:54 von Ludek Finstrle
> I guess the problem comes from libpq, because on this exact same computer, a
> simple switch from psqlodbc 7.030.208 to 08.01.0102 and the problem arises.
> 172.17.0.4 is accessible and used by many people, no problem on the server
> side.
:-( Bad information.
> Is libpq maybe incompatible with Windows NT 4.0? Or may a bug with name
> resolution under NT 4.0?
I don't know. You have to search the pgsql-interfaces archive. Maybe
try google. Maybe someone else know it.
BTW what about service pack?
I see in psqlODBC that it use only host=xxx - use host name lookups.
I don't know what is problematic in host name lookups in WinNT 4.0.
There is hostaddr=yyy in libpq which doesn't use host name lookups.
So if you could compile psqlODBC yourself I advise you change
lines in function LIBPQ_connect in connection.c:
- conninfo = (char *)malloc((sizeof(char) * strlen(" host=") + strlen(self->connInfo.server) + 1));
+ conninfo = (char *)malloc((sizeof(char) * strlen(" hostaddr=") + strlen(self->connInfo.server) + 1));
- conninfo = strcpy(conninfo," host=");
+ conninfo = strcpy(conninfo," hostaddr=");
(- means original line, + means new line). I don't see trivial patch
for this behaviour yet so I can't create official patch for it.
> Here is the mylog output:
Don't you strip it from begin? Or do you enable mylog output
under Global button? Some informations is missing.
>
> [158]Could not establish connection to the database; LIBPQ returned -> could
> not translate host name "172.17.0.4" to address: Unknown host
>
> [158]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
> errnum=113, errmsg='could not translate host name "172.17.0.4" to address:
> Unknown host
Regards,
Luf
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings