Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Really Strange ADO Error
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
Really Strange ADO Error
Miscellaneous
Thread ID:
01446444
Message ID:
01446444
Views:
131
I'm trying get a DS of some data from an Access DB using C#.
string AccessConnString = @"Provider=Microoft.Jet.OLEDB.4.0;Data Source=C:\Projects\Sales Quote\Database\Orig\quotedb 9-27.mdb";
OleDbConnection AccessConn = new OleDbConnection();
AccessConn.ConnectionString = AccessConnString;

try
{
    AccessConn.Open();
}
catch (Exception e)
{
    throw e;
}

OleDbCommand oCommand = new OleDbCommand();
oCommand.CommandText = "select * from vendors";
oCommand.Connection = AccessConn;

OleDbDataAdapter AccessDA = new OleDbDataAdapter();
AccessDA.SelectCommand = oCommand;

DataSet dsAccess = new DataSet();
AccessDA.Fill(dsAccess, "Vendors");
This exceptions on the Open with the following: The 'Microoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

1) I have been doing this on this PC for weeks. Why this errors now I don't get.
2) Notice that 'Microsoft' is mispelled.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform