BDE causes DB Open/Close to loose Handles

[pkahal]

The 3 lines code below is causing me to lose Handles (on the Task Manager). So that my resource (the Handles) is not being released.

using(OleDbConnection _Connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=dBASE IV;User ID=;Password=;Data Source=c:\\CT"))
{
_Connection.Open();
_Connection.Close();
}


Code executes properly if I have no BDE (Borland Database Engine) installed on my machine. But I cannot live without BDE since it is needed by other applications.

Got a tool to know of process information from http://www.sysinternals.com/ntw2k/freeware/procexp.shtml

[Krzemo]

Try to switch of connection pooling..

[pkahal]

Please tell How do i do that?
I looked into machine.config in the .NET framework.

[Krzemo]

It should be parameter in connection string...

But it is written in registry.



Best regards,

Krzemo.

[pkahal]

I found the Connection Pooling option under Programs->Administrative Tools->Data Sources (ODBC)
It was Disabled.
Does not make any difference even if I enable it also.
Something fishy with bDase I believe