通过OLEDB连接到ACCDB格式的MS-ACCESS数据库 [英] Connecting to ACCDB format MS-ACCESS database through OLEDB
问题描述
我最近做另一个问题有关连接到MS-ACCESS数据库 .NET C#或VB.NET。它的工作就像打算与MDB,但ACCDB就引起了异常
I've recently made another question about connecting to MS-ACCESS database with .NET in C# or VB.NET. It worked just as intended with MDB, but with accdb it caused an exception in
conn.Open();
这如下:
有另一种方式做到这一点?我的初衷(如在原来的问题说明)正在收集一些(实际上,一很多领域)。
Is there another way to do this? My original intention (like stated in the original question) is gathering some (actually, a lot of) fields.
推荐答案
使用ACE 4驱动程序,下载<一个href="http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en">here然后使用下面的连接字符串:
Use ACE 4 driver, download it here then use following connection string:
提供程序= Microsoft.ACE.OLEDB.12.0;数据源= C:\ marcelo.accdb;喷射OLEDB:数据库密码= MyDbPassword;
这篇关于通过OLEDB连接到ACCDB格式的MS-ACCESS数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!