VB ADODB .Open failing
От | Finn Lassen |
---|---|
Тема | VB ADODB .Open failing |
Дата | |
Msg-id | 474381DC.5090207@AxiomInt.com обсуждение исходный текст |
Ответы |
Re: VB ADODB .Open failing
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: