Can't open sqlite db on ios

Question

Hi I'm trying to create an sqlite database in ios. I use the method sqlite3_open with the params needed but i always get the error 14 (SQLITE_CANTOPEN 14 /* Unable to open the database file */).

It does't work even with its simplest declaration

NSFileManager *fileMgr = [NSFileManager defaultManager];
NSString *dbPath = [[[NSBundle mainBundle] resourcePath ]stringByAppendingPathComponent:@"data.sqlite3"];

BOOL success = [fileMgr fileExistsAtPath:dbPath];

sqlite3 *db;

if(!success)
{
    NSLog(@"Cannot locate database file '%@'.", dbPath);
}

if(!(sqlite3_open([dbPath UTF8String], &db) == SQLITE_OK))
{
    NSLog(@"An error has occured.");
}
else{
    NSLog(@"Ok");
}

Any ideas what's happening?

Thanks.

stackoverflow.com/questions/4486254/sqlite-database-error-14 — Baby Groot
– Baby Groot, Commented Feb 27, 2013 at 13:01
Probably not helpful in this case, but in general, when you get a bad return code do NSLog(@"SQLite errmsg = %s", sqlite3_errmsg());, to get the text error message. — Hot Licks
– Hot Licks, Commented Sep 6, 2013 at 18:10

Owen Hartnett · Accepted Answer · 2013-02-27 17:37:34Z

4

You can't get write access to a sqlite database in your application bundle. Instead, copy the database in the bundle into the "file" system, in an appropriate place (given iCloud concerns), and then open it there. Have your app look for the database in the file system first and only copy it if it's not there.

answered Feb 27, 2013 at 17:37

Owen Hartnett

5,9352 gold badges21 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Owen Hartnett Over a year ago

They should all be this easy!

Mahesh Aswathanarayana · Accepted Answer · 2013-09-06 18:06:59Z

1

use document directory to store the database file and then create sqlite.... it works

answered Sep 6, 2013 at 18:06

Mahesh Aswathanarayana

16110 bronze badges

Comments

Gratzy · Accepted Answer · 2024-01-09 22:51:01Z

I was on this issue today with my own app in .net Maui but I believe it applies to this issue as well.

I, too, was trying to create a sqlite db using params in the documents folder.

However, it wasn't until I removed the params that the db actually created.

I recognize the asker's question is related to xcode, but I believe .net Maui's sqlite is the same.

        string appFolder = FileSystem.Current.AppDataDirectory;
        string fileNameMod = Path.Combine(appFolder,fileName);

        if (!fileNameMod.Contains(".db"))
        {
            fileNameMod += ".db";
        }

        using (SQLiteConnection con = new SQLiteConnection(fileNameMod)) // note it's only the file name, no params
        {
            // con.open does not exist, connection is already open here

Collectives™ on Stack Overflow

Can't open sqlite db on ios

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related