MVC 32 bit application

Question

Hi,

I have an 32 bit MVC application which compare two ecel sheet and generate a report. Its working fine in local.But when its get published and accessed from different machine which is having Visual Studio its working.But system whis is not having visual studio,its not working.I am not able to trace where I am wrong.Please help me out.

---

Shubho

Answer 1

Please define "not working".

• Is there an exception being generated somewhere that you could share or maybe there is something in the event log.
• If this has something to do with an IIS error or other web site related exception being generated or web site not loading then you should post your question at Asp.Net Forums.

---

-Igor

Answer 2

MVC issues you be addressed at the MVC section main the ASP.NET forum.

http://forums.asp.net/

Answer 3

Hi,

I am getting following error:-

 'microsoft.ace.oledb.12.0' provider is not registered on the local machine.

---

Shubho

Answer 4

You using Access with an MVC solution is a problem out the gate. Access is not a mutil user database solution for a Web application, and I see database corruption problems for you if multiple users are hitting the Access database concurrently using the MVC solution. You should be using at the very least MS SQL Server Express with the database file attached to the SQL Server database engine that allows concurrent user access.

Answer 5

Hi,

try to install all updates for the host.

or install VS and remove it.

It can be a problem with .NET FRAMEWORK VERSION or Missed DLLs

Answer 6

You need to install/register the connectivity components so that you can open a connection to the excel spread sheets. You will need to download and install the correct driver. Based on your error message it probably could be resolved with this: Microsoft 2007 Access Driver.

If that does not work just google your error message you provided above, I immediatly received these 2 links that are also of interest. More help can be given if you also include your connection string and what version of Excel you are trying to use to open the files (ie. xls or xlsx).

• Provider not registered
  
• Stackoverflow - same question/answer

---

-Igor

Answer 7

Hi,

try to install all updates for the host.

or install VS and remove it.

It can be a problem with .NET FRAMEWORK VERSION or Missed DLLs

@Ismaiel: Based on the OP's response it is most likely caused by a missing ole driver that was never installed. 

It probably has nothing to do with updates, or an incorrect .net framework installation. Also why would anyone install Visual Studio (and then also later remove it) on a client or IIS host machine?

These suggestions do nothing more than create a run around for the OP and provide no insight or direction to what the problem is.

---

-Igor

Answer 8

Hi,

I am getting following error:-

 'microsoft.ace.oledb.12.0' provider is not registered on the local machine.

---

Shubho

Hi Shubho,

I have made this error before. Referfing this discussion helped me a lot.

Please also take a look.

HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"

Best regards,

Kristin

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 9

I am using two connection string for .xls and .xlsx

connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
                        path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";

connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
                        path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";

---

Shubho

Answer 10

Hi Shubho,

You will need to download and install the access driver which can be found here.

Microsoft Access Database Engine 2010 Redistributable

That will fix the exception you are getting.

---

-Igor