Click here to Skip to main content
12,817,318 members (40,059 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB Access VB.NET
I developed one application using, database as access database and Operating System Windows xp 32 bit. When I installed that software on windows xp and 7 32 bit its working fine. but when I installed it on windows 7 64 bit, it installs on that, but at the time of connecting to the database I got an error 'Provider not found'.
How to connect access database to application in 64 bit OS. Which are the drivers required for that. Is ADODB support to 64 bit
Posted 26-Nov-12 2:32am
Updated 19-Dec-12 20:02pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Oledb 4.0 provider not suported by Win 64 bit

but you can set your project configuration on X86 to run your application on win 64 and 32
Ahmed_online 14-Dec-12 2:50am
Write your connection string and your problem
smiths3 14-Dec-12 3:12am
str_con = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=" + strdbpth + ";" & _
"Persist Security Info=True;"
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Check your provider variable/value i think in access the provider could have been any one of a few like ODBC OLEDB or ADODB and in server 2008 it might not be be the same

Maybe this page here can help point you in the right direction
smp 234 27-Nov-12 0:38am
provider not found microsoft.jet.oledb.4.0
This error is thrown at the time of database connection...
Zaf Khan 27-Nov-12 2:45am
Have a look at the last post on this forum thread there maybe a possible solution for you...

let me know how you got on

Thank you
smp 234 27-Nov-12 3:53am
I want that project run on windows xp,7 and windows server 2008 .
How to make it compatible so the it run on any system..
Zaf Khan 28-Nov-12 21:48pm
The operating systems you mentioned, please can you tell me are they all 32bit or maybe 64bit or is one different different from the other two?
smiths3 30-Nov-12 1:28am
64 bit
Zaf Khan 30-Nov-12 3:54am
Hello Excuse me for being simple,
is user smp234 the same person as user smiths3?
or is it a cross post?
smiths3 10-Dec-12 4:59am
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

if you are using C# this the correct ConString

string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source =" + Application.StartupPath + "\u005C"+ "DbName.mdb";
OleDbConnection Con = new OleDbConnection(ConStr);

if you Are usign the this the correct ConString

Dim ConStr As String = "provider = microsoft.jet.oledb.4.0;Data source =" & Application.StartupPath & "\Dbname.mdb"
Dim con As New OleDbConnection(ConStr)
smiths3 14-Dec-12 6:54am
Public con As New ADODB.Connection

str_con = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=" + strdbpth + ";" & _
"Persist Security Info=True;"
Ahmed_online 14-Dec-12 9:51am
you are using AdoDb connection i thought that you are using Oledb
See All Connection Sting here
smiths3 15-Dec-12 3:34am
I know that site. I changed that connection but still problem remains same.
I think its problem of drivers not connection string. But I don't know which drivers I have to install on 64 bit.
Ahmed_online 15-Dec-12 3:43am
Sorry I have NO Edia about ADODB connection < I can help you about Oledb

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170308.1 | Last Updated 20 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100