It looks like you using ASP?  I have not encountered this problem, although
I haven't stressed the system too much.  I am retrieving records somewhat
differently than you:

'Connect to the support database.
Set DataConn = Server.CreateObject("ADODB.Connection")

DataConn.ConnectionTimeout = 15
DataConn.CommandTimeout = 15
DataConn.Open "DSN=<data source>"

'Get the customer master record.
Set DataCmd = Server.CreateObject("ADODB.Command")
DataCmd.CommandText = "SELECT * FROM SUPPRT.CUSTOMER_MAST WHERE
SUPPRT.CUSTOMER_MAST.CUST_ID = '" & CustIDForm & "'"
Set DataCmd.ActiveConnection = DataConn

Set rs_main = Server.CreateObject("ADODB.Recordset")
Set rs_main = DataCmd.execute

<do stuff>

DataConn.Close
Set DataConn = nothing

HTH


At 09:24 AM 05/02/00 -0600, Richard Heidt wrote:
>Hello All,
>
>Currently we are using MBFoster ODBCLink to access our Image DB via ODBC.
>This allows us to webify our data. The problem we're having is a
>multi-thread error.  It seems that the MBFoster ODBC product doesn't
>destroy threads properly and there is a 50 thread limit. Using ADO to open
>the datasets I use a procedure similar to the following:
>
>set rs=server.createobject("ADODB.Recordset")
>rs.open "Select Field1 FROM SomeDataset","ConnectionString to HP3000 Data"
>... do some stuff w/ db
>rs.close
>set rs=nothing
>



>I'm assuming this is correct, but I run out of threads after the very
>first open. Does anybody out there use MBFoster for Web apps? If so, Did
>you encounter any problems?


Tom Brandt
Northtech Systems, Inc.
http://www.northtech.com