We have successfully queried rows using cursor.execute() with pythonodbc connected to our Sysbase database. We cannot test a native pythonsybase driver because from what we found in opensource, you have to have the Sybase SDK to build the opensource native driver and the SDK costs more than $1,700 apparently. We used this Sybase ODBC driver on the remove AWS host on Citrix: Sybase IQ Driver 11.00.01.5612 from Anywhere Solution Inc. DBODBC11.dll 8/31/2010
We used this driver on the laptop client: Adaptive Server IQ 9.00.02.1023 IAnywhere Solutions Inc. DBODBC9.dll We only have read access to the Sybase database. Next we plan to get the table schemas and will try to construct the web2py tables for them. Then we can try using web2py queries which will then exercise / test the column type mappings in the DAL Sybase Adapter. It will take a few weeks probably. I don't think there is any usable id column in the native sybase data, but I will cluge something. One suggestion: Where you can specify an id type column in a web2py table over a legacy database, have it take the python int() function of the column if it is a legacy string column. Often, a useable id column in a legacy table is unfortunately in string format, but otherwise would be a good id. So my suggestion is to 'help it along' by taking the int() of the string column so that it will be a useable numeric id for the web2py table.
