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

Posted 26 Nov '12 - 1:32

Edited 19 Dec '12 - 19:02

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

Posted 13 Dec '12 - 3:16

Ahmed_online906

Edited 13 Dec '12 - 3:19

Comments

Ahmed_online - 14 Dec '12 - 2:50

Write your connection string and your problem

smiths3 - 14 Dec '12 - 3:12

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

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

Posted 26 Nov '12 - 1:42

Zaf Khan2.2K

Comments

smp 234 - 27 Nov '12 - 0:38

provider not found microsoft.jet.oledb.4.0 This error is thrown at the time of database connection...

Zaf Khan - 27 Nov '12 - 2:45

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:53

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:48

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:28

64 bit

Zaf Khan - 30 Nov '12 - 3:54

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:59

same

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

Posted 14 Dec '12 - 0:52

Ahmed_online906

Comments

smiths3 - 14 Dec '12 - 6:54

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:51

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:34

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:43

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)

0	OriginalGriff	318
1	Sergey Alexandrovich Kryukov	143
2	Mohammed Hameed	123
3	Santhosh G_	108
4	Lohith Korupolu	85

0	Sergey Alexandrovich Kryukov	8,266
1	OriginalGriff	6,306
2	CPallini	3,528
3	Rohan Leuva	2,703
4	Maciej Los	2,234

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

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

		9,879,344 members (39,198 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Interested
Ignored

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

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us