...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@googlemail.com> To: <beginners@haskell.org> Cc: "Patrick Lynch" <kmandpjlynch@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"