Re: Problem with psqlodbc - Mailing list pgsql-odbc

From Paweł Kopka
Subject Re: Problem with psqlodbc
Date
Msg-id 8EF8222B5911460CB5B1958988FA7AD2@pkop
Whole thread Raw
In response to Re: Problem with psqlodbc  (Hiroshi Inoue <inoue@tpf.co.jp>)
Responses Re: Problem with psqlodbc  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Problem with psqlodbc
Next
From: Hiroshi Inoue
Date:
Subject: Re: Problem with psqlodbc