RE: [Zope] Need help with ZJetDA, Winnt4 and Zope 2.2.1
I appreciate your response. I had copied the data.fs over to the server with no success. I have the (buzzword alert)"web app" up and running on ZODBCDA. I still haven't solved the ZJetDA problem, but with ODBC, I may well ignore it. I wonder if iODBC or unixODBC is able to connect to access. I will let you know if I figure it out. My Zope versions are the same and I have the same products on each. I think I must have screwed up my permissions somewhere, but I think it might be on the NT side instead of Zope. I say this because the superuser cannot test the adapter successfully with permissions wide open with and without acquisision. More to come. Thanks. Troy -Original Message- From: Rik Hoekstra [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 4:33 AM To: Farrell, Troy Cc: '[EMAIL PROTECTED]' Subject: Re: [Zope] Need help with ZJetDA, Winnt4 and Zope 2.2.1 "Farrell, Troy" wrote: > > As you have no doubt heard my cries for help, I figure that very few are > running NT4. More than would admit it, probably. Perhaps no one knows the answer to what seems to be a rather specific situation. For one, I have the impression most people use zodbc connections to access database then use the zjetadapter (so do I, so chances are I might be just blabbering). > I am having a permissions difficultie with ZJetDA trying to > modify data in an Access97 database. On my server, the DA is able to SELECT > * FROM tablename with no problem, but when it comes to INSERT INTO tablename > VALUES (...) or UPDATE, I get a Query Error with a value of INVALID > OPERATION. I mirror (It is identical, i checked 5+ times) all the objects > on my NT4 laptop and it works ok. The databases are Identical, I copied the > working one to the non-working server and still no go. The traceback is as > follows: > hm one stupid question: isn't by accident the working one read-only by accident (this happened to me more than once and it _will_ happen if the access file is not copied properly. Who knows what copying properly is - please speak up). > __call__ > (Object: bmsdb_jet_select_browse_state_sub_insert_into_temptablebrowse) > File C:\PROGRA~1\JESTER\lib\python\Products\ZJetDA\db.py, line 130, in > query > Query Error: (see above) you could try this with the zodbc adapter. Please make sure you odbc connection is made under the system account though. > > Rant: > I've been working on this for days. I don't seem to understand the security > model since I didn't have any problems before 2.2.x. If I cannot get this > resolved, I'll move back to the 2.1.x series. I really want this to work as > it is my companie's introduction to open source software. Have a :) day. hm is the Zope version the same on your laptop and your server then? If so, then the security thing should be the same on both, right? If not - then how can you say all objects are the same? Did you copy you data.fs database from one machine to the other? success, let us know how it goes hth Rik ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Need help with ZJetDA, Winnt4 and Zope 2.2.1
"Farrell, Troy" wrote: > > As you have no doubt heard my cries for help, I figure that very few are > running NT4. More than would admit it, probably. Perhaps no one knows the answer to what seems to be a rather specific situation. For one, I have the impression most people use zodbc connections to access database then use the zjetadapter (so do I, so chances are I might be just blabbering). > I am having a permissions difficultie with ZJetDA trying to > modify data in an Access97 database. On my server, the DA is able to SELECT > * FROM tablename with no problem, but when it comes to INSERT INTO tablename > VALUES (...) or UPDATE, I get a Query Error with a value of INVALID > OPERATION. I mirror (It is identical, i checked 5+ times) all the objects > on my NT4 laptop and it works ok. The databases are Identical, I copied the > working one to the non-working server and still no go. The traceback is as > follows: > hm one stupid question: isn't by accident the working one read-only by accident (this happened to me more than once and it _will_ happen if the access file is not copied properly. Who knows what copying properly is - please speak up). > __call__ > (Object: bmsdb_jet_select_browse_state_sub_insert_into_temptablebrowse) > File C:\PROGRA~1\JESTER\lib\python\Products\ZJetDA\db.py, line 130, in > query > Query Error: (see above) you could try this with the zodbc adapter. Please make sure you odbc connection is made under the system account though. > > Rant: > I've been working on this for days. I don't seem to understand the security > model since I didn't have any problems before 2.2.x. If I cannot get this > resolved, I'll move back to the 2.1.x series. I really want this to work as > it is my companie's introduction to open source software. Have a :) day. hm is the Zope version the same on your laptop and your server then? If so, then the security thing should be the same on both, right? If not - then how can you say all objects are the same? Did you copy you data.fs database from one machine to the other? success, let us know how it goes hth Rik ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Need help with ZJetDA, Winnt4 and Zope 2.2.1
As you have no doubt heard my cries for help, I figure that very few are running NT4. I am having a permissions difficultie with ZJetDA trying to modify data in an Access97 database. On my server, the DA is able to SELECT * FROM tablename with no problem, but when it comes to INSERT INTO tablename VALUES (...) or UPDATE, I get a Query Error with a value of INVALID OPERATION. I mirror (It is identical, i checked 5+ times) all the objects on my NT4 laptop and it works ok. The databases are Identical, I copied the working one to the non-working server and still no go. The traceback is as follows: Traceback (innermost last): File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\PROGRA~1\JESTER\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\PROGRA~1\JESTER\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: browsestates) File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: browsestates) File C:\PROGRA~1\JESTER\lib\python\OFS\DTMLDocument.py, line 177, in __call__ (Object: browsestates) File C:\PROGRA~1\JESTER\lib\python\DocumentTemplate\DT_String.py, line 528, in __call__ (Object: browsestates) File C:\PROGRA~1\JESTER\lib\python\Shared\DC\ZRDB\DA.py, line 450, in __call__ (Object: bmsdb_jet_select_browse_state_sub_insert_into_temptablebrowse) File C:\PROGRA~1\JESTER\lib\python\Products\ZJetDA\db.py, line 130, in query Query Error: (see above) Rant: I've been working on this for days. I don't seem to understand the security model since I didn't have any problems before 2.2.x. If I cannot get this resolved, I'll move back to the 2.1.x series. I really want this to work as it is my companie's introduction to open source software. Have a :) day. Thanks. Troy Troy Farrell Video Operations Technician II Williams VYVX Services 918.573.3029 918.573.1441 fax mailto:[EMAIL PROTECTED] http://www.williams.com ___ Zope maillist - [EMAIL PROTECTED] 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 )