{Sorry about the slow response... I had to go drive an ambulance...}
You could try shortcutting the code in _buildADOparamteterList() to always
execute the "except:" clause (around line 941). I suspect that the same
error will persist -- but maybe not. (Aren't you glad you have source
code?)
--
V
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
On Fri, May 25, 2012 at 12:04 PM, Tim Roberts wrote:
> Alan Trick wrote:
> > On Fri, May 25, 2012 at 10:18 AM, Tim Roberts wrote:
> >> 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 iden
Alan Trick wrote:
> On Fri, May 25, 2012 at 10:18 AM, Tim Roberts wrote:
>> 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 exception with a tuple. For what it's worth, the
> value of c
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
Alan Trick wrote:
> 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.
Well, there error is firing inside the adodbapi code, not in VFP,
although i
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
