|
|
Proba con estas dll que te paso...
https://drive.google.com/file/d/18jpG7I0u7Cv0-JVPh9Ie6RhMbOLKlT6t/view?usp=drive_link
Enviado desde Correo para Windows
De: Gabriel Medina
Enviado: miércoles, 24 de abril de 2024 18:39
Para: ggg (GeneXus Google Groups)
Asunto: Error: Unable to load DLL 'libmySQL.dll'
Hi Friends,
Trying to run a Web Application C#/MySQL I got the following error:
ERROR : Unable to load DLL 'libmySQL.dll' / (Exception from HRESULT: 0x8007007E)Server Error in '/CitiesJavaMySQLNETFrameworkMySQL' Application.
Unable to load DLL 'libmySQL.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
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.DllNotFoundException: Unable to load DLL 'libmySQL.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
===Environment Data ============================
· GeneXus : GeneXus 16 U10, 16.0.142546
· Generador : Csharp
· Environment : Web
· DBMS : MySQL Server 5.7.44
· OS : Windows 11
· Lenguaje : C#
· Compilador : v4.0.30319
· Browsers : Opera/Chrome/any
· Web Server : IIS 10
· Pattern : WW+
· Android SDK... : -
Server Error in '/CitiesJavaMySQLNETFrameworkMySQL' Application.
Unable to load DLL 'libmySQL.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
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.DllNotFoundException: Unable to load DLL 'libmySQL.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[DllNotFoundException: Unable to load DLL 'libmySQL.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)]
MySQLDriverCS.CPrototypes.mysql_init(Void* must_be_null) +0MySQLDriverCS.MySQLConnection.Open() +446GeneXus.Data.MySqlDriverCSConnectionWrapper.Open() +41
[GxADODataException: Unable to load DLL 'libmySQL.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)]GeneXus.Data.MySqlDriverCSConnectionWrapper.Open() +227GeneXus.Data.ADO.GxConnection.Open() +597
[GxADODataException: Unable to load DLL 'libmySQL.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)]GeneXus.Data.ADO.GxConnection.Open() +1215GeneXus.Data.ADO.GxConnectionManager.IncOpenHandlesImpl(GxConnection con) +30GeneXus.Data.ADO.GxConnectionManager.IncOpenHandles(Int32 handle, String dataSource) +67GeneXus.Data.GxMySQLDriverCSCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, Int32 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean hasNested, Boolean dynStmt) +243GeneXus.Data.GxMySql.GetDataReader(IGxConnectionManager connManager, IGxConnection con, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean hasNested, Boolean dynStmt) +541GeneXus.Data.ADO.GxCommand.ExecuteReader() +725
[GxADODataException: Unable to load DLL 'libmySQL.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)]GeneXus.Data.ADO.GxCommand.ExecuteReader() +895GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +412GeneXus.Data.NTier.ADO.ForEachCursor.execute() +130GeneXus.Data.NTier.DataStoreProvider.execute(Int32 cursor, Object[] parms, Boolean batch) +1203GeneXus.Programs.country.GetKey011() +110GeneXus.Programs.country.getEqualNoModal() +17GeneXus.Programs.country.AfterKeyLoadScreen() +199GeneXus.Programs.country.Valid_Countryid() +54
[TargetInvocationException: Exception has been thrown by the target of an invocation.]System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +118System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +182System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) +897GeneXus.Http.DynAjaxEvent.DoInvoke(Object[] MethodParms) +195GeneXus.Http.DynAjaxEvent.Invoke(String JsonMessage, GXHttpHandler targetObj) +285GeneXus.Http.GXHttpHandler.webAjaxEvent() +538GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +863
[Exception: GXApplication exception]GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +1249System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +537System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +172System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +93
--
Saludos,
gab
@gxsoft
--
Has recibido este mensaje porque estás suscrito al grupo "GeneXus" de Grupos de Google.
Para cancelar la suscripción a este grupo y dejar de recibir sus mensajes, envía un correo electrónico a genexus+unsubscribe@googlegroups.com.
Para ver esta conversación en el sitio web, visita https://groups.google.com/d/msgid/genexus/CAEogB3QNGY%3Da94Fyp%3DniSCgzq0X_jWHncjtLfpqdNkyqLcyQ2w%40mail.gmail.com.
Eso está bien cuando lo pruebas en tu maquina local, pues es ahí donde tienes la KB... PERO, si lo tienes en un servidor.. no se sabe como hacer eso.. Alguien sabe como agregar esa funcinón pero en un servidor ?
SOLUCION:La solución es agregar el usuario a la DB, el mismo que está dando error, y que sugieere el FORM dialog de Edit Connection en preferences de la KBen 2 Pasos@gxsoftgab--Saludos,On Mon, Jun 11, 2018 at 10:19 AM Gabriel Medina <gxs...@gmail.com> wrote:Error de servidor en la aplicación '/KBtest.NetEnvironment'.
Cannot open database "People" requested by the login. The login failed.
Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.
Detalles de la excepción: System.Data.SqlClient.SqlException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.
Error de código fuente:
Se ha generado una excepción no controlada durante la ejecución de la solicitud Web actual. La información sobre el origen y la ubicación de la excepción pueden identificarse utilizando la excepción del seguimiento de la pila siguiente.
Seguimiento de la pila:
[SqlException (0x80131904): Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) +1431 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +1085 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +70 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +964 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +109 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1529 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +156 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +258 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +312 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +202 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +413 System.Data.SqlClient.SqlConnection.Open() +128 GeneXus.Data.MssqlConnectionWrapper.Open() +29 GeneXus.Data.ADO.GxConnection.Open() +591 [GxADODataException: Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] GeneXus.Data.ADO.GxConnection.Open() +1203 GeneXus.Data.ADO.GxConnectionManager.IncOpenHandlesImpl(GxConnection con) +30 GeneXus.Data.ADO.GxConnectionManager.IncOpenHandles(Int32 handle, String dataSource) +65 GeneXus.Data.GxSqlCursorDataReader.LoadFirstBlock() +240 GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +478 [GxADODataException: Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +737 GeneXus.Data.GxSqlServer.GetDataReader(IGxConnectionManager connManager, IGxConnection con, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean hasNested, Boolean dynStmt) +280 GeneXus.Data.ADO.GxCommand.ExecuteReader() +720 [GxADODataException: Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] GeneXus.Data.ADO.GxCommand.ExecuteReader() +886 GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +129 [GxADODataException: Type:GeneXus.Data.GxADODataException.DBMS Error Code:4060.Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +793 GeneXus.Data.NTier.ADO.ForEachCursor.execute() +121 GeneXus.Data.NTier.DataStoreProvider.execute(Int32 cursor, Object[] parms, Boolean batch) +775 GeneXus.Programs.people.GetKey011() +107 GeneXus.Programs.people.btn_enter() +31 GeneXus.Programs.people.Process() +600 GeneXus.Programs.people.UserMainFullajax() +32 [TargetInvocationException: Se produjo una excepción en el destino de la invocación.] System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +260 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +142 System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) +774 GeneXus.Http.DynAjaxEvent.doInvoke(Object[] MethodParms) +180 GeneXus.Http.DynAjaxEvent.invoke(String JsonMessage, GXHttpHandler targetObj) +296 GeneXus.Http.GXHttpHandler.webAjaxEvent() +230 GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +900 [Exception: GXApplication exception] GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +1169 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +866 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +213 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +91
Información de versión: Versión de Microsoft .NET Framework:4.0.30319; Versión ASP.NET:4.7.3056.0Error de servidor en la aplicación '/KBtest.NetEnvironment'.
Cannot open database "People" requested by the login. The login failed.
Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.
Detalles de la excepción: System.Data.SqlClient.SqlException: Cannot open database "People" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.
Error de código fuente:
Se ha generado una excepción no controlada durante la ejecución de la solicitud Web actual. La información sobre el origen y la ubicación de la excepción pueden identificarse utilizando la excepción del seguimiento de la pila siguiente.
Seguimiento de la pila:
[SqlException (0x80131904): Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +345 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +156 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +258 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +312 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +202 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +413 System.Data.SqlClient.SqlConnection.Open() +128 GeneXus.Data.MssqlConnectionWrapper.Open() +29 GeneXus.Data.ADO.GxConnection.Open() +591 [GxADODataException: Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] GeneXus.Data.ADO.GxConnection.Open() +1203 GeneXus.Data.ADO.GxConnectionManager.IncOpenHandlesImpl(GxConnection con) +30 GeneXus.Data.ADO.GxConnectionManager.IncOpenHandles(Int32 handle, String dataSource) +65 GeneXus.Data.GxSqlCursorDataReader.LoadFirstBlock() +240 GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +478 [GxADODataException: Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] GeneXus.Data.GxSqlCursorDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean withCached, SlidingTime expiration, Boolean dynStmt) +737 GeneXus.Data.GxSqlServer.GetDataReader(IGxConnectionManager connManager, IGxConnection con, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean hasNested, Boolean dynStmt) +280 GeneXus.Data.ADO.GxCommand.ExecuteReader() +720 [GxADODataException: Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] GeneXus.Data.ADO.GxCommand.ExecuteReader() +886 GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +129 [GxADODataException: Type:GeneXus.Data.GxADODataException.DBMS Error Code:4060.Cannot open database "People" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET V4.0'.] GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +793 GeneXus.Data.NTier.ADO.ForEachCursor.execute() +121 GeneXus.Data.NTier.DataStoreProvider.execute(Int32 cursor, Object[] parms, Boolean batch) +775 GeneXus.Programs.people.GetKey011() +107 GeneXus.Programs.people.btn_enter() +31 GeneXus.Programs.people.Process() +600 GeneXus.Programs.people.UserMainFullajax() +32 [TargetInvocationException: Se produjo una excepción en el destino de la invocación.] System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +260 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +142 System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) +774 GeneXus.Http.DynAjaxEvent.doInvoke(Object[] MethodParms) +180 GeneXus.Http.DynAjaxEvent.invoke(String JsonMessage, GXHttpHandler targetObj) +296 GeneXus.Http.GXHttpHandler.webAjaxEvent() +230 GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +900 [Exception: GXApplication exception] GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +1169 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +866 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +213 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +91
Información de versión: Versión de Microsoft .NET Framework:4.0.30319; Versión ASP.NET:4.7.3056.0@gxsoftgab--Saludos,
Designed by Vida de bombeiro Recipes Informatica Humor Technology Curiosidades Mensagens News Tecnology Curiosity Car News Saude Video Games Car Blog Animals Diario das Mensagens Eletronica Rei Jesus News Esportes Noticias Atuais Pets Literature Career Religion Fashion Recreation Business Education Autos Style Television Programming Motosport News Recipes The Games Home Downs Internet Car Design Entertaimment Celebrities 1001 Games Doctor Pets Net Downs World Enter Paraiso das Musicas Jesus Variedade Mensagensr Humor