Sqlite Error: file is not a database

Create database without the .db extension.
for e.g. sqlite3 users //this creates a database names users

The error can occur when a database was created with cipher.
So sqlite3_open succeded but any sqlite3_exec or sqlite3_prepare will be failed with this error.