| From: | Michael Toews <mwtoews(at)sfu(dot)ca> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Multiple ConnSettings statements in connection string |
| Date: | 2009-03-25 19:49:46 |
| Message-ID: | 1753555089.1772941238010586819.JavaMail.root@jaguar9.sfu.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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
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_path to pid,public;"'%\
(host, dbname, username, password)
ac.OpenCurrentDatabase(r'C:\mydb.mdb')
ac.DoCmd.TransferDatabase(acExport, 'ODBC Database', acConnStr, acTable, 'MyTable', 'MyTable')
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raul Orduna | 2009-03-27 12:44:13 | Problem with Oracle, ODBC and Postgresql |
| Previous Message | Arnold, Sandra | 2009-03-25 13:30:09 | Re: Changing Port number in a File DSN |