Re: ODBC driver causes VB to crash

> -----Original Message-----
> From: Corey Gibbs [mailto:cgibbs(at)westmarkproducts(dot)com]
> Sent: 07 August 2002 23:02
> To: Dave Page; pgsql-odbc(at)postgresql(dot)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.