急求:ERROR [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
&&&&&&&下面的是我在visual studio 2005 中编写上,但运行这后,就出出上面的问题“ERROR [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序 ”就在“AconnStr.Open();”打住了,请各位高手帮帮忙。&&&&&&&&&&&谢谢!谢谢!数据库我用的是access 2000的。
<%@ Page Language= "C# " ContentType= "txet/html "AutoEventWireup= "true " CodeFile= "OleDbConnection.aspx.cs " Inherits= "_Default " %>
<%@ Import Namespace = "System.Data " %>
<%@ Import Namespace = "System.Data.Odbc " %>
<script language= "c# " runat = "server ">
public OdbcConnection AconnStr;
void Page_Load(Object sender,EventArgs e){
string Afile = Server.MapPath( "App_Data/User.mdb ");
OdbcConnection AconnStr= new OdbcConnection ( "Driver={Microsoft Access Driver(*.mdb)};Dbq= "+Afile+ "; ");
Response.Write(AconnStr);
OdbcCommand Acmd= new OdbcCommand( "select * from UserName order by ID ", AconnStr);
Response.Write(Acmd);
OdbcDataReader odr = null;
AconnStr.Open();
try
{
odr = Acmd.ExecuteReader();
}
catch (Exception ex)
{
if (ex != null) Response.Write(ex.ToString());
}
if (odr != null)
{
string TotalInfo = " ";
while (odr.Read())
{
TotalInfo += odr[ "ID "].ToString() + " " + odr[ "UserName "].ToString() + " <br/> ";
}
odr.Close();
listdiv.InnerHtml = "TotalInfo ";
}
AconnStr.Close();
}
</script>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN " "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">
<html xmlns= "http://www.w3.org/1999/xhtml " >
<head runat= "server ">
<meta http-equiv= "Content-Type " content= "text/html " />
<title> access connection </title>
</head>
<body>
<h3> Sql Server 数据库连接 </h3>
<div runat = "server " id= "listdiv " style = "font-size:10.5pt;BORDER:1px solid #CCCCCC;BACKGROUND-COLOR:#F2F2F2 " >
</div>
</body>
</html>
[解决办法]
引入的NameSpace错了,import System.Data.OleDb;
这个要配置数据源
[解决办法]
import System.Data.OleDb;
如楼上
[解决办法]
<%@ Import Namespace = "System.Data.Odbc " %>
该为
<%@ Import Namespace = "System.Data.OleDb " %>