Connection.Mode=adModeRead fails?

Hi,
vb6+mssql2000 i want to disable updates by set cn.mode=adModeRead. inspite
of this, i can do modifications without error... any tip? what should i
check?
Hi,
It could be that provider does not support this mode. What is your
connection string?
Val Mazur
Microsoft MVP
"SRINGER Zoltn" <kecskemetisrac@.remove.it.freemail.hu> wrote in message
news:OIj6BsMoEHA.3876@.TK2MSFTNGP15.phx.gbl...
> Hi,
> vb6+mssql2000 i want to disable updates by set cn.mode=adModeRead.
> inspite
> of this, i can do modifications without error... any tip? what should i
> check?
>
|||i dont remember exactly, but nothing strange:
provider=sqloledb, login=sa..
"Val Mazur" <group51a@.hotmail.com> az albbiakat rta a kvetkezo zenetben
news:uvYHPaRoEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It could be that provider does not support this mode. What is your
> connection string?
> --
> Val Mazur
> Microsoft MVP
>
> "SRINGER Zoltn" <kecskemetisrac@.remove.it.freemail.hu> wrote in message
> news:OIj6BsMoEHA.3876@.TK2MSFTNGP15.phx.gbl...
>
|||Are you sure about connection string? I believe OLEDB for SQL Server
supports it
Val Mazur
Microsoft MVP
"SRINGER Zoltn" <kecskemetisrac@.remove.it.freemail.hu> wrote in message
news:euRGzTZoEHA.644@.tk2msftngp13.phx.gbl...
>i dont remember exactly, but nothing strange:
> provider=sqloledb, login=sa..
>
> "Val Mazur" <group51a@.hotmail.com> az albbiakat rta a kvetkezo
> zenetben
> news:uvYHPaRoEHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||hi Val,
"Val Mazur" <group51a@.hotmail.com> ha scritto nel messaggio
news:%23Pk9yndoEHA.516@.TK2MSFTNGP09.phx.gbl
> Are you sure about connection string? I believe OLEDB for SQL Server
> supports it
>
actually I tried myself with VB6, OLE DB provider, ADO 2.6 and had the same
result indeed..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply