Problems with VB and ADO

From: "Alessandro Giacometti" <ando(at)libero(dot)it>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Problems with VB and ADO
Date: 2002-02-07 17:19:52
Message-ID: CJEPKIEAKAHEGFPAMACNKECGCBAA.ando@libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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)

another problem ( still not solved):

if i use rs.RecordCount i always obtain "-1" even if i use rs.MoveLast and
rs.MoveFirst.

My machine is a Win98
my server is Mandrake 8.1

thanx a lot

bye

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-02-07 20:52:27 Re: Problems with VB and ADO
Previous Message Benoit Menendez 2002-02-07 06:18:06 Re: Problem with ODBC driver and MSP 2002