Re: ODBC driver causes VB to crash - Mailing list pgsql-odbc

From Dave Page
Subject Re: ODBC driver causes VB to crash
Date
Msg-id D85C66DA59BA044EB96AB9683819CF61138029@dogbert.vale-housing.co.uk
Whole thread Raw
In response to ODBC driver causes VB to crash  (Corey Gibbs <cgibbs@westmarkproducts.com>)
List pgsql-odbc

> -----Original Message-----
> From: Corey Gibbs [mailto:cgibbs@westmarkproducts.com]
> Sent: 07 August 2002 23:02
> To: Dave Page; pgsql-odbc@postgresql.org
> Subject: RE: [ODBC] ODBC driver causes VB to crash
>
>
> the PGAdmin theory wasn't it.  But, what i did find was if i
> did rs.Open"SELECT field1,field2,..." instead of "SELECT *
> ..." it worked.
>
> I've run into the * problem with other tables before, but
> those tables had
> like 40 columns with real long column names.  This table only
> had 8 columns
> with modertly short column names.
>
> So, four hours later...
> I did find out it was a VB problem, my PG server was passing
> all requested
> data back, but VB was choking on it (imagine that)
>
> thanks for feedback, i think i've earned that new workstation ;)

Glad to hear it's working now. Incidently (for future reference),
pgAdmin is written in VB6 and uses ADO/MDAC, so if it works OK, then
it's a reasonable assumtion that MDAC & ODBC are OK.

Regards, Dave.

pgsql-odbc by date:

Previous
From: Corey Gibbs
Date:
Subject: Re: ODBC driver causes VB to crash
Next
From: "Eng Kern Shen"
Date:
Subject: Problem with psqlODBC 07.02.0001and VB 6