----- Original Message -----
Sent: Thursday, February 03, 2011 10:08
AM
Subject: Re: [Haskell-beginners] Can't
find or open a Sqlite3 database inWindows Vista
...could this be the problem...in Windows Vista I
cannot change the file name in the directory c:\Program Files
(x86)\Haskell Platform\2010.2.0.0\winghci but can change it in
c:\users\user directory...
...>
ren "c:\Program Files (x86)\Haskell
Platform\2010.2.0.0\winghci\test1.db" test2.db
Access is
denied.
...but I can see the contents of this
file:
...> type
test1.db
hello, world!
...is it possible to specify the directory
c:\users\user in ghci so that Sqlite3 will look there to open the database and
then to create a table in it?
Good day
----- Original Message -----
Sent: Wednesday, February 02, 2011 5:28
PM
Subject: [Haskell-beginners] Can't find
or open a Sqlite3 database in Windows Vista
...seems like I 'kicked over another bee
hive'...plenty of messages in regard to this when you do google
search--->[sqlite3.operational error unable to open database file in
windows vista]
...i'm getting the following error messages
when I try to create a database in Sqlite3:
*Sandbox> dbh <- connect
"poddbtest.db"
*** Exception: SqlError {seState = "", seNativeError = 21,
seErrorMsg = "prepare 6: BEGIN: unable to open database file"}
*Sandbox> dbh <- connect
"test1.db"
*** Exception: SqlError {seState = "", seNativeError = 1,
seErrorMsg = "step: SQL logic error or missing database"}
Both come from Chapters 21 and 22 in "Real
World Haskell"
I can't invoke Sqlite3 from the command line
using---> Sqlite3 myDatabase.db...
I created blank files in folder C:\Program
Files (x86)\Haskell Platform\2010.2.0.0\winghci -- seemed to get me a bit
further along...at least I was able to connect...
Is it possible to specify the folder that the
database should be created in?
Is it possible to run Sqlite3 from the command
line - when it has been installed using the Haskell wiki?
Has anyone had better success with MySql - I've
used it in the past and it was very reliable?
Thank you
_______________________________________________
Beginners mailing
list
Beginners@haskell.org
http://www.haskell.org/mailman/listinfo/beginners