Hi All,

I have a dll which is referenced by an asp page to return data from a .dbf file.

I am creating a new adodb connection using a Foxpro connection string to read data from the .dbf file.

I create the new connection, then open it. The connection has a timeout of 5, I then check the connection state to see if it = 1.
as below

Dim fpDataconn As New ADODB.Connection
fpDataconn.ConnectionTimeout = 5
fpDataconn.Open mvarDBFoxpro, mvarDBFoxpro_Username, mvarDBFoxpro_Password
If fpDataconn.State = 1 Then 'connection open
'process
else
'write to error log
end if

This works OK for but occasionally (say twice a day) when the code reaches the line to open the connection it crashes IIS and causes the dllhost.exe to use 100% processor time.

I have a global error handler on the routine, but this does not get triggered as IIS crashes.

Can anybody please help as this is driving me crazy...

Thanks in advance.

Byron