Обсуждение: [odbc] dsnless with connsettings

Поиск
Список
Период
Сортировка

[odbc] dsnless with connsettings

От
Jaime Casanova
Дата:
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

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

Re: [odbc] dsnless with connsettings

От
Jaime Casanova
Дата:
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