From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Alessandro Giacometti'" <ando(at)libero(dot)it>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Problems with VB and ADO |
Date: | 2002-02-07 20:52:27 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB104753E@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Alessandro Giacometti [mailto:ando(at)libero(dot)it]
> Sent: 07 February 2002 17:20
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Problems with VB and ADO
>
>
> i had some problems with the example about VB and ADO i found
> on odbc.postresql.org :
>
> i have a line like this :
>
> rs.Open "SELECT id, data FROM vbtest", cn, adOpenDynamic
>
> ok, my table is different, but the problem is that the
> recordset i obtain is read only unless i use the
> "adLockOptimistic" clause (which is not present in the
> example)
Do you have a trailing semi-colon on the end of the query?
> another problem ( still not solved):
>
> if i use rs.RecordCount i always obtain "-1" even if i use
> rs.MoveLast and rs.MoveFirst.
Yes, that is normal. There is a Microsoft Knowledgebase article about it I
believe though I don't know the ID.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Gray | 2002-02-08 00:05:22 | Re: Problems with VB and ADO |
Previous Message | Alessandro Giacometti | 2002-02-07 17:19:52 | Problems with VB and ADO |