连接access出错,找不到可安装的ISAM

[cherishahu]

using System;

using System.Text;
using System.Data;
using System.Data.OleDb;


namespace ConsoleApplication45
{
class Program
{
static void Main(string[] args)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\\database\\myData.mdb;User Id=admin;Password=; User Id=admin;Password=;";

try
{
conn.Open();
Console.WriteLine("Connection opened");
//Display connection properties

Console.WriteLine("Connection Properties:");
Console.WriteLine("\t Connection String :{0}", conn.ConnectionString);
Console.WriteLine("\tDatbase :{0}", conn.Database);
Console.WriteLine("\tDataSource:{0}", conn.DataSource);
}
catch (OleDbException e)
{
Console.WriteLine("Error" + e.Message);
}
finally
{
conn.Close();
}

}

}
}
执行: Error找不到可装的ISAM
请教

[dazhu2]

;User Id=admin;Password=; User Id=admin;Password=;";
------------------
重复了

[cherishahu]

去掉了还是不行啊.

[cherishahu]

报同样的错误.

[sz709]

"provider=microsoft.jet.oledb.4.0;data source=SaleWater.mdb;Persist Security Info=False;Jet OLEDB:Database Password=123"

[xiaofengnet]

conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+Server.Mappth("myData.mdb")+";User Id=admin;Password=;";
你这样再试试
myData.mdb它要与那个页面在同一目录下

[dazhu2]

你自己下载个 MDAC_27.EXE 安装一下看看

[qipeng2qipeng]

DataSource要分开写Data Source

[kinglonleung]

using System;

using System.Text;
using System.Data;
using System.Data.OleDb;


namespace ConsoleApplication45
{
class Program
{
static void Main(string[] args)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString= "Provider=Microsoft.Jet.OLEDB.4.0;Data"空一格"Source=D:\\database\\myData.mdb;User Id=admin;Password=; User Id=admin;Password=; ";

try
{
conn.Open();
Console.WriteLine( "Connection opened ");
//Display connection properties

Console.WriteLine( "Connection Properties: ");
Console.WriteLine( "\t Connection String :{0} ", conn.ConnectionString);
Console.WriteLine( "\tDatbase :{0} ", conn.Database);
Console.WriteLine( "\tDataSource:{0} ", conn.DataSource);
}
catch (OleDbException e)
{
Console.WriteLine( "Error " + e.Message);
}
finally
{
conn.Close();
}

}

}
}

仔细看哦！！！！！！

[zwamm]

最好是先下一个MDAC 2.8，试试～～

[lihonst]

我在操作是也出现这种错误，我整了好长时间，后来才发现Access数据库没有关，如果把数据库关掉，这个错误就解决了！

[yis74839]

data source 分开写，亲测可用。