|
> It sounds like you may be using a persistent connection to keep > the AS/400 job active. Nope, the jobs return to PSRW state in QUSRWRK. > Are you storing your OLE/DB Connection object in the ASP > Application object (or some other global reference) so that the > connection persists indefinately? Nope. Storing ADO objects in the Application objects is the kiss of death due to threading problems. From ASP's point of view the connection is closed. I would do the following in my page: Dim cn, rs, sql Sql = "select this, that from here where there = 7" set cn = server.createobject("adodb.connection") set rs = server.createobject("adodb.recordset") cn.open session("ConnectionString") set rs.ActiveConnection = cn rs.CursorLocation = adUseClient rs.open sql set rs.activeconnection = nothing cn.close set cn = nothing ... -Walden ------------ Walden H Leverich III President Tech Software (516)627-3800 x11 WaldenL@TechSoftInc.com http://www.TechSoftInc.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.