Thread: Multiple ConnSettings statements in connection string

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,
Ineed 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
sendthese 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

Each time, it seems to connect properly, but the second command is not issued.

--
For the curious, I'm exporting tables from within Access using (approx):

import win32com.client
ac = win32com.client.Dispatch(r'Access.Application')
acExport = 1; acTable = 0
connStr = 'Driver={PostgreSQL Unicode};Server=%s;Database=%s;Uid=%s;Pwd=%s;ConnSettings="set TimeZone to -8; set
search_pathto pid,public;"'%\ 
          (host, dbname, username, password)
ac.OpenCurrentDatabase(r'C:\mydb.mdb')
ac.DoCmd.TransferDatabase(acExport, 'ODBC Database', acConnStr, acTable, 'MyTable', 'MyTable')

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
sendthese 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