[egenix-users] InterfaceError: ('07009', 0, '[Microsoft][SQL Native Client]Invalid Descriptor Index', 6793)

[akm]

Hi ,

I am getting an error like this.
Can anyone give me a pointer why this occur ?
I am using 2.1.0 version of mx.ODBC.

>>>import mx
>>>mx.ODBC.__version__
'2.1.0'
>>> from mx.ODBC import Windows as MS
>>> conn = MS.connect(dsn='dsn', user='idn', password='ipasswd)
>>> cr = conn.cursor()
>>> cr.execute("""SELECT table1.idn,
...                                       table1.crt_dt,
...                                       table1.active
...                           FROM table1
...                           JOIN table2
...                            ON table1.claimant_idn = table2.claimant_idn
...                            AND table1.active = ?
...                           WHERE
...                           table1.number = ?
...                           AND table1.type = ?""", ('Y', '148', 'TEST'))
Traceback (most recent call last):
  File "<console>", line 14, in <module>
InterfaceError: ('07009', 0, '[Microsoft][SQL Native Client]Invalid
Descriptor Index', 6793)
>>>

its working fine If i move condition table1.active = ? from JOIN
clause to WHERE clause.

Thanks,
Abdul Kader M