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