5

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.

Jens Mühlenhoff
  • 14,565
  • 6
  • 56
  • 113
b3rx
  • 366
  • 1
  • 2
  • 8

2 Answers2

3

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.

There is now a native wrapper at http://code.google.com/p/adsdb/.

LanceSc
  • 2,094
  • 12
  • 14
1

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
  • 854,459
  • 170
  • 1,222
  • 1,395
  • 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 Jul 27 '09 at 17:57