连接access出错,找不到可安装的ISAM
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
请教
------解决方案--------------------
;User Id=admin;Password=; User Id=admin;Password=; ";
------------------
重复了
[解决办法]
"provider=microsoft.jet.oledb.4.0;data source=SaleWater.mdb;Persist Security Info=False;Jet OLEDB:Database Password=123 "
[解决办法]
conn.ConnectionString= "Provider=Microsoft.Jet.OLEDB.4.0;DataSource= "+Server.Mappth( "myData.mdb ")+ ";User Id=admin;Password=; ";
你这样再试试
myData.mdb它要与那个页面在同一目录下
[解决办法]
你自己下载个 MDAC_27.EXE 安装一下看看
