Friends,
The following code works fin. BUT...
after a >> couple times<< this code is used is a class it comes with an
error saying
unhandled System.Data.OleDb.OleDbException' occurred in system.data.dll
Any suggestions what could be wrong.
public int LeesRadSoort( string radcode ) {
string sSQL = "SELECT * FROM Rad WHERE RadCode = '" + radcode + "';";
OleDbConnection cnnSCORE = new OleDbConnection();
cnnSCORE.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data
source= C:\Scorwin\data \Data.mdb";
cnnSCORE.Open();
OleDbCommand cmdSQL = new OleDbCommand(sSQL, cnnSCORE);
OleDbDataReader sdrSCORE = cmdSQL.ExecuteReader();
/// code that is making some calculations -> result
CnnSCORE.Close();
return result
}
Regards
gerrit esmeijer
(Netherlands)