provider not found error on 64 bit OS at the time of connecting to the database

Question

0.00/5 (No votes)

See more:

I developed one application using VB.net, 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 vb.net application in 64 bit OS. Which are the drivers required for that. Is ADODB support to 64 bit

Posted 26-Nov-12 1:32am

dcba1

Updated 19-Dec-12 19:02pm

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Ahmed_online · Answer 1 · 2012-12-13T03:16:00

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

Posted 13-Dec-12 3:16am

Ahmed_online

Updated 13-Dec-12 3:19am

v3

Comments

Ahmed_online 14-Dec-12 2:50am

Write your connection string and your problem

dcba1 14-Dec-12 3:12am

str_con = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=" + strdbpth + ";" & _
"Persist Security Info=True;"

Zaf Khan · Answer 2 · 2012-11-26T01:42:00

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

Posted 26-Nov-12 1:42am

Zaf Khan

v2

Comments

dcba1 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...

http://forums.ni.com/t5/LabVIEW/Microsoft-Jet-4-0-OLE-DB-Provider-Windows-7-64Bit/td-p/1051410

let me know how you got on

Thank you

dcba1 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?

dcba1 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?

dcba1 10-Dec-12 4:59am

same

Ahmed_online · Answer 3 · 2012-12-14T00:52:00

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);
Con.Open();
MessageBox.Show("open");

if you Are usign the VB.net this the correct ConString

VB

Dim ConStr As String = "provider = microsoft.jet.oledb.4.0;Data source =" & Application.StartupPath & "\Dbname.mdb"
Dim con As New OleDbConnection(ConStr)
con.Open()
MsgBox("open")

Posted 14-Dec-12 0:52am

Ahmed_online

Comments

dcba1 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;"
con.Open(str_con)

Ahmed_online 14-Dec-12 9:51am

you are using AdoDb connection i thought that you are using Oledb
See All Connection Sting here

http://www.connectionstrings.com/

dcba1 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