Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WWWXXX DACB, wwwxxx,nvif, why atm producer might be held liable for economic injury, wwwxxxy=ServiceLogin, w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table

Links

XODOX
Impressum

#1: Problem with psqlodbc

Posted on 2010-12-08 13:36:41 by pawelkopka

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

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

------=_NextPart_000_00D9_01CB96DC.F2496960--

Report this message

#2: Re: Problem with psqlodbc

Posted on 2010-12-08 22:38:02 by Hiroshi Inoue

(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

Report this message

#3: Re: Problem with psqlodbc

Posted on 2010-12-08 23:16:43 by pawelkopka

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

Report this message

#4: Re: Problem with psqlodbc

Posted on 2010-12-09 11:31:44 by Hiroshi Inoue

(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

Report this message