Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D1A932E008E for ; Tue, 20 Nov 2007 21:04:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 00327-01-8 for ; Tue, 20 Nov 2007 21:04:42 -0400 (AST) Received: from axiomint.com (static-71-122-253-96.tampfl.dsl-w.verizon.net [71.122.253.96]) by postgresql.org (Postfix) with ESMTP id 407972E0305 for ; Tue, 20 Nov 2007 20:54:46 -0400 (AST) Received: from [10.7.19.90] by axiomint.com (MDaemon.PRO.v8.1.6.R) with ESMTP id md50000535104.msg for ; Tue, 20 Nov 2007 19:54:44 -0500 Message-ID: <474381DC.5090207@AxiomInt.com> Date: Tue, 20 Nov 2007 19:54:52 -0500 From: Finn Lassen User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Postgres General List Subject: VB ADODB .Open failing Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Authenticated-Sender: finnl@axiomint.com X-Spam-Processed: axiomint.com, Tue, 20 Nov 2007 19:54:44 -0500 (not processed: message from valid local sender) X-MDRemoteIP: 10.7.19.90 X-Return-Path: dcio@AxiomInt.com X-MDaemon-Deliver-To: pgsql-general@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.497 tagged_above=0 required=5 tests=BAYES_50=0.001, RDNS_DYNAMIC=0.1, WEIRD_QUOTING=1.396 X-Spam-Level: * X-Archive-Number: 200711/1106 X-Sequence-Number: 124102 I'm new to this, so please bear with me. 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 With dbOut .ConnectionString = "Driver={PostgreSQL ANSI};Server=localhost;Port=5432;Database=postgres;Uid=postgres;Pwd=none;" .Open With rsOut rsOut.Open """Contact1""", dbOut, adOpenDynamic, adLockOptimistic, adCmdTable The .Open statement fails with: "ERROR: column "oid" does not exist; Error while executing the query". I get the same error with the following: rsOut.Open "select * from ""Contact1"";", dbOut, adOpenDynamic, adLockOptimistic, adCmdText Should I have created the table "Contact1" WITH OIDS ? Finn -- Finn Lassen Deputy CIO Axiom 1805 Drew Street Clearwater, Florida 33765 727-442-7774 voice 727-442-8344 fax dcio@AxiomInt.com www.AxiomInt.com