Hola a todos,
A partir de la v5 de OS/400, el timeout de ODBC es dado por la aplicaci�n y
no por el AS/400 (iSeries). Te recomiendo revisar la aplicaci�n (codigo) ya
que el error que est�s recibiendo es lo mismo que me toc� vivir algunos
meses atr�s.
Si haces un trace del ODBC ver�s que la aplicaci�n por defecto tiene un
valor de TimeOut de 30 segundos.
Link Informativo.
http://www-1.ibm.com/support/docview.wss?uid=nas1337ac2bf0df7e4268625697d00793eb5
Adicional: (Creo este es tu caso)
Applications That Use Query Timeout
Most Microsoft products (Access, DAO, RDO, and so on) set the query timeout
to a default of 60 seconds. The default for ADO is 30 seconds. Programmers
can usually override this setting through some property exposed by the
object model being used.
In ADO, you can set the CommandTimeout property to 0 to disable the query
timeout. ADO supports this property on both the connection and command
object. Note that the command object does not inherit the setting from the
connection object (in ODBC an ODBC statement handle does inherit the
default value of the connection handle). The ADO 2.5 documentation states:
The CommandTimeout setting on a Connection object has no effect on the
CommandTimeout setting on a Command object on the same Connection; that is,
the Command object's CommandTimeout property does not inherit the value of
the Connection object's CommandTimeout value.
Contact Microsoft support for further information on ADO and the
CommandTimeout property.
In Microsoft Access the query timeout value can be changed by opening the
query in Design View , right clicking anywhere outside of the field lists
and design grid area, then selecting properties. This brings up the query
property sheet where you can then change the ODBCTimeout property to 0 (to
disable it) or any desired value. Consult the Microsoft Access help for
further information.
ADO Example
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rs As ADODB.Recordset
cn.Open "DSN=RCHAS194"
'If the query is run on a connection, the connection command timeout must
be set
cn.CommandTimeout = 0
Set rs = cn.Execute("select * from qiws.qcustcdt")
rs.Close
'If the query is run on a command object,
'the command timeout must be set. It does not inherit the connection
'property.
cmd.CommandTimeout = 0
cmd.CommandText = "Select * from qiws.qcustcdt"
Set cmd.ActiveConnection = cn
Set rs = cmd.Execute
rs.Close
'This uses a default of 30 because the connection timeout
'is not inherited by the new command object
Dim cmd2 As New ADODB.Command
Set cmd2.ActiveConnection = cn
cmd2.CommandText = "select * from qiws.qcustcdt"
Set rs = cmd2.Execute
'This will use the timeout of the connection object (MDAC 2.6)
rs.Open "select * from qiws.qcustcdt", cn
rs.Close
cn.Close
Set rs = Nothing
Set cmd = Nothing
Set cn = Nothing
Saludos desde Chile...
<><><><><><><><><><><><><><><><><><><><>
J@
<><><><><><><><><><><><><><><><><><><><>
Today; regala una sonrisa...j@
"jnegre"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
t> cc:
Sent by: Subject: RE: RV: time out ODBC
forum.help400-request
@combios.es
14-10-2003 10:51
Please respond to
forum.help400
Lo tengo en *nomax
Jordi
-----Mensaje original-----
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de MRIERAB
Enviado el: Martes, 14 de Octubre de 2003 11:56 a.m.
Para: [EMAIL PROTECTED]
Asunto: Re: RV: time out ODBC
Hola Jordi:
Mirate, con mucho cari�o el valor de sistema QQRYTIMLMT.
Suerte.
Marti Riera
----- Mensaje Original -----
De: "jnegre" <[EMAIL PROTECTED]>
Fecha: Martes, Octubre 14, 2003 11:00 am
Asunto: RV: time out ODBC
> Hola Foro,
>
> Tengo un problema con ODBC:
>
> Cuando intento hacer un SQL que afecta a un volumen muy grande de
> registrosdesde asp utilizando un odbc me sale el siguiente error:
>
> Tipo de error:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [IBM][Controlador ODBC de Client Access Express (32 bits)][DB2/400
> SQL]SQL0666 - El tiempo calculado de proceso de consulta 61 excede
> el l�mite
> 30.
>
> Hay alguna manera de incrementar este l�mite?
>
>
> Gracias anticipadas
> Jordi Negre
>
>
>
>
>
>
>
>
> _____________________________________________________
> Forum.HELP400 es un servicio m�s de NEWS/400.
> � Publicaciones Help400, S.L. - Todos los derechos reservados
> http://www.help400.es
> _____________________________________________________
>
> Para darte de baja, env�a el mensaje resultante de pulsar
> mailto:[EMAIL PROTECTED]
>
_____________________________________________________
Forum.HELP400 es un servicio m�s de NEWS/400.
� Publicaciones Help400, S.L. - Todos los derechos reservados
http://www.help400.es
_____________________________________________________
Para darte de baja, env�a el mensaje resultante de pulsar
mailto:[EMAIL PROTECTED]
_____________________________________________________
Forum.HELP400 es un servicio m�s de NEWS/400.
� Publicaciones Help400, S.L. - Todos los derechos reservados
http://www.help400.es
_____________________________________________________
Para darte de baja, env�a el mensaje resultante de pulsar
mailto:[EMAIL PROTECTED]
_____________________________________________________
Forum.HELP400 es un servicio m�s de NEWS/400.
� Publicaciones Help400, S.L. - Todos los derechos reservados
http://www.help400.es
_____________________________________________________
Para darte de baja, env�a el mensaje resultante de pulsar
mailto:[EMAIL PROTECTED]
