From: ilMes mes (il_meshotmail.com)
Date: Mon Jan 19 2004 - 06:42:04 CST

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

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

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