[python-win32] db-api connection pooling in ASP?

[Craig H. Anderson]

Greetings, 

My adventure in mixing Python scripting into
an existing VBScript and Javascript application
is moving along.  The current question is how
to manage database connections. 

* The database is Sql-server 2000
* Current VBScript code uses ADO
* New Python code uses DB-API library adodbapi 

In production there may be 100 browser seats accessing
the web pages. 

I'm thinking I will try this library
http://jonpy.sourceforge.net/dbpool.html 

Does anyone have experience and advice on this? 

Another possibility is using the same ADO connection object
as the VBScript code.  I could use this to initialze the adodbapi
connection.  However, I'm not sure how to pass the ADO object
from VBScript to Python. 

Thanks for your help.