Ruby on Rails
ODBTP (Version #15)

http://odbtp.sourceforge.net

"ODBTP is a TCP/IP protocol for connecting to Win32-based databases from any platform. It is ideal for remotely accessing MS SQL Server, MS Access, and Visual FoxPro database from Linux or Unix machines. ODBTP is fast, efficient, and has many features that make it a quality Open Source solution for database connectivity."

PHP seems to be the only supported extension. Someone has developed a Python API, which can be found here: http://benjiyork.com/odbtp.html

We use ODBTP to connect to a Pervasive.SQL database used by our accounting system to check inventory stock. I’m currently accessing PHP scripts using Net::HTTP. There’s definitely no joy in this method!

Alternative

Check out Ruby DBI’s DBD::Proxy!

http://odbtp.sourceforge.net

"ODBTP is a TCP/IP protocol for connecting to Win32-based databases from any platform. It is ideal for remotely accessing MS SQL Server, MS Access, and Visual FoxPro database from Linux or Unix machines. ODBTP is fast, efficient, and has many features that make it a quality Open Source solution for database connectivity."

PHP seems to be the only supported extension. Someone has developed a Python API, which can be found here: http://benjiyork.com/odbtp.html

We use ODBTP to connect to a Pervasive.SQL database used by our accounting system to check inventory stock. I’m currently accessing PHP scripts using Net::HTTP. There’s definitely no joy in this method!

Alternative

Check out Ruby DBI’s DBD::Proxy!