System.Data.OleDb.OleDbException: Unspecified error

[lisseth]

saludos, hoy me suscribi a este foro espero me puedan ayudar:

mi problema es el siguiente: estoy haciendo una aplicacion web en visual studio 2005 con una version ASP.net 2.0.50727 y el problema se presenta al navegar por el menu del sitio que trae algunas consultas de una base de datos en Access.

Server Error in '/pca' Application.
--------------------------------------------------------------------------------

Unspecified error
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: System.Data.OleDb.OleDbException: Unspecified error

Source Error:


Line 8363: Me.Adapter.SelectCommand = Me.CommandCollection(0)
Line 8364: Dim dataTable As copropietarios.MemosAnosDataTable = New copropietarios.MemosAnosDataTable
Line 8365: Me.Adapter.Fill(dataTable)
Line 8366: Return dataTable
Line 8367: End Function

Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\pca\ded926c8\efd3c60\App_Code.xe0kmsyd.3.vb Line: 8365

Stack Trace:
[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnectionInternal..ctor(Ol eDbConnectionString constr, OleDbConnection connection) +1054769
System.Data.OleDb.OleDbConnectionFactory.CreateCon nection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.OleDb.OleDbConnection.Open() +37
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107
copropietariosTableAdapters.MemosAnosTableAdapter. MostrarMemosAnos() in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\pca\ded926c8\efd3c60\App_Code.xe0kmsyd.3.vb: 8365

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Objec t target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
System.Web.UI.WebControls.ObjectDataSourceView.Inv okeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +482
System.Web.UI.WebControls.ObjectDataSourceView.Exe cuteSelect(DataSourceSelectArguments arguments) +2040
System.Web.UI.WebControls.Repeater.GetData() +50
System.Web.UI.WebControls.Repeater.CreateControlHi erarchy(Boolean useDataSource) +232
System.Web.UI.WebControls.Repeater.OnDataBinding(E ventArgs e) +53
System.Web.UI.WebControls.Repeater.DataBind() +72
System.Web.UI.WebControls.Repeater.EnsureDataBound () +55
System.Web.UI.WebControls.Repeater.OnPreRender(Eve ntArgs e) +12
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

bueno ese es el error que me sale, creo yo que es cuestion de permisos o algo asi, por favor cualquier solucion les agradeceria que me la hicieran saber, gracias!

[.seb]

Si fuera tema de permisos tienes que darle permiso de Lectura/Escritura al usuario ASPNET de tu máquina al archivo donde se encuentra la base de datos.
De todas formas no estoy seguro que ese sea el error.
Sie puedes pega toda la función que te falla.

[lisseth]

esta es la funcion, que sale en el error:
Private Function EjecutaSQL(ByVal Texto As String) As OleDbDataReader
Dim conexion As New OleDbConnection(_conexion)
Dim comando As New OleDbCommand
comando.Connection = conexion
comando.Connection.Open()
comando.CommandText = Texto
Dim lector As OleDbDataReader = comando.ExecuteReader()
Return lector
comando.Connection.Close()
'cambio

End Function

gracias de antemano!

[.seb]

Creo que debería cerrar el reader si vas a cerrar la conexion...
Prueba sin cerrar la conexion a ver que pasa

[lisseth]

ok ya esta muchas gracias!

[javiercapi]

Hola y perdon por reabrir este tema viejo, pero puedes decirme como resolviste exactamente este error, pue stengo uno igual :S