Re: VB ADODB .Open failing

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>, Finn Lassen <dcio(at)AxiomInt(dot)com>
Subject: Re: VB ADODB .Open failing
Date: 2007-11-21 04:33:56
Message-ID: 597066.69415.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-php

--- On Tue, 11/20/07, Finn Lassen <dcio(at)AxiomInt(dot)com> wrote:
> 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
> .ConnectionString = "Driver={PostgreSQL
> ANSI};Server=localhost;Port=5432;Database=postgres;Uid=postgres;Pwd=none;"

> Should I have created the table "Contact1" WITH
> OIDS ?

I wonder if this is a problem with the way your ODBC driver is configured. If it is a problem with your ODBC driver configuration, you might also try posting to the PostgreSQL-ODBC mailing list.

Also, why did you choose the ANSI driver over the Unicode driver?

Regards,
Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message xeb 2007-11-21 06:38:16 Re: ERROR: invalid restriction selectivity: 224359728.000000
Previous Message Tom Lane 2007-11-21 03:38:16 Re: possible to create multivalued index from xpath() results in 8.3?

Browse pgsql-php by date

  From Date Subject
Next Message Dane Springmeyer 2007-11-21 07:14:15 Normalization tools for postgres?
Previous Message Frank Bax 2007-11-21 03:53:54 Re: string function