Error on working with database with vb.net

0
votes

I am working on vb.net application in which i am working on making crystals reports. I am database as Ms-Access.I did following to open the connection of Ms-Access:

Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; data source=database.mdb")
con.open()

but when controls comes to con.open(), it shows the following error:

The 'Microsoft.Jet.Oledb.4.0' provider is not registered on the local machine

Can anyone help me.

2
vb.netms-access
i got my answer.thanks – Sunny Sandeep
Please create an answer for this question so that others can benefit from what you learned. – Gord Thompson

2 Answers

1
votes

The Answer what i have found to my above asked question is discussed below:

Actually Microsoft.Jet.Oledb.4.0 not work for 64Bit machine.

So, it would be better to use Microsoft.ACE.OLEDB.12.0 for 64 bit system. Before to use we should check is it 32 bit or 64 bit system. If the system is 32 bit then use .JET.OLEDB else use ACE.OLEDB.

The following link can be preffered for downloading AccessDatabaseEngine

http://www.microsoft.com/download/en/details.aspx?id=13255

I hope it may help someone.

1
votes

Microsoft.Jet.OLEDB.4.0 provider is not 64-bit compatible. You can compile your application changing platform target from 'Any CPU' to 'x86'.