Geek Answers Handbook

Is there a Python module for accessing the Advantage Database Server?

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

I searched on the Internet and could not find what I was looking for, so I wanted to ask him here.

+4
source share
2 answers

I 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. My personal preference is the pyodbc driver.

There is currently a built-in http://code.google.com/p/adsdb/ shell.

+2
source

dbfpy (and many other modules) allow you to read and write DBF files. I don’t know about such modules dealing directly with ADT files, but I think there are converters for creating DBF files to / from ADT, if worse, worse.

Another alternative for accessing ADT files would be to actually run the sybase advantage using the odbc driver - if possible, there are several ways to connect to the ODBC service using Python.

+1
source

More articles:


All Articles