Microsoft.Data.OleDb & windows 2000 server

[Simon Parker]

Hello,

I was wondering if anyone here could assist me. I've developed a small
app in C# which connects to an Access 2000 Database and converts it to mySQL
which will go open source when I've finished error testing. I've
successfully deployed this application on a number of Windows XP and Windows
2000 machines (7 or 8), however when deploying the application on Windows
2000 Server the application fails each time it tries to connect to a
database with this connection string:

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data\be.mdb;";

However, each time the connection fails and yet when I catch
System.Exception and OleDBExceptions a blank error message is returned
making it very difficult to find the source of the problem. I've tried
installing MDAC 2.7 on the server but this doesn't seem to resolve anything.

Does anyone have any suggestions?

Thanks,

sparkydev@hotmail<pleasenospam!>.com

 

[Nicholas Paldino [.NET/C# MVP]]

Simon,

Have you checked the ErrorCode property? What is that?

Also, the Errors property might have information about multiple errors
that occured during the operation. Because of this, you should check to see
how many errors there are and check the individual errors from there.

Hope this helps.