J
Jeff0803
Guest
I'm trying to connect MS Access DB using following connection string but "The Microsoft.ACE.oledb.12.0 provider is not registered on the machine" error occur.
sConnectionString = "Provider=Microsoft.ACE.oledb.12.0; Data Source=" + @"C:\CSharpSample\UserManage\data\remsys.mdb;User Id=admin; Jet OLEDB;Database Password=abcdefg;";
If I use "Microsoft.Jet.OLEDB.4.0", "Could not find installable ISAM" error occurs.
Because ACE.OLEDB doesn't support 64bit platform, I changed it to x86 from Visual studio 2005 like following.
My OS is Windows 10 64bit and Office 64bit is installed.
How can I solve this issue?
Continue reading...
sConnectionString = "Provider=Microsoft.ACE.oledb.12.0; Data Source=" + @"C:\CSharpSample\UserManage\data\remsys.mdb;User Id=admin; Jet OLEDB;Database Password=abcdefg;";
If I use "Microsoft.Jet.OLEDB.4.0", "Could not find installable ISAM" error occurs.
Because ACE.OLEDB doesn't support 64bit platform, I changed it to x86 from Visual studio 2005 like following.
My OS is Windows 10 64bit and Office 64bit is installed.
How can I solve this issue?
Continue reading...