[Oledb-dev] pgoledb 1.0.0.9 ssl connection

[Shachar Shemesh]

Mario Soto Cordones - Venezuela wrote:

>Hi
>
>I have an application made in visual basic 6 that is connected to a
>database postgresql 8.0.3.
>  
>when I try to connect myself in way ssl to the servant this it is not
>connected,
>  
>this it is my connection string
>
>
>strCn = "DRIVER={PostgreSQL};DATABASE=" & gblBaseDatos & ";SERVER=" &
>gblServidor & ";PORT=" & gblPuerto & ";UID=" & gblUsuario & ";PWD=" &
>gblPasswordBaseDatos & ";"
>
>
>Set BaseRemota = New ADODB.Connection
>    With BaseRemota
>        .ConnectionString = strCn
>        .ConnectionTimeout = 30000
>        .CommandTimeout = 30000
>        .CursorLocation = adUseClient
>        .Properties("PROMPT") = adPromptNever
>        .Open
>    End With
>boBaseAbierta = True
>
>
>please any idea
>
>thank you very much
>  
>
While PgOleDb uses libpq for the actual database communication, we are 
having a problem with connecting using SSL or a different port number. 
The problem is that our argument parsing is currently implemented solely 
using the ATL template, which means we have no way to support a 
parameter for which there is no standard macro in ATL. As a result, 
there is no way for us to get the fact that you are asking for a 
different port number, or for SSL connection.

There is currently no time estimate for fixing this, but it's going to 
be, fairly much, the first thing I'll do when I get around to hacking 
PgOleDb again.

          Shachar

-- 
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/