Hello, Is anybody bold enough to try Zope with ODBC to an ACCESS database? How about a Micosoft's SQL? Have you had any success with either? What would you recommend?? Regards, Luis. -- ====================================================== Luis Cortes Pollak EPD (915) 621-6113 ======================================================
Is anybody bold enough to try Zope with ODBC to an ACCESS database?
I wrote a Jet database adapter so you can skip the ODBC and go straight to access. http://www.zope.org/Members/jfarr/Products/ZJetDA/ SQL server is a different story. --jfarr "Perl is worse than Python because people wanted it worse." Larry Wall, 14 Oct 1998
Hi,
Is anybody bold enough to try Zope with ODBC to an ACCESS database?
How about a Micosoft's SQL? Have you had any success with either?
We have Zope running without any real problems with ODBC and SQL-server 7 for about 10 months.
What would you recommend??
It all depends on your needs. The question you have to answer is: do I realy need a databaseserver? I won't get in the nitty gritty details about the differences between databaseservers (there some differences between them also) and Access, dBase, Paradox etc. Basically: if all you want to do is just serve some data from simple tables with not more then 5 concurrent users you can pull it of with Access etc. Henny van der Linde
Henny van der Linde wrote:
Basically: if all you want to do is just serve some data from simple tables with not more then 5 concurrent users you can pull it of with Access etc.
There are well known problems with data corruption caused by multiple concurrent access to Microsoft Access. Here's a reference that dropped from Google when I asked "corruption concurrent microsoft access database" http://dgl.com/dglinfo/1998/dg980825.html (half way down page) I wouldn't use Access with Zope. -- Steve Alexander Software Engineer Cat-Box limited
Here's a reference that dropped from Google when I asked "corruption concurrent microsoft access database"
http://dgl.com/dglinfo/1998/dg980825.html (half way down page)
I wouldn't use Access with Zope.
Sounds like a bug in the Access UI not the underlying Jet DB engine. --jfarr
Luis Cortes wrote:
Is anybody bold enough to try Zope with ODBC to an ACCESS database?
Sure, nothing big's running here on top of Access, but Zope's definitely connected to Access through ODBC; no problem. The only problem actually is just Access' obscure error messages when developing. :) (not that I wouldn't prefer using another database, but everybody here has Access installed, so..) Regards, Martijn
participants (5)
-
Henny van der Linde -
Jonothan Farr -
Luis Cortes -
Martijn Faassen -
Steve Alexander