Hallo,
i have problem with recorset update. When i call update method, error "-2147467259
(80004005). For refresh is not enought information about base table" is shown. Field
'Platz' is indexed and table have primary key. I use MS Access 2000, ADO 2.7, SAPDB
ODBC Driver 7.4, SAPDB 7.4.
Support ADO with MS OLE DB Provider for ODBC (MSDASQL.1) updatable recordset? ...or
what is bad? Linked table in MS Access is updatable (is not connected trought ADO).
Thank for Your help
Lubos Posledni
EDV Centrala, Globus CR
tel. +420-283066241, +420-605232764
****************************************************
Here is code:
Dim conn As ADODB.Connection
Dim rst As ADODB.Recordset
Set conn = New ADODB.Connection
Set rst = New ADODB.Recordset
With conn
.Provider = "MSDASQL.1"
.ConnectionString = "DRIVER=SAP DB
7.4;SERVERNODE=crko0066;UID=ADMINISTRATOR;PWD=ptpt;SERVERDB=sapdb43;SERVER=crko0066"
.Open
End With
rst.CursorLocation = adUseClient
rst.Index = "PRVNIPLATZ"
LckTyp = adLockOptimistic
rst.Open "select * from prvniplatz", conn, adOpenDynamic, LckTyp
rst.AddNew
rst.Fields("platz") = "jedna"
rst.Update ' -> error "-2147467259 (80004005)
****************************************************
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
