I have the following problem:
I'm trying to create an application to insert data into lotus notes nsf bases by an application of C #. So far I have this:
private void button2_Click(object sender, EventArgs e)
{
bool isServerData = radioButton1.Checked;
// Set up connection string
string connString = ("Driver=Lotus NotesSQL Driver (*.nsf);" + ("Server=" + textBox1.Text + ";" + "Database=C:\\Archivos de programa\\Lotus\\notes\\data\\clientes\\… + "UserName = 192.168.*.*" +";" + "Password= "+ textBox2.Text + "" ));
string CmdString = "SELECT * FROM Contactos";
OdbcConnection Conn = null;
OdbcDataReader Reader = null;
OdbcDataAdapter adaptador = new OdbcDataAdapter();
DataTable contactos;
string con = connString;
//string sel = ("INSERT INTO Contactos (_126, _21, _19, _20) VALUES(?, ?, ?, ?) ");
string sel = "INSERT INTO Contactos (_126, _21, _19, _20) VALUES('Luisa', '[email protected]', '55555555', 'programador')";
try
{
// Open Connection

/***************************************…
Conn = new OdbcConnection(connString);
Conn.Open();

// Execute Query
OdbcCommand Cmd = new OdbcCommand(CmdString, Conn);
adaptador = new OdbcDataAdapter(Cmd);
contactos = new DataTable();
adaptador.Fill(contactos);
adaptador.SelectCommand = Cmd;
**********************************/
Conn = new OdbcConnection(connString);
Conn.Open();
OdbcCommand Cmd = new OdbcCommand(sel, Conn);
//OdbcCommand Dmd = new OdbcCommand(sel, Conn);
//Cmd.Parameters.AddWithValue("@_126", "Luisa");
//Cmd.Parameters.AddWithValue("@_21", "[email protected]");
//Cmd.Parameters.AddWithValue("@_19", "55555555");
//Cmd.Parameters.AddWithValue("@_20", "programador");
//adaptador.InsertCommand = Dmd;
////Dmd.Dispose();
Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
error = (ex.Message);
}
finally
{
Conn.Close();
}

}
Make the following error:
System.Data.Odbc.OdbcException was detected
Message="ERROR [HY000] [Lotus][ODBC Lotus Notes]No INSERT/UPDATE/ALTER/CREATE INDEX/CREATE VIEW on view"
Source="NSQLV32.DLL"
ErrorCode=-2146232009
StackTrace:
en System.Data.Odbc.OdbcConnection.HandleEr… hrHandle, RetCode retcode)
en System.Data.Odbc.OdbcCommand.ExecuteRead… behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
en System.Data.Odbc.OdbcCommand.ExecuteRead… behavior, String method, Boolean needReader)
en System.Data.Odbc.OdbcCommand.ExecuteNonQ…
en LOTUS.Form1.button2_Click(Object sender, EventArgs e) en D:\Respaldos\Ejemplos Devexpress y c#\LOTUS\LOTUS\Form1.cs:l*nea 82
InnerException:


Thank you very much and sorry for the inconvenience.