[racket] Require error

From: Alvin Schatte (AlvinSchatte at skytex.net)
Date: Wed Jul 14 08:24:18 EDT 2010

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)
AlvinSchatte at skytex.net


-----Original Message-----
From: Todd O'Bryan [mailto:toddobryan at gmail.com] 
Sent: Monday, July 12, 2010 3:02 PM
To: Alvin Schatte
Cc: users at racket-lang.org
Subject: Re: [racket] Require error

Have you installed SQLite3 on your computer?

On Mon, Jul 12, 2010 at 2:59 PM, Alvin Schatte <AlvinSchatte at skytex.net>
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)
>
> AlvinSchatte at skytex.net
>
>
>
>
>
> _________________________________________________
>  For list-related administrative tasks:
>  http://lists.racket-lang.org/listinfo/users
>



Posted on the users mailing list.