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:

=E2=80=9CERROR [08001] connction string lacks some options=E2=80=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

<HTML><HEAD></HEAD>
<BODY dir=3Dltr>
<DIV dir=3Dltr>
<DIV style=3D"FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>I have a problem with PostgreSQL ODBC (version <FONT
face=3D"Times New Roman">psqlodbc_08_04_0200</FONT>). After I have set =
ssl=3Dtrue in
connection string sometimes my application in vb.net throws this =
error:</DIV>
<DIV> </DIV>
<DIV>=E2=80=9CERROR [08001] connction string lacks some =
options=E2=80=9D</DIV>
<DIV> </DIV>
<DIV>Without ssl the connection works perfectly.</DIV>
<DIV> </DIV>
<DIV>Has someone any idea what the problem is.</DIV>
<DIV> </DIV>
<DIV>best regards</DIV>
<DIV> </DIV>
<DIV>Pawel</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></DIV></DIV></BODY></HTML>

------=_NextPart_000_00D9_01CB96DC.F2496960--
pawelkopka [ Mi, 08 Dezember 2010 13:36 ] [ ID #2051429 ]

Re: Problem with psqlodbc

(2010/12/08 21:36), Pawe=C5=82 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.

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


--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Hiroshi Inoue [ Mi, 08 Dezember 2010 22:38 ] [ ID #2051430 ]

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=C5=9B=C4=87-----
From: Hiroshi Inoue
Sent: Wednesday, December 08, 2010 10:38 PM
To: Pawe=C5=82 Kopka
Cc: pgsql-odbc [at] postgresql.org
Subject: Re: [ODBC] Problem with psqlodbc

(2010/12/08 21:36), Pawe=C5=82 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.

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


--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
pawelkopka [ Mi, 08 Dezember 2010 23:16 ] [ ID #2051431 ]

Re: Problem with psqlodbc

(2010/12/09 7:16), Pawe=C5=82 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")

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Hiroshi Inoue [ Do, 09 Dezember 2010 11:31 ] [ ID #2051495 ]
Datenbanken » gmane.comp.db.postgresql.odbc » Problem with psqlodbc

Vorheriges Thema: Best way Driver 8.04.01 with Release 9.0
Nächstes Thema: Compatibility between ODBC driver versions and PostgreSQL Serverversions