How to support such a statement "ATTACH DATABASE x AS y KEY z"?

[kamylee]

How to support such a statement "ATTACH DATABASE x AS y KEY z"?

sqlite3* db = 0;
ret = sqlite3_open("test2.db", &db);
std::string sqlTemp = "ATTACH DATABASE 'test2.db' AS test2 KEY '123456';";
sqlite3_exec(db, sqlTemp.c_str(), NULL, NULL, &pErrMsg);

But it made a mistake: file is not a database.

[DelinWorks]

are you using the default sqlite library? if so then from my experience I don't think it supports keys and encryption and that's because I noticed you were trying to attach and rename an encrypted (or to be encrypted) database file from the statement in your example code, you should use an encryption library capable of this, this one is great and open source! I tried it and it worked right out of the box! Sqleet