When I upgraded a version 2 database to a version 3 database with the same name the operation failed.The upgrade failed because the application kept saying SQL error: file is encrypted or is not a database.
C:\SQLITE> sqlite biomission.db .dump | sqlite3 biomission.db SQL error: file is encrypted or is not a database CREATE UNIQUE INDEX OneDevParamValue ON tblDeviceParams (DeviceID, DeviceParam, ParamValue); SQL error: file is encrypted or is not a database CREATE UNIQUE INDEX login ON tblSecurity (UserName,Password); SQL error: file is encrypted or is not a database INSERT INTO tblValidDeviceTypes VALUES(4,'PPS_5D_GROUN SQL error: file is encrypted or is not a database INSERT INTO tblValidDeviceTypes VALUES(4,'ET_SA'); SQL error: file is encrypted or is not a database INSERT INTO tblValidDeviceTypes VALUES(4,'ET_MAG');
When I upgraded the same database to another name no errors were shown but the new version three database that was created could not be viewed in sqlite explorer program, which views version 2 sqlite databases. Sqlite explorer program said the new database is malformed. Is the new database created invalid or is there a new sqlite explorer program that needs to be downloaded to view the new version 3 sqlite databases? Can a version 2 database not be upgraded then a version 3 database with the same name?
Thanks
Steve Frierdich