连接到数据库时，64位操作系统上找不到提供程序错误 [英] provider not found error on 64 bit OS at the time of connecting to the database

问题描述

我使用VB.net开发了一个应用程序，数据库作为访问数据库和操作系统Windows xp 32位。当我在Windows XP和7位上安装该软件时，其工作正常。但是当我在Windows 7 64位上安装它时，它安装在那上面，但在连接到数据库时我收到错误''找不到提供者''。

如何连接访问数据库到64位操作系统的vb.net应用程序。这需要哪些驱动程序。 ADODB是否支持64位

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

推荐答案

Oledb 4.0提供程序未被Win 64位支持



但是你可以在X86上设置您的项目配置以在win 64和32上运行您的应用程序

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

检查您的提供者变量/值我认为在访问中提供者可能是ODBC OLEDB之类的任何一个或ADODB和服务器2008中它可能不一样



也许这里的页面可以帮助您找到正确的方向

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

如果您正在使用C＃这是正确的ConString



string ConStr =Provider = Microsoft.Jet.OLEDB.4.0; Data source =+ Application.StartupPath +\ 00005C+DbName.mdb;

OleDbConnection Con = new OleDbConnection（ConStr）;

Con.Open（）;

MessageBox.Show（open）;





如果您使用VB.net这是正确的ConString

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")

这篇关于连接到数据库时，64位操作系统上找不到提供程序错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！