疑难解答找不到可安装的ISAM错误 [英] Troubleshooting Could not find installable ISAM error
问题描述
我安装了32位MS Office 2013,以及可再发行的32位Office和一个小型c#控制台应用程序,该应用程序将编译为32位.
I have 32-bit MS Office 2013 Installed, along with the 32-bit office redistributable and a small c# console application set to compile to 32-bit.
以下代码导致出现OleDbException
,指出找不到可安装的ISAM".
The following code causes an OleDbException
stating "Could not find installable ISAM."
public void GetData()
{
var fileName = @"c:\temp\Sales DataBase_Test.accdb";
var connection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Soure='" + fileName + "'";
using (var conn = new OleDbConnection(connection))
{
conn.Open();
conn.Close();
}
}
我想知道的是,不是随机从十几个模糊的答案中应用解决方案,而是
Instead of randomly applying solutions from a dozen vague answers, I'd like to know:
- 这实际上意味着什么?
- 什么是可安装的ISAM?
- 如何获取它们的列表?
- 我如何知道哪些可用?
- 最后,我如何知道任何给定机器上都可以使用哪些提供程序?
- 是否可以枚举这些内容并正确排除故障?
推荐答案
我的问题原来是眼睛和肥胖的手指老化:数据源"被拼写为数据源".
My issue turned out to be aging eyes and fat fingers: "Data Source" was misspelled as "Data Soure".
这不能回答我的问题,但可以帮助其他人.通过在Excel中链接数据,然后复制和粘贴,然后删除不需要的内容,我生成了一个有效的连接字符串.
This doesn't answer my questions, but may help someone else. I generated a working connection string by linking the data in Excel and then copying and pasting and then removing what I didn't need.
-
从访问中获取数据(选择任何表).
Get data from access (pick any table).
下一步打开连接.
然后您可以查看连接的属性,并复制一个有效的连接字符串,然后将其粘贴到代码中并进行编辑.
You can then look at the properties of the connection and copy a working connection string which you can paste into your code and edit.
这篇关于疑难解答找不到可安装的ISAM错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!