Hola grupo
Me compré el libro "Beginning ASP.NET 1.0 with C#.NET" para aprender un poco
de asp.net combinado con C#, pero como encontré un ejemplo de codigo en la
pagina 470, donde enseña la forma de conectarse mediante AS.NET, a una BD
Access mediante OleDB, pero me da error....lo unico que modifiqué de este
ejemplo, es la ruta donde está la MDB...
Me da el siguiente error:
Server Error in '/' Application.
----------------------------------------------------------------------------
----
Compilation Error
Description: An error occurred during the compilation of a resource required
to service this request. Please review the following specific error details
and modify your source code appropriately.
Compiler Error Message: CS1002: ; expected
Source Error:
Line 7: strConnection += @"Data
Source=C:\inetpub\wwwroot\northwind.mdb";
Line 8: data_src.Text = strConnection;
Line 9: OleDbConnection objConnection = New OleDbConnection();
Line 10: objConnection.ConnectionString = strConnection;
Line 11:
Source File: c:\inetpub\wwwroot\oledb_connection.aspx Line: 9
Este es el codigo....alguna idea? Gracias
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=C:\inetpub\wwwroot\northwind.mdb";
data_src.Text = strConnection;
OleDbConnection objConnection = New OleDbConnection();
objConnection.ConnectionString = strConnection;
// OleDbConnection objConnection = new OleDbConnection(strConnection);
try
{
objConnection.Open();
con_open.Text="Connection opened successfully.<br />";
objConnection.Close();
con_close.Text="Connection closed.<br />";
}
catch (Exception e)
{
con_open.Text="Connection failed to open.<br />";
con_close.Text=e.ToString();
}
}
</script>
<html>
<body>
<h4>Testing the data connection
<asp:label id="data_src" runat="server"/></h4>
<asp:label id="con_open" runat="server"/><br />
<asp:label id="con_close" runat="server"/><br />
</body>
</html>
Error en codigo,libro Beginning ASPNET 1 with C#
