views:

223

answers:

2

As the title suggest, I was wondering if there is a Python module that can access an Advantage Database Server (Sybase) files such as ADT and DBF.

I have searched the web and couldn't find what I'm looking for this is why I wanted to ask it here.

+1  A: 

dbfpy (and many other modules) let you read and write DBF files. I'm not aware of similar modules dealing with ADT files directly, but I think there are converters to make DBF files to/from ADT, if worse comes to worst.

Another alternative for accessing ADT files would be to actually run sybase advantage with its odbc driver -- if that is feasible, there are several ways to connect to an ODBC service with Python.

Alex Martelli
Thanks for this. Converting ADT to DBF wouldn't be an option for me. So I'll leave this question unanswered since it's only half answered.
b3rx
+2  A: 

I have used pyodbc with the Advantage ODBC driver, http://code.google.com/p/pyodbc/ and pywin32 http://sourceforge.net/projects/pywin32/ with the Advantage OLE DB provider successfully. My personal preference is the pyodbc driver.

LanceSc