private void button1_Click(object sender, EventArgs e)
{
string str = "Provider = SQLOLEDB;server = '(local)';database=开奖数据;integrated security = true";
OleDbConnection con = new OleDbConnection(str);
con.Open(); //报错:没有可用的错误消息
}我桌面上有一个Access文件,文件名是:开奖数据
为什么报错呢?
{
string str = "Provider = SQLOLEDB;server = '(local)';database=开奖数据;integrated security = true";
OleDbConnection con = new OleDbConnection(str);
con.Open(); //报错:没有可用的错误消息
}我桌面上有一个Access文件,文件名是:开奖数据
为什么报错呢?
{
string str = "Provider = SQLOLEDB;server = '(local)';database=c:\\documents and settings\\username\\桌面\\开奖数据.mdb;integrated security = true";
OleDbConnection con = new OleDbConnection(str);
con.Open(); //报错:没有可用的错误消息
}
access连接字符串
我复制了桌面的文件地址:
C:\Documents and Settings\Administrator\桌面然后写:
string str = "Provider = SQLOLEDB;server = '(local)';database=C:\\Documents and Settings\\Administrator\\桌面\\开奖数据.mdb;integrated security = true";
其他没改,为什么还是错呢
Provider=Microsoft.Jet.OLEDB.4.0; 这样的吧
出现了新的错误:
多步LOE DB操作产生错误。如果可能,请检查每一个LOE DB状态值........
Provider = SQLOLEDB;
只能使用
Provider=Microsoft.Jet.OLEDB.4.0;另外,你的文件不应该放在桌面上,每个人帐号的桌面是不同的,还要注意,读取数据的sql语句写法
多步OLE DB操作产生错误,如果可能,请检查每个OLE DB状态值
private void button1_Click(object sender, EventArgs e)
{
string str = "Provider=Microsoft.Jet.OleDb.4.0;";
str += "Data Source=";
str += Directory.GetCurrentDirectory() + (@"\开奖数据.mdb");
OleDbConnection con = new OleDbConnection(str);
con.Open(); //报错:没有可用的错误消息
}
数据库与执行程序在同一个目录下
不知对LZ有用不
http://hi.csdn.net/space-8848128-do-album-picid-835569.html 去我这看
{
dbconn.Open();
try
{
OleDbCommand cmd = dbconn.CreateCommand();
string StrSQL = strSQL;
cmd.CommandText = StrSQL;
cmd.CommandType = CommandType.Text;
OleDbDataReader reader = cmd.ExecuteReader();
dbconn.Close(); return "操作成功!"; }
catch (Exception Err)
{
string strMessage = "操作失败:" + Err.Message;
//如果打开了连接,则关闭它
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
return strMessage;
}
}
private OleDbConnection dbconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=databen.mdb");
string str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\ASPPPPPPPPPPPPPP\CSDNCSDN例子\6-15\OnlineMarket.mdb";直接 Data Source 那里写上你数据库的路径就行,刚才我自找麻烦了!
string str = "Provider = Microsoft.Jet.OLEDB.4.0;server = '(local)';database=C:\\Documents and Settings\\Administrator\\桌面\\开奖数据.mdb;integrated security = true";
OleDbConnection con = new OleDbConnection(str);
con.Open();
就是报错
string str = "Provider = Microsoft.Jet.OLEDB.4.0;server = '(local)';database=C:\\Documents and Settings\\Administrator\\桌面\\开奖数据.mdb;integrated security = true";
改成string str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\桌面\开奖数据.mdb;";
就可以了
因为有了个@ ,所以不需要再用 \\这种方式
诶!!好像行了,...先用着吧,以后再好好学一下ADO.NET操作Access谢谢啊!!
按这个写,
或者直接在 vs里自己添加数据库 然后 在属性里查找连接字符串啊~