Skip site navigation (1) Skip section navigation (2)

Re: [odbc] dsnless with connsettings

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [odbc] dsnless with connsettings
Date: 2010-05-12 22:16:15
Message-ID: AANLkTimCrpHPf6EB46_t-yNe-8ZKH7nAsr-AqcsVfdTQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Wed, May 12, 2010 at 5:00 PM, Jaime Casanova <jaime(at)2ndquadrant(dot)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

In response to

pgsql-odbc by date

Next:From: Pierangelo RussoDate: 2010-05-14 16:03:47
Subject: error compiling psqlodbc-08.04.0200 under red hat 5
Previous:From: Jaime CasanovaDate: 2010-05-12 22:00:45
Subject: [odbc] dsnless with connsettings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group