search

pawelsalawa / sqlitestudio

A free, open source, multi-platform SQLite database manager.
https://sqlitestudio.pl
Other
5.19k stars 579 forks source link

Could not add database (Any Database Type/Engine Fails) #3530

Closed lavanyadeepak closed 4 years ago

lavanyadeepak commented 5 years ago

I have tried selecting each of the database type in the dropdown but getting the standard message

Could not add database

Is there some log generated on what exactly is failing when trying to open the file?

image

pawelsalawa commented 5 years ago

Do you know what database engine was this file created with in the first place?

lavanyadeepak commented 5 years ago

Actually it were created by an older team who is no longer available. Is there a way we can introspect from the .db file itself?

From: Paweł Salawa notifications@github.com Sent: Monday, June 10, 2019 6:28 PM To: pawelsalawa/sqlitestudio Cc: lavanyadeepak; Author Subject: Re: [pawelsalawa/sqlitestudio] Could not add database (Any Database Type/Engine Fails) (#3530)

Do you know what database engine was this file created with in the first place?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/pawelsalawa/sqlitestudio/issues/3530?email_source=notifications&email_token=AAQ5PRWHW4DVTF3BOYS7Q73PZZFYHA5CNFSM4HWSUXB2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODXJZUZY#issuecomment-500406887, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAQ5PRU7JD47SCXOXOFQAMLPZZFYHANCNFSM4HWSUXBQ.

pawelsalawa commented 5 years ago

SQLite 2 & 3 are not encrypted, thus you could see a literal "SQLite 3" or "SQLite 2" in file header when you open it with notepad. That being said, if it was either of these two, SQLiteStudio would open them without an issue.

If it's one of encrypted SQLite databases, you need to know correct password. Unfortunately there is no way to know if the password is incorrect, or if the file is not SQLite database at all. You either know it's SQLite file, you know which algorithm was used (SQLCipher, WxSQLite3, System.Data.SQLite) and what was the password, or you don't know them and you won't be able to open it. Sorry.

There is a way to show error message of connection test (answering your question from original post), but I don't think it will help you much. Anyway, to see the message you need to start SQLiteStudio in debug mode (from command line: SQLiteStudio.exe -d). Then in the application hit F12 key, it will open debug console. Then you can try opening your database. After error, you can look into debug console to see error message.

lavanyadeepak commented 5 years ago

Here is my debug information:

[18:11:42.567] DEBUG: Using configuration directory: "C:/Users/LavanyaDeepak/AppData/Roaming/sqlitestudio" [18:11:43.158] DEBUG: Following plugins found: ("SqlExport", "SqlFormatterSimplePlugin", "PdfExport", "MultiEditorImagePlugin", "ConfigMigration", "XmlExport", "RegExpImport", "DbSqliteCipher", "HtmlExport", "DbSqlite2", "ScriptingTcl", "JsonExport", "DbSqliteSystemData", "DbSqliteWx", "CsvImport", "DbAndroid", "SqlEnterpriseFormatter", "CsvExport", "Printing") [18:11:43.159] DEBUG: "SqlExport" loaded: "C:/Program Files/SQLiteStudio/plugins/SqlExport.dll" [18:11:43.160] DEBUG: "PdfExport" loaded: "C:/Program Files/SQLiteStudio/plugins/PdfExport.dll" [18:11:43.161] DEBUG: "MultiEditorImagePlugin" loaded: "C:/Program Files/SQLiteStudio/plugins/MultiEditorImage.dll" [18:11:43.163] DEBUG: "ConfigMigration" loaded: "C:/Program Files/SQLiteStudio/plugins/ConfigMigration.dll" [18:11:43.164] DEBUG: "XmlExport" loaded: "C:/Program Files/SQLiteStudio/plugins/XmlExport.dll" [18:11:43.165] DEBUG: "RegExpImport" loaded: "C:/Program Files/SQLiteStudio/plugins/RegExpImport.dll" [18:11:43.166] DEBUG: "DbSqliteCipher" loaded: "C:/Program Files/SQLiteStudio/plugins/DbSqliteCipher.dll" [18:11:43.167] DEBUG: "HtmlExport" loaded: "C:/Program Files/SQLiteStudio/plugins/HtmlExport.dll" [18:11:43.169] DEBUG: "DbSqlite2" loaded: "C:/Program Files/SQLiteStudio/plugins/DbSqlite2.dll" [18:11:43.173] DEBUG: "ScriptingTcl" loaded: "C:/Program Files/SQLiteStudio/plugins/ScriptingTcl.dll" [18:11:43.174] DEBUG: "JsonExport" loaded: "C:/Program Files/SQLiteStudio/plugins/JsonExport.dll" [18:11:43.175] DEBUG: "DbSqliteSystemData" loaded: "C:/Program Files/SQLiteStudio/plugins/DbSqliteSystemData.dll" [18:11:43.176] DEBUG: "DbSqliteWx" loaded: "C:/Program Files/SQLiteStudio/plugins/DbSqliteWx.dll" [18:11:43.177] DEBUG: "CsvImport" loaded: "C:/Program Files/SQLiteStudio/plugins/CsvImport.dll" [18:11:43.186] DEBUG: "SqlEnterpriseFormatter" loaded: "C:/Program Files/SQLiteStudio/plugins/SqlEnterpriseFormatter.dll" [18:11:43.187] DEBUG: "CsvExport" loaded: "C:/Program Files/SQLiteStudio/plugins/CsvExport.dll" [18:11:43.192] DEBUG: "Printing" loaded: "C:/Program Files/SQLiteStudio/plugins/Printing.dll" [18:11:43.194] DEBUG: Loading form file: ":/forms/CsvExport.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/CsvImportOptions.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/htmlexport.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/jsonexport.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/pdfexport.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populateconstant.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populatedictionary.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populaterandom.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populaterandomtext.ui" [18:11:43.194] DEBUG: Loading form file: ":/forms/plugins/populatescript.ui" [18:11:43.195] DEBUG: Loading form file: ":/forms/plugins/populatesequence.ui" [18:11:43.195] DEBUG: Loading form file: ":/forms/regexpimport.ui" [18:11:43.195] DEBUG: Loading form file: ":/forms/sqlenterpriseformatter.ui" [18:11:43.195] DEBUG: Loading form file: ":/forms/SqlExportCommon.ui" [18:11:43.195] DEBUG: Loading form file: ":/forms/SqlExportQuery.ui" [18:11:43.195] DEBUG: Loading form file: ":/forms/XmlExport.ui" [18:11:43.312] DEBUG: Error from notify manager: "Could not add database D:\Projects\LDTestBench.db: ; ; ; ; " [18:11:43.315] DEBUG: Error from notify manager: "Could not add database D:\Projects\LDTestBench.db to list." [18:11:46.896] DEBUG: Update QProcess finished with code: 1

pawelsalawa commented 5 years ago

It means even SQLite library does not provide concrete error message. Sorry, I won't be able to tell you anything more.