找不到可用的ISAM
本文关键字:ISAM 找不到 | 更新日期: 2023-09-27 18:06:01
OleDbConnection connect = new OleDbConnection ("Provider=Microsoft.ACE.OLEDB.12.0;Data source:C:''Users''PC''Documents''Visual Studio 2013''Projects''WindowsFormsApplication1''WindowsFormsApplication1''Firebird damagem0.accdb;Persist Security Info=False");
public partial class Form3 : Form
{
// OleDbconnection database
OleDbConnection connect = new OleDbConnection ("Provider=Microsoft.ACE.OLEDB.12.0;Data source:C:''Users''PC''Documents''Visual Studio 2013''Projects''WindowsFormsApplication1''WindowsFormsApplication1''Firebird damagem0.accdb;Persist Security Info=False");
public Form3()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
// Set up command
connect.Open();
OleDbConnection command = new OleDbConnection("SELECT [Damage columns], ID FROM [Copy of Firebird m0 damage]; connection");
command.ExecuteNonQuery();
DataTable ds = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter (command);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
comboBox3.Items.Add(dr["[Damage columns]"].ToString());
}
connect.Close();
}
connection . open()出错;我做的一切都是对的,但我仍然收到错误,有什么建议吗?
此错误通常是由无效的连接字符串引起的。
由于数据源路径中有一个空格,请尝试用单引号将其括起来。另外,它应该是
Data Source=
不Data Source:
您的连接字符串看起来是错误的,在数据源后面有一个分号。
OleDbConnection connect = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data source=C:'Users'PC'Documents'Visual Studio 2013'Projects'WindowsFormsApplication1'WindowsFormsApplication1'Firebird damagem0.accdb;Persist Security Info=False");
你也有另一个OleDbConnection在那里的代码应该是OleDbCommand。最后,你安装access数据库引擎了吗?
我刚刚设法凭空产生了一个非常类似的错误(它以前工作过),经过一段时间的挖掘,我改变了什么,从那时起,我终于找到了错误:
Provider=Microsoft.Jet.OleDb.4.0;Data Source=myfile.mdb
工作,而
Provider=Microsoft.Jet.OleDb.4.0;DataSource=myfile.mdb
生产
Installable ISAM not found
对于那些没有看到它的人:区别在于关键字Data Source
和DataSource
的拼写-空格字符在这里很重要!