I am running an Ultralite database - version 22.214.171.12460 with .NET CF 3.5 on a Win 6.5 handheld. Something crashed today while performing normal work (we've been running this software for years) and it looks like we've lost a database. Here are the details when trying to connect to the .udb with Sybase Central:
[ODBC] [UltraLite Database] Internal database error 100005 -- transaction rolled back Error code=-301 SQL state=40W01
What can I do to recover the database?
Please help! Thank you in advance!
asked 03 Dec '14, 11:45
The 100005 internal error is usually fatal; it is a report that the metadata has been corrupted. This is most likely related to a file system/media failure.
You can attempt to unload the data using the ulunload utility (or dbisql) but if that also reports the same error your database is unusable; and will need to replace the database and recreate any missing data.
To help avoid any future occurrences, you should run with a newer build of 12.0.1 to avoid the issue addressed by engineering change#693111: - "Files were not always properly flushed to the storage medium on CE."
That fix was checked into the 12.0.1#3578 build and has the description
answered 04 Dec '14, 10:40
Nick Elson S...