VB ADODB .Open failing

[Finn Lassen <dcio@xxxxxxxxxxxx>]

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@xxxxxxxxxxxx
www.AxiomInt.com



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match