Re: Problem with psqlodbc

This is the connection string:

("Driver=" & lvarPostgreOdbcName & ";Server=" & mvarServer & ";Uid=" &
mvarUser & ";" & _
"Pwd=" & mvarPassword & "; Database=" & mvarDataBase & ";Port=" &
lvarPort & ";SSL=True;sslmode=prefer")

-----Oryginalna wiadomość-----
From: Hiroshi Inoue
Sent: Wednesday, December 08, 2010 10:38 PM
To: Paweł Kopka
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Problem with psqlodbc

(2010/12/08 21:36), Paweł Kopka wrote:
> Hi,
> I have a problem with PostgreSQL ODBC (version psqlodbc_08_04_0200).
> After I have set ssl=true in connection string sometimes my application
> in vb.net throws this error:

What is your connection string concretely?
Anyway ssl=true is not an effective option.
Maybe sslmode=disable/allow/prefer/require is the correspoding option.

> “ERROR [08001] connction string lacks some options”
> Without ssl the connection works perfectly.
> Has someone any idea what the problem is.
> best regards
> Pawel