Problem with psqlodbc

To jest wieloczêœciowa wiadomoœæ w formacie MIME.

------=_NextPart_000_00D9_01CB96DC.F2496960
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

I have a problem with PostgreSQL ODBC (version psqlodbc_08_04_0200). =
After I have set ssl=3Dtrue in connection string sometimes my =
application in vb.net throws this error:

â€=9CERROR [08001] connction string lacks some optionsâ€=9D

Without ssl the connection works perfectly.

Has someone any idea what the problem is.

best regards

Pawel



------=_NextPart_000_00D9_01CB96DC.F2496960
Content-Type: text/html;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Re: 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=3Dtrue in connection string sometimes my applicati=
on
> in vb.net throws this error:

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

> â€=9CERROR [08001] connction string lacks some optionsâ€=9D
> Without ssl the connection works perfectly.
> Has someone any idea what the problem is.
> best regards
> Pawel


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Problem with psqlodbc

This is the connection string:

("Driver=3D" & lvarPostgreOdbcName & ";Server=3D" & mvarServer & ";Uid=3D=
" &
mvarUser & ";" & _
"Pwd=3D" & mvarPassword & "; Database=3D" & mvarDataBase & ";Port=3D" =
&
lvarPort & ";SSL=3DTrue;sslmode=3Dprefer")

-----Oryginalna wiadomość-----=20
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=3Dtrue in connection string sometimes my applicati=
on
> in vb.net throws this error:

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

> â€=9CERROR [08001] connction string lacks some optionsâ€=9D
> Without ssl the connection works perfectly.
> Has someone any idea what the problem is.
> best regards
> Pawel


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Problem with psqlodbc

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

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

> lvarPort & ";SSL=3DTrue;sslmode=3Dprefer")

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc