注册 登录
编程论坛 ASP技术论坛

ASP 连接不上access

bobowang 发布于 2013-07-22 18:14, 624 次点击
连接时  提示有异常,conn。open() 找不到可以安装的ISAM?
这个怎么解决啊,百度的方法,完全看不懂
3 回复
#2
hu9jj2013-07-22 20:56
连接代码呢?
#3
bobowang2013-07-22 21:39
OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString ="Provider=Microsoft.Jet.OLEDB.4.0; Datasoure= " + Server.MapPath("huiyishi.mdb");
        conn.Open();//异常出现行,未找到可安装的ISAM
        string sql="select * from shqrTABLE";
        OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        da.Fill(ds,"table");
        GridView1.DataSource = ds.Tables["table"].DefaultView;
        GridView1.DataBind();
#4
hu9jj2013-07-23 07:22
试试下面的连接代码:
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("huiyishi.mdb")
1