Re: [SQLObject] Creating a sqlite connection on Windows

[Ian B. <ia...@co...>]

M@ McCray wrote:
> I'm using SQLObject from SVN (rev 206) on Windows. I'm trying to connect to a
> sqlite database on a drive other than C: -- it's failing. It's failing because
> the leading slash '/' from the connection URI is being used in the filename for
> the database. So you wind up with something like:
> 
> /E:\My Test\test.db
> 
> Which doesn't work, obviously. I've tried various combinations of connection
> URIs but they all send the leading slash to sqlite.
> 
> It seems like it could be as simple as stripping the leading slash from the URI
> in SQLiteConnection.connectionFromURI(), or maybe in the constructor. But that
> might not be great for non-Windows OSes?
> 
> Now to my question: Is this just a bug I need to enter, or is there some other
> way of handling this in SQLObject that I'm just not aware of?

You should enter it as a bug.  If I don't fix it in code, I'd at least 
fix it in documentation.

For now, you should be able to use SQLiteConnection('E:/My 
Text/test.db') to define the connection.

-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org