Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 952
  • Last Modified:

CONNECTION STRING ACCESS (MDB) WIN 7 64 BIT

Hi All,

I try to access mdb (access database) from application:

1. I have install AccessDatabaseEngine.exe
2. I have install AccessDatabaseEngine_x64.exe

I use connection string :

1.  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdlGlobal.strDataAbsensiPath
2.   "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & mdlGlobal.strDataAbsensiPath

Both failed.

What should I do ?

Thank you.
0
emi_sastra
Asked:
emi_sastra
  • 3
  • 3
1 Solution
 
emi_sastraAuthor Commented:
Hi  pratima_mcs,

Still not found the solution.

Thank you.
0
 
Pratima PharandeCommented:
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
emi_sastraAuthor Commented:
The message is :

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

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

Thank you.
0
 
emi_sastraAuthor Commented:
Great.

It solved with :

in the properties of your VB application, go to advanced compile options and choose CPU target: x86

Thank you very much for your help.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now