Re: ODBC 64bit + SSL

From: Hiroshi Saito <hiroshi(at)winpg(dot)jp>
To: Petr Patera PikoSoft <petr(dot)patera(at)pikosoft(dot)cz>
Cc: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC 64bit + SSL
Date: 2012-09-12 15:08:22
Message-ID: 5050A566.5080207@winpg.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Petr-san.

Thank you for precious information.
> Anyway I'm happy that it is working now.
I understood that this all came out.:-)

Regards,
Hiroshi Saito

(2012/09/12 6:18), Petr Patera PikoSoft wrote:
> Hi,
> first of all, many thanks for your help.
>
> I already solved this issue.
> It seems that the problem was with server certificate.
> When I use different certificate all is working correctly.
> Very strange is, that in 32 bit version both certificates are working correctly.
> Anyway I'm happy that it is working now.
>
> For your reference I'm sending log files.
>
> In the event viewer / Windows logs / Application I can see following error everytime i try to connect using 64bit ODBC with SSL with not working certificate.
>
> Faulting application name: odbcad32.exe, version: 6.1.7600.16385, time stamp: 0x4a5bd12d
> Faulting module name: CRYPT32.dll, version: 6.1.7601.17827, time stamp: 0x4f963a60
> Exception code: 0xc0000005
> Fault offset: 0x00000000000095ce
> Faulting process id: 0x10b8
> Faulting application start time: 0x01cd905b4a66d024
> Faulting application path: C:\Windows\system32\odbcad32.exe
> Faulting module path: C:\Windows\system32\CRYPT32.dll
> Report Id: 8fa4fb23-fc4e-11e1-a06d-74f06da79938
>
> On the server I can see
> LOG: could not accept SSL connection: Connection reset by peer
>
> Regards
> Petr Patera
>
>
> -----Original Message-----
> From: Hiroshi Saito [mailto:hiroshi(at)winpg(dot)jp]
> Sent: Tuesday, September 11, 2012 5:43 PM
> To: Petr Patera
> Cc: pgsql-odbc(at)postgresql(dot)org; Hiroshi Inoue
> Subject: Re: [ODBC] ODBC 64bit + SSL
>
> Hi.
>
> Um, There is no problem in my windows7-64bit environment.
> ==
> C:\home\odbcregress>odbctest64.exe DSN=PostgreSQL35W iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.80.7601.0000
> Driver: 09.01.0200 (PSQLODBC35W.DLL)
>
> SQL>show ssl;
>
> ssl
> ------------------------------
> on
>
> result set 1 returned 1 rows.
>
> ==
>
> Would you send the connection log to me?
>
> Regards,
> Hiroshi Saito
>
> (2012/09/11 20:00), Petr Patera wrote:
>> Hello,
>>
>> I'm unable to make a connection using 64bit ODBC driver together with SSL.
>>
>> When I turn off SSL it works fine using 64bit version.
>>
>> When I use 32 bit ODBC with SSL it works fine as well.
>>
>> The problem is only when using 64bit version + SSL.
>>
>> Could you, please, be so kind to assist me with this problem.
>>
>> Many thanks in advance for your help.
>>
>> Best regards
>>
>> Petr Patera
>>
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message George Weaver 2012-09-24 19:15:04 Application Name
Previous Message Hiroshi Saito 2012-09-12 14:11:36 Re: Regarding PostgreSQL BIT datatype binding in ODBC.......