<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.18542" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>...seems like I 'kicked over another bee
hive'...plenty of messages in regard to this when you do google
search--->[<EM>sqlite3.operational error unable to open database file in
windows vista</EM>]</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...i'm getting the following error messages when I
try to create a database in Sqlite3:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>*Sandbox> dbh <- connect
"poddbtest.db"<BR>*** Exception: SqlError {seState = "", seNativeError = 21,
seErrorMsg = "prepare 6: BEGIN: unable to open database file"}</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>*Sandbox> dbh <- connect "test1.db"<BR>***
Exception: SqlError {seState = "", seNativeError = 1, seErrorMsg = "step: SQL
logic error or missing database"}</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Both come from Chapters 21 and 22 in "Real World
Haskell"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I can't invoke Sqlite3 from the command line
using---> Sqlite3 myDatabase.db...</FONT></DIV>
<DIV><FONT face=Arial size=2>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...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is it possible to specify the folder that the
database should be created in?</FONT></DIV>
<DIV><FONT face=Arial size=2>Is it possible to run Sqlite3 from the command line
- when it has been installed using the Haskell wiki?</FONT></DIV>
<DIV><FONT face=Arial size=2>Has anyone had better success with MySql - I've
used it in the past and it was very reliable?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thank you</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>