Microsoft.Data.Odbc.OdbcException
Hvad er det, som er forkert? Jeg får følgende fejl:ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Source Error:
Line 6: void Page_Load(object sender, System.EventArgs e){
Line 7: OdbcConnection objCon = new OdbcConnection(ConfigurationSettings.AppSettings["connString"]);
Line 8: objCon.Open();
Line 9: string strSQL = "SELECT * FROM Guestbook";
Line 10: OdbcCommand objCmd = new OdbcCommand(strSQL, objCon);
----- kode.aspx ----
<% @ Page Language="c#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="Microsoft.Data.Odbc" %>
<script language="c#" runat="server">
void Page_Load(object sender, System.EventArgs e){
OdbcConnection objCon = new OdbcConnection(ConfigurationSettings.AppSettings["connString"]);
objCon.Open();
string strSQL = "SELECT * FROM Guestbook";
OdbcCommand objCmd = new OdbcCommand(strSQL, objCon);
OdbcDataReader oDataReader = objCmd.ExecuteReader(CommandBehavior.CloseConnection);
MyDataGrid.DataSource = oDataReader;
MyDataGrid.DataBind();
}
</script>
<html>
<body>
<ASP:DataGrid id="MyDataGrid" runat="server" />
</body>
</html>
---- web.config ----
<configuration>
<appSettings>
<add key="connString" value="driver={MySQL};server=webhotel.com;database=db;uid=uid_dk;pwd=pwd;OPTION=16386" />
</appSettings>
<system.web>
<customErrors mode="Off"/>
<compilation debug="true"/>
</system.web>
</configuration>
