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