BDP.NET Connections and DataReader

I was developing test applications for ASP.NET with Delphi 8 when I noticed that the Borland Data Provider (BDP) only supports a single transaction per database connection.

This seemed a too-odd limitation for me, and I thought I was doing something wrong. Now, I did some research with a bit help from Google, and found Ramesh Theivendran's article on IBM's web site (yes!). This article explicitly notes:

"The current version of BDP doesn't support connection pooling."

Bad luck! I had to re-architect my ASP.NET application so that for each request, and new connection object is created, and then freed after the connection has been handled.

This is a quick-n-dirty solution, and I had much rather written a connection pool style of connection handling, but I'm pressed by time.

Borland, if you are listening, we need proper ADO.NET style connection pooling in the next version of BDP!