On Jun 29, 2006, at 10:41 AM, Robin Munn wrote: > On 6/29/06, Kevin Dangoor <[EMAIL PROTECTED]> wrote: >> How does one specify a drive letter in an sqlite URI on Windows? >> >> Kevin > > Interesting. I experimented a bit and found out that the only format > that actually worked was: > > db = create_engine('sqlite:///c:/path/to/file/example.db') > > Yes, that's a second colon in the path. It probably should be a | > (vertical bar), but that doesn't seem to work. I don't know whether > that should be considered a bug in SQLAlchemy, or a bug in PySQLite.
Actually, my preference is for the : rather than the |. Even if it's not legal for a URI, the : is what windows users are used to. Thanks for checking it out... I was just too lazy to boot my Windows machine :) Kevin Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users