How to install The 'Microsoft.ACE.OLEDB.12.0' provider

Venkata Subbareddy

Hi all,

iam upload the files in Godady server i got error any one give me suggestions.

Server Error in '/' Application.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Source Error:

Line 96: Line 97:

//Get the name of First Sheet Line 98:

connExcel.Open(); Line 99:

DataTable dtExcelSchema; Line 100:

dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

Source File: g:\pleskvhosts\ritsindia.com\muraliiitjeeclasses.com\UploadingtheQuestions.aspx.cs Line: 98

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Bhoir11y ago
Hi,

GoDaddy hosting accounts do not support accessing information from an Excel Database.
Reference from Here :
GoDaddy hosting accounts do not support accessing information from an Excel Database
Microsoft.ACE.OLEDB.12.0' provider is not registered
Godaddy error -The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
In GoDaddy, You can import a CSV file into a MS SQL database, but not a .XLSX file.
0
Nilesh Jadav11y ago
have you check that Database engine is installed or not :

try this link : https://support.godaddy.com/help/topic/58/web-hosting/forum/topic/using-excel-spreadsheets-on-website/

http://forums.asp.net/t/1789972.aspx?+Microsoft+ACE+OLEDB+12+0+provider+is+not+registered+on+the+local+machine+using+web+developer+2010+express

You should ask godady support panel if they are supporting oledb or not : : http://support.godaddy.com/help/1393
0
Venkata Subbareddy11y ago
hi Nilesh, my code working Perfectly But i upload the Godady Server i got this type Error..
0
Nilesh Jadav11y ago
Hello Venkata

Try this link to get some light on the topic : OLEDB Provider is Not Registered on the Local Machine

https://social.technet.microsoft.com/Forums/office/en-US/595a9e94-0144-4afe-8a62-3aa96c3d34f5/re-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine-error?forum=officeitproprevious

http://www.dreamincode.net/forums/topic/274120-microsoftaceoledb120-provider-is-not-registered-on-the-local-mac/

Hope this helps
0
Rajeesh Menoth11y ago
Hi,

Check also this : http://www.codeproject.com/Questions/760355/The-Microsoft-ACE-OLEDB-provider-is-not-registered
0
Venkata Subbareddy11y ago
hi rajesh, my code working on local host perfectly when i upload the godaddy server i got that type of error
0
Rajeesh Menoth11y ago
Hi,

Read this article :

1) http://www.codeproject.com/Tips/417397/OLEDB-Provider-is-Not-Registered-on-the-Local-Mach

2) http://forums.asp.net/t/1971291.aspx?How+to+FIX+Microsoft+ACE+OLEDB+12+0+provider+is+not+registered+on+the+local+machine+URGENT+HELP+NEEDED
0