cursor.primaryKeys doesn't work connected to Sybase ASE 15

[GoogleCodeExporter]

What steps will reproduce the problem?
1. c = pyodbc.connect("DSN=ASE15;...;autocommit=true")
2. c.primaryKeys()

What is the expected output? What do you see instead?
I expect to get back a return set, per 
http://code.google.com/p/pyodbc/wiki/Cursor.  Instead I get this:

pyodbc.Error: ('HY000', "[] [FreeTDS][SQL Server]Catalog procedure 'sp_pkeys' 
can not be run in a transaction. (18040) (SQLPrimaryKeys)")

What version of the product are you using? On what operating system?
>>> pyodbc.version
'2.1.7-beta0'

Linux, Solaris 10 x86.

Please provide any additional information below.

This is connected to a sybase ASE 15 server.

Original issue reported on code.google.com by pedri...@gmail.com on 16 Nov 2010 at 7:45

[GoogleCodeExporter]

OK, so I found the autocommit property, and wrapping my call between setting it 
to true and back to false seems to work.  It's trange that the autocommit=true 
flag in the connection string isn't working.  Any thoughts on that?

Original comment by pedri...@gmail.com on 16 Nov 2010 at 8:00

[GoogleCodeExporter]

That's very weird, but it seems to be database-specific issue, so I'm going to 
leave the code as is.

Thanks for reporting the workaround.  I've added it to the FAQ page and will 
see if there are any other places it needs to be.

Original comment by mkleehammer on 19 Nov 2010 at 9:36

• Changed state: WontFix

[GoogleCodeExporter]

Issue 137 has been merged into this issue.

Original comment by mkleehammer on 20 Nov 2010 at 7:02