Re: [HACKERS] [INTERFACES] ODBC: how to change search_path in DSN?

2007-01-15 Thread Carlo Stonebanks
Hi Jim, The solution was to put " set search_path=new_path" in Connection Settings in the ODBC configuration (on Page 2 of the dialog). Carlo -Original Message- From: Jim Nasby [mailto:[EMAIL PROTECTED] Sent: January 14, 2007 10:07 PM To: Carlo Stonebanks Cc: [EMAIL PROTECTED]; PGSQL Ha

Re: [HACKERS] [INTERFACES] ODBC: how to change search_path in DSN?

2007-01-15 Thread Jim Nasby
On Dec 19, 2006, at 12:06 PM, Carlo Stonebanks wrote: I would like to create an ODBC DSN for a user to export files rom Acccess to a safe area. Right now, all tables are being dumped to public by default. In order to use the one-click export option for Access, I would like to have the con