defunct processes in Informix 7
Posted in 2000
Topics: Connectivity: ODBC / JDBC / .NET
I am receiving defucnt processes in the Informix box when connecting through ODBC. I am using a smal VB tool created to extract data every 20 minutes. The tool makes an ODBC connection, opens the recordset and then creates a comma delimited file and places it in an out box. Once this process has bee completed it closes the connection and the other processes are run in SQL Sever. My problem lies in the Informix box, when I look at the status it has defunct processes for each time I connect to the box even though the extract tool has released. When the defunct processes build to a certain point it will no longer allow me to connect to the Informix database. I am using Open Link ODBC driver version 1.5 and connecting to an Informix 7 database. I would greatly appreciate any input into resolving this issue, as it is time comsuming to run the processes manually. thanks in advance, Kevin * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!