From: | Finn Lassen <dcio(at)AxiomInt(dot)com> |
---|---|
To: | Postgres General List <pgsql-general(at)postgresql(dot)org> |
Subject: | VB ADODB .Open failing |
Date: | 2007-11-21 00:54:52 |
Message-ID: | 474381DC.5090207@AxiomInt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | Postg토토 커뮤니티SQL Postg무지개 토토SQL : Postg무지개 토토SQL 메일 링리스트 : 2007-11-21 00:54 이후 PGSQL-PHP |
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(at)AxiomInt(dot)com
www.AxiomInt.com
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-11-21 01:24:06 | Re: IP addresses |
Previous Message | Ow Mun Heng | 2007-11-21 00:14:07 | Re: Calculation for Max_FSM_pages : Any rules of thumb? |
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Bax | 2007-11-21 03:53:54 | Re: string function |
Previous Message | ljb | 2007-08-29 01:04:44 | Re: PHP and libpq version question |