[Zope] Windows ODBC from Linux

Dieter Maurer dieter@handshake.de
Fri, 5 Jul 2002 23:17:31 +0200


Marco Catunda writes:
 > 	I would like to use a Zope Adapter to access MSAccess database 	in
 > windows plataform via ODBC from Linux. Does anyone have 
 > 	a good idea for	it?
 > 	
 > 	The solutions of dbtcp and ODBCSocketServer 
 > 	don't have Zope Adapter.
 > 
 > 	I was thinking about two instance of Zope. One instance in 	windows
 > with ODBC Adapter and other instance in Linux.
 > 	The instance in Linux will use Adapter of instance in Windows.
 > 	But I would like this solution become as transparent as
 > 	possible for scripts in Linux Instance. Is it possible?
Yes, but it is a bit work:

  You make a redirecting Database Adapter in your Linux instance.
  It send "query" calls to the Windows instance, more precisely
  to a "facilitator" object. This sends the query to
  a database connection, takes the results, pickles them
  and sends them to the requester in the Linux instance.
  This unpickles and returns the result.

Your alternative:

  Upgrade Access to MS SQL Server and use
  SQLRelay or the Sybase connector over FreeTDS to connect
  to it.


Dieter