Thread: 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

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@postgresql.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

(2010/12/09 7:16), Paweł Kopka wrote:
> This is the connection string:
>
> ("Driver=" & lvarPostgreOdbcName & ";Server=" & mvarServer & ";Uid=" &
> mvarUser & ";" & _
> "Pwd=" & mvarPassword & "; Database=" & mvarDataBase & ";Port=" &

There is a space between ";" and "Database=".
Isn't it a problem?

> lvarPort & ";SSL=True;sslmode=prefer")