sqlite3_open - Can't open database?

iphone, sqlite

Solution

Without knowing anything else about your problem, one can only assume that your path is invalid.

Try using this path to see if it works

NSArray* paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString* documentsDirectory = [paths lastObject];
NSString* databasePath = [documentsDirectory stringByAppendingPathComponent:@"mydb.sqlite"];

if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
     NSLog(@"Opened sqlite database at %@", databasePath);
    //...stuff
} else {
     NSLog(@"Failed to open database at %@ with error %s", databasePath, sqlite3_errmsg(database));
     sqlite3_close (database);
}

Problem

I have the following statement in my code: ``` if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) ``` but it doesn't seem to be opening my database. Any ideas ?

Original source