Hello All: I'm just beginning to play with zope and really like what I see. No Zen yet but it's coming. The project I'm working on must use NT as the server, much to my displeasure. I need to select a SQL database for the project and need to find one that will work and play well with zope. Searching through the Guides and How-to's has left me a big puzzled. Looking at the "Database Adapter Roadmap", it looks like there isn't a direct adapter for SQLServer. is this correct? Will the Oracle adapter work on NT? If not, is my only choice to use the ODBC adapter? Or the ZJetAdapter for MS-Access (which I don't think would be sufficient for my needs)? Any suggestions for database selection on NT will be appreciated. Thanks, Brad
We have been running an in house (approxiamately 100 users) contact management and order process site on NT 4.0 for several months now using Visual FoxPro as the back end database (on a different NT machine) via ODBC and have had few problems. The zope machine is a dell P3-400 w/256megs of ram. The db machine is a generic P2-200 with 512megs of ram. They are connected through a 100mbits intelligent switch. However both machines now have dual port 100 mbits cards and we are in the processs of using the extra port on each card to direct connect the 2 machine. Our application is db intensive (every sql method involves at least 1 wrapper call to determine the AUTHENTICATED_USER's access level) Unless there is network congestion and can display an order form (2 frames each the result of 5 to 10 sql methods) in about 2 to 3 seconds. (Response is 3 to 6 times faster via browser and ZOPE than throught the VFP apps that were originallly written to 2 this. ) VFP makes a very fast backend because if you are using only indexed columns and/or expressions the it can determine the record or records entirely from the indexes meaning it never pulls data out of the data file till it knows exactly which records to get. Single record lookups - even with complex queries - are almost instantaneous. __________________________________________________________________ Jim Sanford . Database/Web Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford@atinucleus.com Web: http://www.atinucleus.com Nucleus. All You NEED in an RTOS. Royalty Free. __________________________________________________________________ ----- Original Message ----- From: Brad Crittenden <bac@ivc.com> To: <zope@zope.org> Sent: Thursday, March 02, 2000 1:06 PM Subject: [Zope] [Newbie] SQL database support on NT Hello All: I'm just beginning to play with zope and really like what I see. No Zen yet but it's coming. The project I'm working on must use NT as the server, much to my displeasure. I need to select a SQL database for the project and need to find one that will work and play well with zope. Searching through the Guides and How-to's has left me a big puzzled. Looking at the "Database Adapter Roadmap", it looks like there isn't a direct adapter for SQLServer. is this correct? Will the Oracle adapter work on NT? If not, is my only choice to use the ODBC adapter? Or the ZJetAdapter for MS-Access (which I don't think would be sufficient for my needs)? Any suggestions for database selection on NT will be appreciated. Thanks, Brad _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Hi,
Looking at the "Database Adapter Roadmap", it looks like there isn't a direct adapter for SQLServer. is this correct? Will the Oracle adapter work on NT?
The Oracle adapter will work but not with SQL-server.
If not, is my only choice to use the ODBC adapter? Or the ZJetAdapter for MS-Access (which I don't think would be sufficient for my needs)?
Your only choice is the ODBC adapter if you want tyo use SQL-server. We're running Zope on a NT server with SQL-server as database. It works very well. Henny van der Linde
In article <NDBBLMHEELDKLGHEEMJPIEMMCBAA.bac@ivc.com>, Brad Crittenden <bac@ivc.com> writes
Any suggestions for database selection on NT will be appreciated.
I am using Interbase 5.6 with ODBC. It sucks. 2-3 x a week the ODBC connection gets lost, and the Zope ODBC adapter refuses to reconnect. It usually happens after I enter the management screens as well. I have to shut Zserver down, and restart it. I think the problem must be the ODBC driver supplied by Interbase Corp. I'll probably shift it over to MS Sqlserver as people don't seem to report problems there. ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.co.nz - running Zope when ODBC allows... http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin
participants (4)
-
Brad Crittenden -
Graham Chiu -
Henny van der Linde -
Jim Sanford