Re: Multiple ConnSettings statements in connection string

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Michael Toews <mwtoews(at)sfu(dot)ca>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Multiple ConnSettings statements in connection string
Date: 2009-03-28 11:40:08
Message-ID: 49CE0C98.1080506@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Michael Toews wrote:
> Hi,
>
> I am using psqlODBC version 8.03.02.00 in Windows XP in a Python script using win32com with MS Access. In this script, I need to configure a connection string that sets a few run-time parameters:
>
> set TimeZone to -8;
> set search_path to pid,public;
>
> These need to be somehow nested in ConnSettings of the connection string, since I have no ability from MS Access to send these commands.
>
> I've tried:
> ConnSettings="set TimeZone to -8; set search_path to pid,public;" -- does neither commands
> ConnSettings={set TimeZone to -8; set search_path to pid,public;} -- sends only first command

ConnSettings=set+TimeZone+to+%2d8%3b+set+search%5fpath+to+pid%2cpublic%3b

regards,
Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Johann Zuschlag 2009-03-28 14:04:34 Re: Release plan
Previous Message Hiroshi Inoue 2009-03-28 11:26:05 Re: [Q] specifying bigint