Connecting to Access Database with Sharepoint

Question

i'm trying to connect to an Access Database which is located on the desktop's server. I tried this :

DatabaseAcces dbSAP = new DatabaseAcces(@"Provider=Microsoft.Jet.OLEDB.4.0;Data   Source=C:\\Users\\adm_sharepoint\\Desktop\\PPMO\\BDD-Access\\BDD_PPMO_SAP.accdb");
DataSet dsCarneOffre = dbSAP.executeQuery("SELECT * FROM CarnetOffres");

And I try to connect with this function :

private void connexionOpen(){
        connect = new OleDbConnection(connexionString);
        connect.Open();
}

But when i arrive to the line

connect.Open()

i get this error :

"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine." Source="System.Data"

Do you guys have any idea what to do ? Thanks

Per Jakobsen · Accepted Answer · 2012-06-04 16:59:06Z

1

SharePoint is 64 bit code and can't call 32 bit libraries.

Jet is only 32-bit see How to get a x64 version of Jet?

But you may be able to use Microsoft Access Database Engine 2010 Redistributable

answered Jun 4, 2012 at 16:59

Per Jakobsen

32.4k1 gold badge35 silver badges62 bronze badges

Thanks for this answer. I think i'll use sql server then.

Thoma Bigueres
– Thoma Bigueres

2012-06-04 17:05:59 +00:00
Commented Jun 4, 2012 at 17:05
That's an EXCELLENT choice

Per Jakobsen
– Per Jakobsen

2012-06-04 18:44:55 +00:00
Commented Jun 4, 2012 at 18:44

Add a comment |

Stack Exchange Network

Connecting to Access Database with Sharepoint

1 Answer 1

Your Answer

Hot Network Questions

Connecting to Access Database with Sharepoint

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions