Search Postgresql Archives

VB ADODB .Open failing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux