From: ilMes mes (il_meshotmail.com)
Date: Mon Jan 19 2004 - 07:32:17 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Ok, ok, the solution is:

    rs.LockType = adLockOptimistic

Sorry :P

Ettore, il Mes

>From: "PcgScrapAddy" <pcgscrapcomcast.net>
>To: "ilMes mes" <il_meshotmail.com>,<maxdblists.mysql.com>
>Subject: RE: ADO/VB6/.addnew
>Date: Mon, 19 Jan 2004 07:04:06 -0600
>
>change your cursor type.
>
>-----Original Message-----
>From: ilMes mes [mailto:il_meshotmail.com]
>Sent: Monday, January 19, 2004 6:42 AM
>To: maxdblists.mysql.com
>Subject: ADO/VB6/.addnew
>
>
>
>Hello,
>
>MaxDB 7.05.08, on Linux Red Hat 8.0
>Visual Basic 6.0, ADO 2.8
>
>i have an .AddNew problem:
>
> Dim rs As adodb.Recordset
> Dim objConn As New adodb.Connection
> objConn.ConnectionString = "DSN=MATRICE;UID=USER;PWD=PSWUSER"
> Call objConn.Open
>
> Set rs = New adodb.Recordset
> Set rs.ActiveConnection = objConn
> rs.CursorType = adOpenStatic
> rs.CursorLocation = adUseClient
> rs.Open "SELECT * FROM IMPOSTAZIONI"
>
> rs.AddNew ' << DO NOT WORK!!!!!! WHY???????
> rs.Fields("NOME") = "VAR-NAME1"
> rs.Fields("VALORE") = "1.2.3"
> rs.Update
>
>the VB generate the error:
>3251 - The object or provider is not capable of performing the requested
>operation. Some operations depend on a particular provider version.
>
>I tryed adOpenKeyset and adUseServer in same combinations, but do not work.
>how it is made to make a addnew with ADO and MaxDB?
>
>TNKS!
>
>Ettore, il Mes
>
>_________________________________________________________________
>MSN Extra Storage! Hotmail all'ennesima potenza. Provalo!
>http://join.msn.com/?pgmarket=it-it&page=hotmail/es2&xAPID=1983&DI=2049&ST=1
>
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe: http://lists.mysql.com/maxdb?unsub=pcgscrapcomcast.net
>
>
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe: http://lists.mysql.com/maxdb?unsub=il_meshotmail.com
>

_________________________________________________________________
Comunica in un ’altra dimensione con MSN Extra Storage!
http://join.msn.com/?pgmarket=it-it&page=hotmail/es2&xAPID=1983&DI=2049&ST=1

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]