Click here to Skip to main content
12,252,407 members (62,776 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB Access VB.NET
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
dcba1894
Edited 19-Dec-12 19:02pm
v3
Rate this: bad
 
good
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
  Permalink  
v3
Comments
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
 
good
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
  Permalink  
v2
Comments
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...

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
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
   
same
Rate this: bad
 
good
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);
Con.Open();
MessageBox.Show("open");


if you Are usign the VB.net 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)
con.Open()
MsgBox("open")
  Permalink  
Comments
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;"
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/
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.160426.1 | Last Updated 20 Dec 2012
Copyright © CodeProject, 1999-2016
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