Thanks to Randall for putting me on track. I did some Googling and couldn't find 
anything on this so in case anyone is interested :

import mx.ODBC.Windows
from MiscUtils.DBPool import DBPool

#DBAPI 2.0 requires a threadsafety attribute which doesn't exist in mx.ODBC
mx.ODBC.Windows.threadsafety = 1

pool = DBPool(mx.ODBC.Windows,5,dsn,user='DBUser',password='somepass')




-----Original Message-----
From: Randall Randall [mailto:randall@;randallsquared.com]
Sent: Wednesday, November 06, 2002 1:17 PM
To: Ian Sparks
Cc: [EMAIL PROTECTED]
Subject: Re: [Webware-discuss] mxODBC and DBPool


Ian Sparks wrote:
> Is anyone else using mxODBC with dbPool? I'm having trouble working out what to pass 
>to the DBPool constructor.
> 
> pool = DBPool(WhatGoesHere?,5,'DSN=...')

Just 'mxODBC', if it works like psycopg.  You'll need
to have imported mxODBC first.

-- 
Randall Randall <[EMAIL PROTECTED]>
"[The] poetic justice of cause and effect compels
 respect, compassion." -- Faithless, God is a DJ.



-------------------------------------------------------
This sf.net email is sponsored by: See the NEW Palm
Tungsten T handheld. Power & Color in a compact size!
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-discuss

Reply via email to