MSDN is not the best in explaining that type of error. I keep getting this. I looked if my Jet engines was installed correctly and everything looks fine in my registry.
May be I am doing something wrong in my code ?
The errors is when I open the connection (in the beginning), so I am wondering if my connection string is ok.Code:public const string DB_CONN_STRING = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @" DataSource=D:\\Documents\\Visual Studio 2005\\Projects\\WindowsApplication2\\db_RFID_OIC.mdb"; public void InsertDBLogTag() { OleDbConnection conn = new OleDbConnection(DB_CONN_STRING); conn.Open(); // SQL command String sSQLCommand = "INSERT INTO LogTag (Date, Puce, Cle_bureau, Cle_couloir, Cle_cargaison, Poids, Poste) " + "VALUES( '2001/12/25 20:30:15', '55', 1, 3, 2, 134, 1 );"; // Create the command object OleDbCommand cmdAdder = new OleDbCommand(sSQLCommand, conn); // Execute the SQL command int nNoAdded = cmdAdder.ExecuteNonQuery(); // Close the connection conn.Close(); }
thank you for helping me




Reply With Quote