Click here to Skip to main content
15,851,387 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear
I am using Asp.net and c#. When i upload a MS Access db to program the error occurs like "Provider is Not Registered on the Local Machine". Please note that in 32 bit system working pakka.
but in 64x bit, the above error shows.

I have applied code:
C#
String connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;"
             + @"Data Source=" + Server.MapPath(Path );


Please help me...


Urgent

Thanks

Prince
Posted

1 solution

Hello,

For x64 OS Machine you can download Microsoft Access Database Engine 2010 Redistributable. You can use one of the following connections strings with this driver.
ODBC - Driver={{Microsoft Access Driver (*.mdb, *.accdb)}};Dbq=YOUR_MDB_FILE_FULL PATH_AND_NAME;Uid=Admin;Pwd=;

OleDb - Provider=Microsoft Office 12.0 Access Database Engine OLE DB Provider;Data Source=YOUR_MDB_FILE_FULL PATH_AND_NAME;User Id=admin;Password=;

Regards,
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900