Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C8BC49F97E5 for ; Thu, 6 Sep 2007 13:52:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 37259-09 for ; Thu, 6 Sep 2007 13:52:07 -0300 (ADT) X-Greylist: delayed 00:10:04.340528 by SQLgrey-1.7.5 Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by postgresql.org (Postfix) with ESMTP id 746DD9F951E for ; Thu, 6 Sep 2007 13:52:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web31812.mail.mud.yahoo.com (unknown [68.142.207.75]) by mx3.hub.org (Postfix) with SMTP id 672C537D804 for ; Thu, 6 Sep 2007 13:35:26 -0300 (ADT) Received: (qmail 33076 invoked by uid 60001); 6 Sep 2007 16:08:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=pVwNXGa3Ae4qI54SrEeYAXHUeQMcUjT8TwIvBs+zeQtaPYlAN483J1A64qC+VKcwlf8uBHMR9MYmv3rq22+aFob3e+DEaSX7SNUTR2soYOtxTKeo8zBvBqWhTfhRz2oHcmuX2uJSfnl/+yyk/w1dA3UhTZbap3RvmyBF6nQqKxY=; X-YMail-OSG: fw0l0wkVM1lX0xMO7Sxd2xU1kSsUDVTCSi5XvC3fMnw1MgK2zwZjSZy1g0pNGTgPn3AT3Q-- Received: from [12.180.237.138] by web31812.mail.mud.yahoo.com via HTTP; Thu, 06 Sep 2007 09:08:29 PDT Date: Thu, 6 Sep 2007 09:08:29 -0700 (PDT) From: Richard Broersma Jr Subject: Re: ADO -PostgreSQL OLE DB Provider To: Jayaram Bhat , pgsql-admin@postgresql.org Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <337114.32651.qm@web31812.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/36 X-Sequence-Number: 26797 --- Jayaram Bhat wrote: > I am using a postgres setup in Windows. And it is working fine usings ODBC > drive, but not in ADO PostgreSQL OLE DB Provider > > giving error test connection 'Test connection failed because of an error in > initializing provider. Unspecified error' > > Can i get help for the same This is my understanding regarding the OLE DB driver for PostgreSQL: (1) The OLE DB Provider lacks the robustness that the ODBC driver has. (2) The OLE DB Provider lacks much of the Functionality that an OLE DB provider should have. (3) And this probably will not change soon since the OLE DB driver is not actively supported. Regards, Richard Broersma Jr.