Help: System.Data.Ole Db.OleDbExcepti on Error

[G.Esmeijer]

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.Ole Db.OleDbExcepti on' 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.Connec tionString = @"Provider=Micr osoft.Jet.OLEDB .4.0; Data
source= C:\Scorwin\data \Data.mdb";

cnnSCORE.Open() ;

OleDbCommand cmdSQL = new OleDbCommand(sS QL, cnnSCORE);

OleDbDataReader sdrSCORE = cmdSQL.ExecuteR eader();

/// code that is making some calculations -> result

CnnSCORE.Close( );

return result

}

Regards

gerrit esmeijer

(Netherlands)

[Frans Bouma [C# MVP]]

G.Esmeijer wrote:

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.Ole Db.OleDbExcepti on' 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.Connec tionString = @"Provider=Micr osoft.Jet.OLEDB .4.0; Data
source= C:\Scorwin\data \Data.mdb";

cnnSCORE.Open() ;

OleDbCommand cmdSQL = new OleDbCommand(sS QL, cnnSCORE);

OleDbDataReader sdrSCORE = cmdSQL.ExecuteR eader();

/// code that is making some calculations -> result

CnnSCORE.Close( );

return result

}

enclose the ExecuteReader() statement with a try/catch clause andCatch the
OleDbException. In that exception, you'll find an Errors collection which
contains the actual error. See the OleDbException docs for details. By
checking this collection, you can determine what's wrong.

FB
--
Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP

[G.Esmeijer]

Frans,

Thanks for your reply... however, in spite of the fact that I have done what
you suggested, this error is not caught by the try catch construction. I
keeps pointing at the same line and the error is not caught. Thanks anyway

Gerrit Esmeijer
"Frans Bouma [C# MVP]" <pe************ ******@xs4all.n l> schreef in bericht
news:xn******** *******@msnews. microsoft.com.. .

G.Esmeijer wrote:

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.Ole Db.OleDbExcepti on' 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.Connec tionString = @"Provider=Micr osoft.Jet.OLEDB .4.0; Data
source= C:\Scorwin\data \Data.mdb";

cnnSCORE.Open() ;

OleDbCommand cmdSQL = new OleDbCommand(sS QL, cnnSCORE);

OleDbDataReader sdrSCORE = cmdSQL.ExecuteR eader();

/// code that is making some calculations -> result

CnnSCORE.Close( );

return result

}

enclose the ExecuteReader() statement with a try/catch clause andCatch the
OleDbException. In that exception, you'll find an Errors collection which
contains the actual error. See the OleDbException docs for details. By
checking this collection, you can determine what's wrong.

FB
--
Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP

[Frans Bouma [C# MVP]]

G.Esmeijer wrote:

Frans,

Thanks for your reply... however, in spite of the fact that I have done what
you suggested, this error is not caught by the try catch construction. I
keeps pointing at the same line and the error is not caught. Thanks anyway
What's the code after you've enclosed the code with try/catch statements? If
the code you originally posted throws an OleDbException, it has to end up in
the catch. Did you position the try statement at the right spot? Could you
post that snippet with the try/catch?

Frans.

Gerrit Esmeijer
"Frans Bouma [C# MVP]" <pe************ ******@xs4all.n l> schreef in bericht
news:xn******** *******@msnews. microsoft.com.. .

G.Esmeijer wrote:

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.Ole Db.OleDbExcepti on' 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.Connec tionString = @"Provider=Micr osoft.Jet.OLEDB .4.0; Data
source= C:\Scorwin\data \Data.mdb";

cnnSCORE.Open() ;

OleDbCommand cmdSQL = new OleDbCommand(sS QL, cnnSCORE);

OleDbDataReader sdrSCORE = cmdSQL.ExecuteR eader();

/// code that is making some calculations -> result

CnnSCORE.Close( );

return result

}

enclose the ExecuteReader() statement with a try/catch clause andCatch the
OleDbException. In that exception, you'll find an Errors collection which
contains the actual error. See the OleDbException docs for details. By
checking this collection, you can determine what's wrong.

--
Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP