求救:使用ASP.NET链接数据库连接不上,发现以下异常
ServerVersion = “con.ServerVersion”引发了“System.InvalidOperationException”类型的异常
string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=supmar.mdb"; //数据库的链接
OleDbConnection con = new OleDbConnection(conStr);
OleDbCommand com = new OleDbCommand();
com.CommandText = "insert into sales(Serial,商品编号,商品名称,单价,会员价) select (Serial,商品编 号,商品名称,单价,会员价)from goods where 商品编号='3011ea929200fe0000000001'";
com.Connection = con;
向各位大侠求救。。。