Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 095501337FB6 for ; Fri, 17 Sep 2010 18:00:36 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 66629-01 for ; Fri, 17 Sep 2010 21:00:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from www1.brickcitywebs.net (www1.brickcitywebs.net [8.8.67.10]) by mail.postgresql.org (Postfix) with ESMTP id 732541337DF8 for ; Fri, 17 Sep 2010 18:00:27 -0300 (ADT) Received: (qmail 19671 invoked from network); 17 Sep 2010 17:00:26 -0400 Received: from softdnserror (HELO outlook.rad-con.com) (12.49.144.162) by www1.brickcitywebs.net with SMTP; 17 Sep 2010 17:00:26 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: How do I use Npgsql to connect to a DSN? Date: Fri, 17 Sep 2010 17:00:22 -0400 Message-ID: <04A6DB42D2BA534FAC77B90562A6A03D01554ABE@server.rad-con.local> In-Reply-To: <4C653C85.1010602@iol.ie> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How do I use Npgsql to connect to a DSN? thread-index: Acs65FQOTYeCf+YaSAOioSMjjrGBuQbxquwQ References: <4C653C85.1010602@iol.ie> From: "Rob Richardson" To: "pgsql-odbc" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201009/20 X-Sequence-Number: 10430 Greetings! I like the layer of independence the use of a DSN gives me. I can run an application using one database, and then without changing the application in any way, change the DSN to point to a different database, and it still works. I am about to begin developing an application using the Npgsql ADO .Net provider for PostgreSQL. I tried to specify a DSN in my connection string, but the parameter name "DSN" was not accepted. Is it not possible to use a DSN with Npgsql? Thanks very much! RobR