Can not select SSL mode using OpenOffice Base/Windows

This is a cryptographically signed message in MIME format.

--------------ms000907080504040604060905
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I'm new to this whole ODBC. I want to access a postgres db from a windows xp
client. The server only permits SSL connections (authentication is done via
passwords)...

Therefore I installed OpenOffice 3.1.1 + psqlodbc_08_04_0100. I can configure
unencrypted (non-ssl) ODBC connections using the wizard without any problems.
However in the psqlodbc setup window, the only available option for 'SSL Mode'
is disabled'. Therefore I can not connect using SSL.

The bin directory contains ssleay32.dll therefore I assume that the binaries I
have do work with SSL.

How can I get the other SSL Mode options in that wizard?
fs


--------------ms000907080504040604060905
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJQTCC
AvswggJkoAMCAQICEEnrATC1CFbwLqJ10UHay4QwDQYJKoZIhvcNAQEFBQAw YjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4x LDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDEy NjA2MjQyM1oX
DTEwMDEyNjA2MjQyM1owXzEQMA4GA1UEBBMHU2Nod2FyejEOMAwGA1UEKhMF RmVsaXgxFjAU
BgNVBAMTDUZlbGl4IFNjaHdhcnoxIzAhBgkqhkiG9w0BCQEWFGZlbGl4LnNj aHdhcnpAd2Vi
LmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0Zb4SIt2hm9z glJZhtyJhQ8G
AUqmP3f/rQ9DP84smrrP7Wx7YPhn46iAcr00WX3QgYPp2JlL4fATquKRMPOW 8cSRhKWgIGwz
6AmBFSxo39FuW0ZsfrDTBFL7FS4+lXMEcLPgx/XUjJ1ap8K776dDFW6ox4FB 4tuLmPvR4bCQ
zZXecnbTJssdSt8H1yBoChhrG1YII3b/Z/3bswGpLCJ0/p8dkmrqe2JjCs2Q Azb54JklyY+b
DWg2c9LI7W5uRMgOEzyuG6YrFJV7lf50pvPR9fui5vNdvzY8IEM9+T1uWYbg FdUDK9IAJ/pX
/pMUdyHaXwKeG7gjgsQSJQ5iQHZnEwIDAQABozEwLzAfBgNVHREEGDAWgRRm ZWxpeC5zY2h3
YXJ6QHdlYi5kZTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAAcb sS0VZqGB4v2F
l5pQPGu6f+fRABzlDlNC73uAAlZMZR8M4wPz/cAN1M03RXUJyT2ErFXN6Ng2 puo4EnZQJp0U
gDusvPI5twAP1mrXwxoQlpzdxPY2vxcigYnmPpyY1aj9gfFu7ZR4JUjuSU0c NLGZxZFGBoyP
p8si2VBooQ6TMIIC+zCCAmSgAwIBAgIQSesBMLUIVvAuonXRQdrLhDANBgkq hkiG9w0BAQUF
ADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRk
LjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vpbmcg Q0EwHhcNMDkw
MTI2MDYyNDIzWhcNMTAwMTI2MDYyNDIzWjBfMRAwDgYDVQQEEwdTY2h3YXJ6 MQ4wDAYDVQQq
EwVGZWxpeDEWMBQGA1UEAxMNRmVsaXggU2Nod2FyejEjMCEGCSqGSIb3DQEJ ARYUZmVsaXgu
c2Nod2FyekB3ZWIuZGUwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB AQDRlvhIi3aG
b3OCUlmG3ImFDwYBSqY/d/+tD0M/ziyaus/tbHtg+GfjqIByvTRZfdCBg+nY mUvh8BOq4pEw
85bxxJGEpaAgbDPoCYEVLGjf0W5bRmx+sNMEUvsVLj6VcwRws+DH9dSMnVqn wrvvp0MVbqjH
gUHi24uY+9HhsJDNld5ydtMmyx1K3wfXIGgKGGsbVggjdv9n/duzAaksInT+ nx2Saup7YmMK
zZADNvngmSXJj5sNaDZz0sjtbm5EyA4TPK4bpisUlXuV/nSm89H1+6Lm812/ NjwgQz35PW5Z
huAV1QMr0gAn+lf+kxR3IdpfAp4buCOCxBIlDmJAdmcTAgMBAAGjMTAvMB8G A1UdEQQYMBaB
FGZlbGl4LnNjaHdhcnpAd2ViLmRlMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcN AQEFBQADgYEA
BxuxLRVmoYHi/YWXmlA8a7p/59EAHOUOU0Lve4ACVkxlHwzjA/P9wA3UzTdF dQnJPYSsVc3o
2Dam6jgSdlAmnRSAO6y88jm3AA/WatfDGhCWnN3E9ja/FyKBieY+nJjVqP2B 8W7tlHglSO5J
TRw0sZnFkUYGjI+nyyLZUGihDpMwggM/MIICqKADAgECAgENMA0GCSqGSIb3 DQEBBQUAMIHR
MQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQH EwlDYXBlIFRv
d24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0 aWZpY2F0aW9u
IFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwg RnJlZW1haWwg
Q0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5j b20wHhcNMDMw
NzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMG A1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZy
ZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGB AMSmPFVzVftO
ucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJ FXCO3cnwK4Va
qj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHF KlSFD0gEf6e2
0TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBD BgNVHR8EPDA6
MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxG cmVlbWFpbENB
LmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVBy aXZhdGVMYWJl
bDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7C F6FDlpSdf0wh
uPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sn cVcljd2pnDmO
jCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VP MYIDcTCCA20C
AQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRp bmcgKFB0eSkg
THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vp bmcgQ0ECEEnr
ATC1CFbwLqJ10UHay4QwCQYFKw4DAhoFAKCCAdAwGAYJKoZIhvcNAQkDMQsG CSqGSIb3DQEH
ATAcBgkqhkiG9w0BCQUxDxcNMDkwOTE5MTMzMDE5WjAjBgkqhkiG9w0BCQQx FgQU4wuhGYZ/
fBrrPfVLE+bzuJzcKfIwXwYJKoZIhvcNAQkPMVIwUDALBglghkgBZQMEAQIw CgYIKoZIhvcN
AwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0G CCqGSIb3DQMC
AgEoMIGFBgkrBgEEAYI3EAQxeDB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQK ExxUaGF3dGUg
Q29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29u YWwgRnJlZW1h
aWwgSXNzdWluZyBDQQIQSesBMLUIVvAuonXRQdrLhDCBhwYLKoZIhvcNAQkQ AgsxeKB2MGIx
CzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5 KSBMdGQuMSww
KgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQ SesBMLUIVvAu
onXRQdrLhDANBgkqhkiG9w0BAQEFAASCAQAgQImVDMNMTkWQdwcFA4aGLnh1 UbmOQxSdqor+
oMpC8NiNIQEpKlPOgwzNHlMTUZazFRtdWcqY+3W16ozouxE0wq7xwvPuNp92 v+N32oszIUCE
EaQi8I2ufz/zYzemN+ityzZV1CB/XZ2Nm2wTy8+M0MHzPQnXSZ5MXyOfAi8o MtwycAFero5I
8i7RQaFqd4dljsSkp+gW+gdAPSasmWLuGWkz0zMxISA+giU1tWPX2j++wSsT oW7NYOwKjTVw
017odHDYoWESKhl09GBb74L+tfHFkHiwSFAfg+fT1sAKeSU+TetPrXSHo94u tQXePJX6jH7D
5g5b1r30h+t9eCrmAAAAAAAA
--------------ms000907080504040604060905--

