[Haskell-beginners] Can't find or open a Sqlite3 database inWindows Vista

[Patrick Lynch]

...you're right, see following - thank you...

Prelude Database.HDBC Database.HDBC.Sqlite3> conn <- connectSqlite3 
"c:\\users\\user\\test1.db"
Loading package bytestring-0.9.1.7 ... linking ... done.
Loading package Win32-2.2.0.2 ... linking ... done.
Loading package old-locale-1.0.0.2 ... linking ... done.
Loading package time-1.1.4 ... linking ... done.
Loading package old-time-1.0.0.5 ... linking ... done.
Loading package syb-0.1.0.2 ... linking ... done.
Loading package base-3.0.3.2 ... linking ... done.
Loading package mtl-1.1.0.2 ... linking ... done.
Loading package array-0.3.0.1 ... linking ... done.
Loading package containers-0.3.0.0 ... linking ... done.
Loading package convertible-1.0.9.1 ... linking ... done.
Loading package utf8-string-0.3.6 ... linking ... done.
Loading package HDBC-2.2.6.1 ... linking ... done.
Loading package HDBC-sqlite3-2.3.1.0 ... linking ... done.
Prelude Database.HDBC Database.HDBC.Sqlite3>

----- Original Message ----- 
From: "Daniel Fischer" <daniel.is.fischer at googlemail.com>
To: <beginners at haskell.org>
Cc: "Patrick Lynch" <kmandpjlynch at verizon.net>
Sent: Thursday, February 03, 2011 1:39 PM
Subject: Re: [Haskell-beginners] Can't find or open a Sqlite3 database 
inWindows Vista


On Thursday 03 February 2011 19:01:41, Patrick Lynch wrote:
> ...this doesn't work, note the back slash...also, this will only work,
> that is to create the database automatically and then subsquently create
> a table, if you user the 'users' folder...if you use 'program files,
> etal' you will not be able to create the database...bummer: Prelude
> Database.HDBC Database.HDBC.Sqlite3> conn <- connectSqlite3
> "c:\users\user\test1.db" <interactive>:1:27:
> lexical error in string/character literal at character 'u'

The backslash is the escape marker, so if you want a backslash in a String,
you have to escape it (as written, it tries to interpret the escape
sequence '\u', which doesn't exist).

Try with "c:\\users\\user\\test1.db"