Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 69EFE9FA0CC for ; Tue, 19 Dec 2006 14:06:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 41337-09-2 for ; Tue, 19 Dec 2006 14:06:12 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id DB1719FA249 for ; Tue, 19 Dec 2006 14:06:11 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 1CE9730E18; Tue, 19 Dec 2006 19:06:11 +0100 (MET) From: "Carlo Stonebanks" X-Newsgroups: pgsql.interfaces Subject: ODBC: how to change search_path in DSN? Date: Tue, 19 Dec 2006 13:06:48 -0500 Organization: Hub.Org Networking Services Lines: 16 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Original To: pgsql-interfaces@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.031 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200612/21 X-Sequence-Number: 6355 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 connection for the ODBC DSN file change the default search_path to my_schema (and my_schema only). After seeing a post on this on another resource, I tried putting schema=my_schema in the connection settings text box, but the tables appeared in public anyway. Thanks! Carlo