Can't you run the installer first against the Access db and upgrade to Oracle after running the installer?
Simon -----Original Message----- From: Miranda, Esther [mailto:[EMAIL PROTECTED] Sent: maandag 7 november 2005 15:39 To: Spectra-Talk Subject: Spectra 1.5.3 installation on ORACLE (RESERVED WORDS conflict) Hi, I'm installing spectra 1.5.3. and I have migrated the MS ACCESS table to ORACLE 9 (9.2.0.5.0) successfully. However, when running the installer, I get the following message: Security Configuration Error The error message returned is: Application () Security Policy action failed unexpectedly: Add Security Context Error. Security Policy action failed unexpectedly: GetRule. Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle] ORA-00923: FROM keyword not found were expected. I've tracked this down to the _getrule.cfm file (called from cfa_newinternaladminsecurity.cfm) which tries to query the rules.secure_object as resource. This query fails because resource is an ORACLE RESERVED WORD. The solution is of course to add double quotes around it in ALL the queries :-/ Anybody found another way to avoid adapting the source code ?? Thanx, Esther ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Now thereâs a better way to fax. eFax makes it possible to use your existing email account to send and receive faxes. Try eFax free. http://www.houseoffusion.com/banners/view.cfm?bannerid=63 Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5687 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.17 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
