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