search

USFS-PNW / Fia-Biosum-Manager

User interface and main code repository for Biosum
http://biosum.info/
Other
3 stars 3 forks source link

Improve error handling for XE users in v5.8.9 #248

Closed lbross closed 1 year ago

lbross commented 3 years ago

Refine error handling in Validate_OracleConnectivity() method. When Oracle XE is not configured correctly BioSum errors out on the _FCSEntities.DeleteAllRecords_BIOSUM_VOLUME() call in FIADBOracleServices but no error code is set or captured so the code continues on and the error handling doesn't work. Larry indicates this is an issue in the FCSEntities.OpenConnection() routine. This is not a problem if Oracle XE is configured correctly. If it is not, the error message is Oracle:Open Connection; invalid user name/password; logon denied

lbross commented 1 year ago

Closing. We are no longer using Oracle XE.