sqlite works on simulator, but not on device

Question

Hi guys

I have a question, I can't get my sqlite database to work/open on an ipad device. Everything works fine on the simulator but not a real device. I put MODE to NO when i want to test on a device but it fails to load.

    sqlite3 *database;
if (MODE) { //Simulator
    result = sqlite3_open("/Users/userID/Myapp/VRdb.sqlite", &database);
} else { // On device
    result = sqlite3_open([databasePath UTF8String], &database);
}

if(result != SQLITE_OK)
{
    sqlite3_close(database);
    view = [[UIAlertView alloc]
            initWithTitle: @"Database Error"
            message: @"Failed to open database."
            delegate: self
            cancelButtonTitle: @"OK" otherButtonTitles: nil];
    [view show];
    [view autorelease];

}

databasePath is obtained by :

databasePath = [[NSBundle mainBundle] pathForResource:@"VRdb" ofType:@"sqlite"];

Is there something that I missed?????

Answer 1

Is there actually a file at that path? Though the sqlite3_open() function will create the file if it doesn't exist, you can't create files inside the application bundle (permissions). The file actually has to already exist and be copied into the bundle as a resource at build time, then used as a template to copy to a writeable area like the documents folder.

(thanks to Peter for prompting me to realize my answer was incomplete :-) )