[python-win32] Adding a notification icon from a service

2012-05-17 Thread Alan Trick
Hi, I have two smallish python modules, one which runs a service, and the other which puts a notification icon with a trivial menu on the windows panel (these modules are quite similar to existing examples in pywin32). Both of these modules work fine by themselves. However when I try to create the

[python-win32] adodbapi: using prepared statements

2012-05-25 Thread Alan Trick
I'm trying to use prepared statements with the adodbapi module, but it's not working. I'm using the Visual FoxPro OLE DB drivers, and I'm worried that this is just something that they can't handle. Here's some sample code: --- import adodbapi conn = adodbapi.connect('Provider=vfpoledb;Data Sour

Re: [python-win32] adodbapi: using prepared statements

2012-05-25 Thread Alan Trick
On Fri, May 25, 2012 at 10:18 AM, Tim Roberts wrote: > > If you print conn.paramstyle, is it still qmark? Yes, the default is qmark. > Is there any change if you use a tuple instead of a list? That is: > >cur.execute("select * from chiro1 where prefix = ?", ('LEG',)) I get an identital exc

Re: [python-win32] adodbapi: using prepared statements

2012-05-25 Thread Alan Trick
On Fri, May 25, 2012 at 2:53 PM, Vernon Cole wrote: > Try setting adodbapi.adodbapi.verbose = 4 and see if that sheds any light. > Particularly look for the line that specifies 'error in COM Refresh(), so > adodbapi is building a parameter list'. I already tried debugging it to get a gist of what