Visual Studio 2008中的Con.open（）错误 [英] Con.open() error in visual studio 2008

问题描述

我有一个很长的代码，它从较旧的Microsoft访问数据库中获取研究数据，并运行一个研究程序来获取数据并吐出一些计算等。我通过Microsoft访问.mdb文件运行它，我最近升级到更新的访问数据库.accdb文件。如何在visual studio中更新我的数据源，以便我不会收到con.Open错误，它将转到新的.accdb目标？



我尝试了什么：



我尝试将程序拍摄到新的访问数据库，但总是会出现错误。我已经尝试过编辑它并重新配置它，但我遗漏了一些东西。任何反馈都将不胜感激。

I have a long code that takes research data from an older Microsoft access database and runs a research program that takes the data and spits out some calculations and such. I ran it through a Microsoft access .mdb file and I recently upgraded to a newer access database .accdb file. How can I update my data sources in visual studio so that I do not receive a con.Open error and it will go to a new .accdb target?

What I have tried:

I tried shooting the program to the new access database but an error always comes back. I have tried editing it and reconfiguring it but I am missing something. Any feedback would be appreciated.

推荐答案

猜测 - 这就是你所提供给我们的信息缺乏的全部 - 你过去常常使用JET不支持ACCDB数据库。您需要将连接字符串（和已安装的数据库引擎）切换到ACE并为您的应用程序安装正确的版本（32或64位）。

At a guess - and that's all it can be with the lack of information you have given us - you used to use JET which doesn't support ACCDB databases. You need to switch the connection string (and installed db engine) to ACE and install the right version (32 or 64 bit) for your app.

这篇关于Visual Studio 2008中的Con.open（）错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！