Re: Can not select SSL mode using OpenOffice Base/Windows

Felix Schwarz wrote:
> Hi,
>
> I'm new to this whole ODBC. I want to access a postgres db from a
> windows xp client. The server only permits SSL connections
> (authentication is done via passwords)...
>
> Therefore I installed OpenOffice 3.1.1 + psqlodbc_08_04_0100. I can
> configure unencrypted (non-ssl) ODBC connections using the wizard
> without any problems. However in the psqlodbc setup window, the only
> available option for 'SSL Mode' is disabled'. Therefore I can not
> connect using SSL.
>
> The bin directory contains ssleay32.dll therefore I assume that the
> binaries I have do work with SSL.
>
> How can I get the other SSL Mode options in that wizard?

Could you please try the drivers on testing for 8.4.0101 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Can not select SSL mode using OpenOffice Base/Windows

This is a cryptographically signed message in MIME format.

--------------ms050000090800070104060502
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

Hiroshi Inoue schrieb:
> Could you please try the drivers on testing for 8.4.0101 at
> http://www.geocities.jp/inocchichichi/psqlodbc/index.html
> ?

Works perfectly for me now :-)
Thank you very much.

fs

PS: The download links in the first table on your page are broken.


--------------ms050000090800070104060502
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJQTCC
AvswggJkoAMCAQICEEnrATC1CFbwLqJ10UHay4QwDQYJKoZIhvcNAQEFBQAw YjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4x LDAqBgNVBAMT
I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDEy NjA2MjQyM1oX
DTEwMDEyNjA2MjQyM1owXzEQMA4GA1UEBBMHU2Nod2FyejEOMAwGA1UEKhMF RmVsaXgxFjAU
BgNVBAMTDUZlbGl4IFNjaHdhcnoxIzAhBgkqhkiG9w0BCQEWFGZlbGl4LnNj aHdhcnpAd2Vi
LmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0Zb4SIt2hm9z glJZhtyJhQ8G
AUqmP3f/rQ9DP84smrrP7Wx7YPhn46iAcr00WX3QgYPp2JlL4fATquKRMPOW 8cSRhKWgIGwz
6AmBFSxo39FuW0ZsfrDTBFL7FS4+lXMEcLPgx/XUjJ1ap8K776dDFW6ox4FB 4tuLmPvR4bCQ
zZXecnbTJssdSt8H1yBoChhrG1YII3b/Z/3bswGpLCJ0/p8dkmrqe2JjCs2Q Azb54JklyY+b
DWg2c9LI7W5uRMgOEzyuG6YrFJV7lf50pvPR9fui5vNdvzY8IEM9+T1uWYbg FdUDK9IAJ/pX
/pMUdyHaXwKeG7gjgsQSJQ5iQHZnEwIDAQABozEwLzAfBgNVHREEGDAWgRRm ZWxpeC5zY2h3
YXJ6QHdlYi5kZTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAAcb sS0VZqGB4v2F
l5pQPGu6f+fRABzlDlNC73uAAlZMZR8M4wPz/cAN1M03RXUJyT2ErFXN6Ng2 puo4EnZQJp0U
gDusvPI5twAP1mrXwxoQlpzdxPY2vxcigYnmPpyY1aj9gfFu7ZR4JUjuSU0c NLGZxZFGBoyP
p8si2VBooQ6TMIIC+zCCAmSgAwIBAgIQSesBMLUIVvAuonXRQdrLhDANBgkq hkiG9w0BAQUF
ADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRk
LjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vpbmcg Q0EwHhcNMDkw
MTI2MDYyNDIzWhcNMTAwMTI2MDYyNDIzWjBfMRAwDgYDVQQEEwdTY2h3YXJ6 MQ4wDAYDVQQq
EwVGZWxpeDEWMBQGA1UEAxMNRmVsaXggU2Nod2FyejEjMCEGCSqGSIb3DQEJ ARYUZmVsaXgu
c2Nod2FyekB3ZWIuZGUwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB AQDRlvhIi3aG
b3OCUlmG3ImFDwYBSqY/d/+tD0M/ziyaus/tbHtg+GfjqIByvTRZfdCBg+nY mUvh8BOq4pEw
85bxxJGEpaAgbDPoCYEVLGjf0W5bRmx+sNMEUvsVLj6VcwRws+DH9dSMnVqn wrvvp0MVbqjH
gUHi24uY+9HhsJDNld5ydtMmyx1K3wfXIGgKGGsbVggjdv9n/duzAaksInT+ nx2Saup7YmMK
zZADNvngmSXJj5sNaDZz0sjtbm5EyA4TPK4bpisUlXuV/nSm89H1+6Lm812/ NjwgQz35PW5Z
huAV1QMr0gAn+lf+kxR3IdpfAp4buCOCxBIlDmJAdmcTAgMBAAGjMTAvMB8G A1UdEQQYMBaB
FGZlbGl4LnNjaHdhcnpAd2ViLmRlMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcN AQEFBQADgYEA
BxuxLRVmoYHi/YWXmlA8a7p/59EAHOUOU0Lve4ACVkxlHwzjA/P9wA3UzTdF dQnJPYSsVc3o
2Dam6jgSdlAmnRSAO6y88jm3AA/WatfDGhCWnN3E9ja/FyKBieY+nJjVqP2B 8W7tlHglSO5J
TRw0sZnFkUYGjI+nyyLZUGihDpMwggM/MIICqKADAgECAgENMA0GCSqGSIb3 DQEBBQUAMIHR
MQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQH EwlDYXBlIFRv
d24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0 aWZpY2F0aW9u
IFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwg RnJlZW1haWwg
Q0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5j b20wHhcNMDMw
NzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMG A1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZy
ZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGB AMSmPFVzVftO
ucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJ FXCO3cnwK4Va
qj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHF KlSFD0gEf6e2
0TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBD BgNVHR8EPDA6
MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxG cmVlbWFpbENB
LmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVBy aXZhdGVMYWJl
bDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7C F6FDlpSdf0wh
uPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sn cVcljd2pnDmO
jCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VP MYIDcTCCA20C
AQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRp bmcgKFB0eSkg
THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vp bmcgQ0ECEEnr
ATC1CFbwLqJ10UHay4QwCQYFKw4DAhoFAKCCAdAwGAYJKoZIhvcNAQkDMQsG CSqGSIb3DQEH
ATAcBgkqhkiG9w0BCQUxDxcNMDkwOTIxMTcwNzUxWjAjBgkqhkiG9w0BCQQx FgQUBMft/3z+
6ijGWtmUkQBUWixyPvQwXwYJKoZIhvcNAQkPMVIwUDALBglghkgBZQMEAQIw CgYIKoZIhvcN
AwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0G CCqGSIb3DQMC
AgEoMIGFBgkrBgEEAYI3EAQxeDB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQK ExxUaGF3dGUg
Q29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29u YWwgRnJlZW1h
aWwgSXNzdWluZyBDQQIQSesBMLUIVvAuonXRQdrLhDCBhwYLKoZIhvcNAQkQ AgsxeKB2MGIx
CzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5 KSBMdGQuMSww
KgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQ SesBMLUIVvAu
onXRQdrLhDANBgkqhkiG9w0BAQEFAASCAQCvK06GCj+TShWMQLPuGWuHlqiP 6/W/hia/OzAL
hfBYSc8nVjWsRnx7Foz4GJOU8wO4EUxYHIuxpEzvSFY7j8F5LwMHlLPIIMx0 n+6cqN8K+l11
/ASg/S8WdLU83HI3kaIlOgqYxyamcDKsW/kaQvayRWPXaXpp7caH00/hVlBT VQyNi8GE8kHm
okyPQ2SWsHgnRcxaa4smC2Wnz+jCN5dXbfBbTCQLlNP7Rrk/jIPFEz00po4L P+cy9hdmurP+
lqtRnK1Il58xd2BcKH40rebK4JBM4zF7E1QXSG73cCVGfdn9oYIfbpBxT9UV MawxaoQoVq0f
T9x1Q1utw1gstESzAAAAAAAA
--------------ms050000090800070104060502--