Hello Todd, Thanks for your help. I have SQLite3 installed now (unzipped and copied to Window\system32 directory), but there is no libsqlite3.dll. I renamed the sqlite3.dll to libsqlite3.dll and am now getting:
" c:\documents and settings\alvin.schatte\my documents\projects\racket\blog demo\model-3.rkt:42:23: Servlet (@ /servlets/standalone.rkt) exception: SQLite Error: File opened that is not a database file" With the following exception dump in the browser: Exception The application raised an exception with the message: SQLite Error: File opened that is not a database file Stack trace: sqlite-error at: line 59, column 0, in file C:\Documents and Settings\alvin.schatte\Application Data\Racket\planet\300\5.0\cache\jaymccarthy\sqlite.plt\4\6\sqlite.ss prepare at: line 139, column 0, in file C:\Documents and Settings\alvin.schatte\Application Data\Racket\planet\300\5.0\cache\jaymccarthy\sqlite.plt\4\6\sqlite.ss exec at: line 336, column 0, in file C:\Documents and Settings\alvin.schatte\Application Data\Racket\planet\300\5.0\cache\jaymccarthy\sqlite.plt\4\6\sqlite.ss select at: line 303, column 0, in file C:\Documents and Settings\alvin.schatte\Application Data\Racket\planet\300\5.0\cache\jaymccarthy\sqlite.plt\4\6\sqlite.ss blog-posts at: line 37, column 0, in file c:\documents and settings\alvin.schatte\my documents\projects\racket\blog demo\model-3.rkt render-posts at: line 641, column 0, in file c:\documents and settings\alvin.schatte\my documents\projects\racket\blog demo\15 using an sql database.rkt response-generator at: line 539, column 10, in file c:\documents and settings\alvin.schatte\my documents\projects\racket\blog demo\15 using an sql database.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 118, column 10, in file C:\Program Files\Racket\collects\web-server\servlet\web.rkt send/suspend/dispatch at: line 112, column 0, in file C:\Program Files\Racket\collects\web-server\servlet\web.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 57, column 2, in file C:\Program Files\Racket\collects\web-server\dispatchers\dispatch-servlets.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt select-handler/no-breaks at: line 173, column 2, in file C:\Program Files\Racket\collects\racket\private\more-scheme.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt <unknown procedure> at: line 1434, column 3, in file C:\Program Files\Racket\collects\racket\contract\private\arrow.rkt connection-loop at: line 62, column 2, in file C:\Program Files\Racket\collects\web-server\private\dispatch-server-unit.rkt Thanks for your help, Alvin Schatte 12399 S. Hwy 121 Trenton, TX 75490 903/989-5503 (Home) 469/734-6987 (cell) [email protected] -----Original Message----- From: Todd O'Bryan [mailto:[email protected]] Sent: Monday, July 12, 2010 3:02 PM To: Alvin Schatte Cc: [email protected] Subject: Re: [racket] Require error Have you installed SQLite3 on your computer? On Mon, Jul 12, 2010 at 2:59 PM, Alvin Schatte <[email protected]> wrote: > Hello, > > I am going through the tutorial: Continue: Web Applications in Racket > when I got down to 15 Using an SQL database > > , I got the error ffi-lib: couldn't open "libsqlite3.dll" (The specified > module could not be found.; errno=126) associated with (require (prefix-in > sqlite: (planet jaymccarthy/sqlite:4))). How do I resolve this error? > > Regards, > > > > Alvin Schatte > > 12399 S. Hwy 121 > > Trenton, TX 75490 > > 903/989-5503 (Home) > > 469/734-6987 (cell) > > [email protected] > > > > > > _________________________________________________ > For list-related administrative tasks: > http://lists.racket-lang.org/listinfo/users > _________________________________________________ For list-related administrative tasks: http://lists.racket-lang.org/listinfo/users
