Re: [odbc] dsnless with connsettings - Mailing list pgsql-odbc

From Jaime Casanova
Subject Re: [odbc] dsnless with connsettings
Date
Msg-id AANLkTimCrpHPf6EB46_t-yNe-8ZKH7nAsr-AqcsVfdTQ@mail.gmail.com
Whole thread Raw
In response to [odbc] dsnless with connsettings  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-odbc
On Wed, May 12, 2010 at 5:00 PM, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> Hi,
>
> I'm trying to make a dsnless connection, but i want to specify:
> ConnSettings=set client encoding to 'latin1';
> is this possible? the reason is that my client wants dsnless but when
> i try to connect get a client_encoding
>

answering myself, what i should be using is:
"""
cn.Open "Provider=MSDASQL.1;DRIVER=PostgreSQL
ANSI;DATABASE=imrelevsa;SERVER=localhost;PORT=54329;UID=sa;client_encoding=latin1;boolsaschar=0"
"""

sorry for the noise

--
Jaime Casanova         www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL

pgsql-odbc by date:

Previous
From: Jaime Casanova
Date:
Subject: [odbc] dsnless with connsettings
Next
From: Pierangelo Russo
Date:
Subject: error compiling psqlodbc-08.04.0200 under red hat 5