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

[Jens B. Jorgensen]

You probably don't need to do anything as connection pooling is built 
into ODBC and OLEDB. The main thing is to make sure the connection 
string is identical. You can pass the vbscript connection to Python in a 
couple of ways. The easiest would be to make your python code into a COM 
object and pass it that way. Do some googling for deeper information on 
how ODBC and OLEDB do their connection pooling.

Craig H. Anderson wrote:

>
> 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.
> _______________________________________________
> Python-win32 mailing list
> Python-win32 at python.org
> http://mail.python.org/mailman/listinfo/python-win32



-- 
Jens B. Jorgensen
jens.jorgensen at tallan.com

"With a focused commitment to our clients and our people, we deliver value through customized technology solutions"  

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2861 bytes
Desc: S/MIME Cryptographic Signature
Url : http://mail.python.org/pipermail/python-win32/attachments/20040723/dc527c2d/smime.bin