anonymous Log in
Search
Recents:
v3.0
csharp-l
GX16 con ODBC no conecta al iSeries (AS/400)
04/12/19 15:07

craudale

Replies: 0


Saludos

Tengo una App en .Net que conecta y funciona bien con ADO, pero no conecta con ODBC al iSeries (AS/400).

Ambiente:
Windows 10 Pro, version 1909
GX16 U6
iSeries (AS/400) con OS 7.2
ODBC 64 bits (también se ha probado con ODBC 32 bits)
En el ODBC se ha configurado la lista de librerías: LIB1 LIB2 LIB3
En la propiedad Library list del Data Store, se ha incluido la misma lista: LIB1 LIB2 LIB3

Acudimos a ustedes solicitándoles el favor de ayudarnos a solucionar este error.

Gracias

El mensaje de error es:

Process information:
Process ID: 17760
Process name: w3wp.exe
Account name: IIS APPPOOL\ASP.NET V4.0

Exception information:
Exception type: GxADODataException
Exception message: Type:GeneXus.Data.GxADODataException.The connection cannot be opened because an error occurred. At least one library was not added to the Library List.
at GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr)
at GeneXus.Data.NTier.ADO.ForEachCursor.execute()
at GeneXus.Data.NTier.DataStoreProvider.execute(Int32 cursor, Object[] parms, Boolean batch)
at GeneXus.Programs.f0911z1.move_next()
at GeneXus.Programs.f0911z1.btn_next()
at GeneXus.Programs.f0911z1.Process()
at GeneXus.Programs.f0911z1.ExecuteStartEvent()
at GeneXus.Programs.rwdmasterpage.START042()
at GeneXus.Programs.rwdmasterpage.webExecute()
at GeneXus.Programs.f0911z1.webExecute()
at GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext)

The connection cannot be opened because an error occurred. At least one library was not added to the Library List.
at GeneXus.Data.ADO.GxCommand.ExecuteReader()
at GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr)

The connection cannot be opened because an error occurred. At least one library was not added to the Library List.
at GeneXus.Data.ADO.GxConnection.Open()
at GeneXus.Data.ADO.GxConnectionManager.IncOpenHandlesImpl(GxConnection con)
at GeneXus.Data.ADO.GxConnectionManager.IncOpenHandles(Int32 handle, String dataSource)
at GeneXus.Data.GxDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, Int32 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean dynStmt)
at GeneXus.Data.GxDb2ISeries.GetDataReader(IGxConnectionManager connManager, IGxConnection con, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean hasNested, Boolean dynStmt)
at GeneXus.Data.ADO.GxCommand.ExecuteReader()

The connection cannot be opened because an error occurred. At least one library was not added to the Library List.
at GeneXus.Data.Db2ISeriesConnectionWrapper.Open()
at GeneXus.Data.ADO.GxConnection.Open()

The connection cannot be opened because an error occurred.
at IBM.Data.DB2.iSeries.iDB2Connection.Open()
at GeneXus.Data.Db2ISeriesConnectionWrapper.Open()



Request information:
Request URL: http://localhost/GrabarenAS400.NetEnvironment/f0911z1.aspx?c5f7eee1369f947f3478848cd91d9356,gx-no-cache=1575315772974
Request path: /GrabarenAS400.NetEnvironment/f0911z1.aspx
User host address: ::1
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOL\ASP.NET V4.0

Thread information:
Thread ID: 13
Thread account name: IIS APPPOOL\ASP.NET V4.0
Is impersonating: False
Stack trace: at GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr)
at GeneXus.Data.NTier.ADO.ForEachCursor.execute()
at GeneXus.Data.NTier.DataStoreProvider.execute(Int32 cursor, Object[] parms, Boolean batch)
at GeneXus.Programs.f0911z1.move_next()
at GeneXus.Programs.f0911z1.btn_next()
at GeneXus.Programs.f0911z1.Process()
at GeneXus.Programs.f0911z1.ExecuteStartEvent()
at GeneXus.Programs.rwdmasterpage.START042()
at GeneXus.Programs.rwdmasterpage.webExecute()
at GeneXus.Programs.f0911z1.webExecute()
at GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext)


Carlos Raudales | Information Technology
Standard Fruit de Honduras, S.A. | La Ceiba, Atlántida, Honduras
Office: 504.2443.0511 x 2158 | Mobile: 504.9967.2982
Email: Carlos.Raudales@dole.com
Visit us online at Dole.com<http://www.dole.com/> | Facebook<https://www.facebook.com/Dole/> | Twitter<https://twitter.com/DoleTweets> | Pinterest<https://www.pinterest.com/DolePins/> | Instagram<https://www.instagram.com/dolepics/>



Dole is aware that fake email messages can be used in order to trick customers & suppliers making payments to fraudulent bank accounts . Dole will NEVER ask you to change our bank account details by email only. Should you receive an email from Dole advising you of new bank account details please contact your regular contact at Dole by phone to confirm that the request is genuine. Do not use contact details provided in the suspicious email. Please remain vigilant of fraudulent activity. ---- The preceding e-mail message (including any attachments) contains information that may be confidential or may be otherwise intended as non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution, or reproduction of this message by unintended recipients is not authorized and may be unlawful.

-----------------------------------------
Para Suscribirse/Desuscribirse:
http://www.gxtechnical.com/cgi-bin/hforum.exe?2,3,30,11
Por consultas owner-csharp-l@gxtech.com.uy


Back to csharp-l