Thread: ODBC 64bit + SSL

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

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
>

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
ODBCwith 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@winpg.jp]
> Sent: Tuesday, September 11, 2012 5:43 PM
> To: Petr Patera
> Cc: pgsql-odbc@postgresql.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
SQLprocessor 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
>>
>