sqlite error 14 [unable to open database file] iphone xcode

Question

Hi i am using database in iphone. After along time, My application gave this error

sqlite error 14 [unable to open database file]

My application is going good but some times it generates the above error.What is the solution? There is the code:

[lovkid openDatabase:[appDelegate getDBPath]];
NSString *Flag = [NSString stringWithFormat:@"%@", appDelegate.selectimage];
    int recId = (int)appDelegate.Id;
    NSLog(@"recID = %d",appDelegate.Id);

    updateStmt1 = nil;
    if(updateStmt1 == nil) 
    {

        const char *sql ="UPDATE 'char' SET `Pic`=? WHERE `id`=?";
        if(sqlite3_prepare_v2(database1, sql, -1, &updateStmt1, NULL) != SQLITE_OK)
            NSAssert1(0, @"Error while creating add statement. '%s'", sqlite3_errmsg(database1));
    }
    sqlite3_bind_text(updateStmt1, 1, [Flag UTF8String], -1, SQLITE_STATIC);
    sqlite3_bind_int(updateStmt1, 2, recId);

    if(SQLITE_DONE != sqlite3_step(updateStmt1))
        NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(database1));
    else
        NSLog(@"no error");



    sqlite3_reset(updateStmt1);
    sqlite3_finalize(updateStmt1);

...

could you provide some code showing how you are using sqlite? — sergio
– sergio, Commented May 17, 2011 at 15:44
the function you have written here looks correct. Show the function definitions of 1.openDatabase and 2. getDBPath. I am inclined to think there are missing pieces in your code. Provide these two functions and we should be able to figure this one out quick. — SayeedHussain
– SayeedHussain, Commented May 17, 2011 at 20:03

Community · Accepted Answer · 2017-05-23 12:15:12Z

1

well u need to try out my answer from the post

and make sure u write the two functions (of the post ) in ur application delgate that way ur app will open DB once

Let me Know if it worked

Cheers :)

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Apr 23, 2012 at 11:23

WaaleedKhan

6857 silver badges18 bronze badges

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

Comments

Jason Clark · Accepted Answer · 2015-11-30 12:38:46Z

-1

The SQLite error 14 can be solved by changing the settings in the directory where the database file is stored.

answered Nov 30, 2015 at 12:38

Jason Clark

1,4838 gold badges28 silver badges51 bronze badges

Collectives™ on Stack Overflow

sqlite error 14 [unable to open database file] iphone xcode

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related