OperationalError: unable to open database file

Question

I'm running through the Flask tutorial for a simple blog/cms and I can't seem to open/create a database.

I'm currently on Windows 7, when I go to view the app I get a sqlite3.OperationalError OperationalError: unable to open database file error on the webpage. I've tried googling the issue but I haven't been able to fix it. I assume it has to do with that I'm using Windows. Can anyone help?

DATABASE = 'C:\Users\Brad\Documents\flaskr\flaskr.db'

def connect_db():
return sqlite3.connect(app.config['DATABASE'])

def init_db():
    with closing(connect_db()) as db:
       with app.open_resource('schema.sql') as f:
        db.cursor().executescript(f.read())
    db.commit()

spatar · Accepted Answer · 2012-06-03 21:29:41Z

7

Escape your string properly:

DATABASE = 'C:\\Users\\Brad\\Documents\\flaskr\\flaskr.db'

answered Jun 3, 2012 at 21:29

spatar

5612 gold badges5 silver badges15 bronze badges

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

2 Comments

AllofHumanity Over a year ago

Thank you, I didn't notice that.

Helgi Over a year ago

@AllofHumanity: Windows understands forward slashes just fine, so you can use them as well. This will also make your code more compatible (well, besides the hard-coded parts, obviously). You might want to use os.path.join as well.

Collectives™ on Stack Overflow

OperationalError: unable to open database file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related