Closing and Reopening a Connection

[BlackburnKL]

I am experiencing problems trying to use a reponed connection to the database.

We use a VB6 front end, and a SQL Server 2000 database using ADO connections from Windows 2000 PCs (via application role access). We scan boxes of product as they pass down a conveyor to update the inventory. I was asked to close the connection during periods of inactivity. That part works fine.

When the next box comes along (after lunch, etc.), the connection needs to be reopened (which also appears to work). The trouble comes when I attempt to open an ADO recordset using the reopend connection. It returns a general network error.

Any ideas?

Thanks in advance for your help.

BlackburnKL, Programmer

BlackburnKL