Is it possible for a Zope 1.9 installation running on a linux platform (redhat 5.2) to access a MS ACCESS database located on a different NT server via the ODBC support built into Zope? If not, is there some other way to do this? TIA Randy ____________________________________________________________________ More than just email--Get your FREE Netscape WebMail account today at http://home.netscape.com/netcenter/mail
On Tue, Feb 16, 1999 at 01:38:27PM -0800, Randall Marbach wrote:
Is it possible for a Zope 1.9 installation running on a linux platform (redhat 5.2) to access a MS ACCESS database located on a different NT server via the ODBC support built into Zope?
Well, this would require an ODBC driver under Linux, which obviously Microsoft doens't provide. I don't currently know of any ODBC driver that is freely available that runs on a UNIX variant.
If not, is there some other way to do this?
You might check out... http://starship.skyport.net/crew/lemburg/mxODBC.html It might have some more information. (un)Fortunately I talk native to all my databases, but ODBC is "native" for MS products. Chris -- | Christopher Petrilli | petrilli@amber.org
Yep - you can use the Sybase client libs (MS SQL is just Sybase rebadged). See the "mini-HOWTO" I posted here about a week ago. Anthony.
I wrote:
Yep - you can use the Sybase client libs (MS SQL is just Sybase rebadged). See the "mini-HOWTO" I posted here about a week ago.
Blah - ignore me, no coffee. Misread the original email, brain replaced Access with SQL Server. I'm pretty sure you can't talk to Access with the Sybase clients :) Anthony
Randall Marbach wrote:
Is it possible for a Zope 1.9 installation running on a linux platform (redhat 5.2) to access a MS ACCESS database located on a different NT server via the ODBC support built into Zope?
As Access is not a client-server database, you are unable to use it even from another Windows (NT or 9x) machine. You could make both Access and Zope talk to MS SQL server though.
If not, is there some other way to do this?
Your best bet would be to run a minimal webserver with python ODBC module on the NT box and serve the database pages from there. If required these can be served only to the Zope machine which uses them to construct its pages (you could then just forward your SQL to the NT and get pickled result back to Zope - ODBCGateDA anyone ;). One friend of mine who needs to access XBase files does something similar quite successfully using Apache and pytrhon CGI scripts (NT Apache understands the "#! c:\python\python.exe" line in the beginning of script, and Win32 python together with ODBC module and other goodies is available from www.python.org) ------------------- Hannu
On Wed, 17 Feb 1999, Hannu Krosing wrote:
Randall Marbach wrote:
Is it possible for a Zope 1.9 installation running on a linux platform (redhat 5.2) to access a MS ACCESS database located on a different NT server via the ODBC support built into Zope?
As Access is not a client-server database, you are unable to use it even from another Windows (NT or 9x) machine.
Uh, you could do something complicated involving e.g. RemoteCall from Linux to a Win32 box, and a PythonCOM program on Win32 box. --david
participants (5)
-
Anthony Baxter -
Christopher G. Petrilli -
David Ascher -
Hannu Krosing -
Randall Marbach