Python Database Error

Question

When I put my database file (which is a .sdb) into a directory and try to access it from that directory, I receive an error. The error reads "unable to open database file". For example, let's say my .sdb file is in the "data" directory and I use the command "con = lite.connect('data\noktalar.sdb')", this error occurs. Why is that so?

Thanks.

I think, that is because you are using \n within that string which is geting interpreted as newline. Use raw-string and see my answer below. — Senthil Kumaran
– Senthil Kumaran, Commented Mar 16, 2011 at 6:24

Wang Dingwei · Accepted Answer · 2011-03-16 07:45:26Z

1

\ is the escape character in python strings. You have to use double backslashes:

con = lite.connect('data\\noktalar.sdb')

Or like Senthil said, use raw strings:

con = lite.connect(r'data\noktalar.sdb')

For more information, check the Python doc about string literals.

answered Mar 16, 2011 at 7:45

Wang Dingwei

4,8896 gold badges34 silver badges44 bronze badges

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

Comments

Senthil Kumaran · Accepted Answer · 2011-03-16 06:23:08Z

1

Where is your python process running from? Try to point to the absolute path of the file. And when pointing to path use raw string r'c:\\mypath\data\notktalar.sub'

answered Mar 16, 2011 at 6:23

Senthil Kumaran

57.3k15 gold badges99 silver badges139 bronze badges

1 Comment

Shansal Over a year ago

Thanks. You solved my problem. Actually I dont need to specify the full path. r'data\noktalar.sdb' is enough.

Collectives™ on Stack Overflow

Python Database Error

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related