...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"
...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"