Data Insert Problem NotesSql using Asp

HCL Domino Domino Forum
1

Hi,When i try to insert data from Asp to a .Nsf file using NotesSql i get the following error. I have no problem with connecting to database or reading datas. I have designer rights on database so there is no problem about user privileges.

So when i try to insert table i get this error message.

Microsoft OLE DB Provider for ODBC Drivers hata ‘80004005’

[Lotus][ODBC Lotus Notes]No INSERT/UPDATE/ALTER/CREATE INDEX/CREATE VIEW on view

And here is my source code;

<%

Dim strInsert

Dim objCmd

Set oConn = Server.CreateObject(“ADODB.Connection”)

oConn.ConnectionString = “DSN=Lotusanket”

oConn.CursorLocation = adUseClient

oConn.Open

strInsert = “INSERT INTO InternetListesi (Form,FirstName,LastName) VALUES(‘Contact’,‘Cihan’,‘Erdoğan’)”

Set objCmd = Server.CreateObject(“ADODB.Command”)

Set objCmd.ActiveConnection = oConn

objCmd.CommandText = strInsert

objCmd.Execute’ Close and dereference database objects

Set objCmd = Nothing

oConn.Close

%>

Error is occuring on this command line, " objCmd.Execute "

Thanks. Sadık.

2

Subject: Data Insert Problem NotesSql using Asp

Exactly what the error message is stating, you cannot modify information in the rows of a view, you have to modify it’s underlying document. Read the documentation for more information on how to get the document.

3

Subject: Data Insert Problem NotesSql using Asp

You are trying to insert a record into ASP instead of notes.