I have prepended my database connection string with a hyphen and my database continued to connect just fine. I retested a known case where a rollback was attempted (which had been resulting in an SQL error "non-transaction tables couldn't be rolled back" -- because I am purposefully using non-transaction-safe tables [MyISAM]) and the rollback error did not occur. Your suggestion apparently did the trick, at least for me! Thank you Chris Keyes!! ------------ Brian Withun Web Developer Hilgraeve, Inc. Monroe, Michigan 48161 | -----Original Message----- | From: Schmidt, Allen J. [mailto:aschmidt@nv.cc.va.us] | Sent: Friday, September 21, 2001 9:18 AM | To: 'Chris Keyes'; brianw@hilgraeve.com | Cc: zope@zope.org | Subject: RE: [Zope] RE HELP -> Non-Transaction Tables couldn't be rolled | back | | | When I do this, I get an error stating it is not a valid database name. | | -----Original Message----- | From: Chris Keyes [mailto:chrisk@nipltd.com] | Sent: Friday, September 21, 2001 5:26 AM | To: brianw@hilgraeve.com | Cc: zope@zope.org | Subject: [Zope] RE HELP -> Non-Transaction Tables couldn't be rolled | back | | | Hi Brian | | If I remember correctly I had this problem last week, and Andy Dustman who | helped us out in the Zope-DB list had this solution... | If your using the ZMySQL database adapter, start your conection | string with | a "-". This disables transactions :-) | so | -database@server.domain username password ..... | Putting a space after the - caused problems... | | Anyway hope that helps ;-) | | ChrisK | | | | | _______________________________________________ | 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 ) |