| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierangelo Russo | 2010-05-14 16:03:47 | error compiling psqlodbc-08.04.0200 under red hat 5 |
| Previous Message | Jaime Casanova | 2010-05-12 22:00:45 | [odbc] dsnless with connsettings |