Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A532F2E0045 for ; Wed, 21 Nov 2007 00:34:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 65328-02 for ; Wed, 21 Nov 2007 00:33:57 -0400 (AST) Received: from web31806.mail.mud.yahoo.com (web31806.mail.mud.yahoo.com [68.142.207.69]) by postgresql.org (Postfix) with SMTP id 6A8CD2E0032 for ; Wed, 21 Nov 2007 00:33:57 -0400 (AST) Received: (qmail 76126 invoked by uid 60001); 21 Nov 2007 04:33:56 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=PvfCcwp0Q+SAgeAXG4P7lJ3m/LHO0503ULFYtmFvKmjSBhT/a9gSHJzupurkiITpOc8ns5lHO5bILf/1sv0eQnGJWY3AsJWcTeP4mQ7T8NSSnS0HgmlSurqPkxc7dMQOE7xn1guBbDcQs6ZbvoJtB4F3qSPbfWWfZzaJ/1AHULI=; X-YMail-OSG: xRP1ImEVM1muLQYBhqbkT9xl0X8yvL4M18OjjRNQU5sh10BjCd6GJWgc_XwMwDziapfXNfsBug-- Received: from [75.84.89.248] by web31806.mail.mud.yahoo.com via HTTP; Tue, 20 Nov 2007 20:33:56 PST X-Mailer: YahooMailWebService/0.7.158 Date: Tue, 20 Nov 2007 20:33:56 -0800 (PST) From: Richard Broersma Jr Subject: Re: VB ADODB .Open failing To: Postgres General List , Finn Lassen In-Reply-To: <474381DC.5090207@AxiomInt.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <597066.69415.qm@web31806.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.157 tagged_above=0 required=5 tests=AWL=0.342, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200711/1112 X-Sequence-Number: 124108 --- On Tue, 11/20/07, Finn Lassen wrote: > Here is a VB code snippet: > Dim dbOut As ADODB.Connection > Dim rsOut As ADODB.Recordset > Set dbOut = New ADODB.Connection > Set rsOut = New ADODB.Recordset > .ConnectionString = "Driver={PostgreSQL > ANSI};Server=localhost;Port=5432;Database=postgres;Uid=postgres;Pwd=none;" > Should I have created the table "Contact1" WITH > OIDS ? I wonder if this is a problem with the way your ODBC driver is configured. If it is a problem with your ODBC driver configuration, you might also try posting to the PostgreSQL-ODBC mailing list. Also, why did you choose the ANSI driver over the Unicode driver? Regards, Richard Broersma Jr.