
I've encountered another problem while trying to install 'HDBC-sqlite3'. I did the install "manually", instead of using Cabal, and during the build phase, received the following error message: D:\Apps\ghc\ghc-6.10.1\HDBC-sqlite3-2.1.0.0>runghc Setup build Preprocessing library HDBC-sqlite3-2.1.0.0... Database\HDBC\Sqlite3\Statement.hsc:41:21: sqlite3.h: No such file or directory Database\HDBC\Sqlite3\Statement.hsc: In function `main': Database\HDBC\Sqlite3\Statement.hsc:137: error: `SQLITE_NULL' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:137: error: (Each undeclared identifier is reported only once Database\HDBC\Sqlite3\Statement.hsc:137: error: for each function it appears in.) Database\HDBC\Sqlite3\Statement.hsc:148: error: `SQLITE_ROW' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:149: error: `SQLITE_DONE' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:150: error: `SQLITE_ERROR' undeclared (first use in this function) compiling dist\build\Database\HDBC\Sqlite3\Statement_hsc_make.c failed Is the file 'sqlite3.h' missing? Or am I doing something wrong? Thanks, David.

I think you need to install sqlite3 first. This is just a binding to the C
library.
On Fri, Feb 20, 2009 at 7:16 PM, David
I've encountered another problem while trying to install 'HDBC-sqlite3'. I did the install "manually", instead of using Cabal, and during the build phase, received the following error message:
D:\Apps\ghc\ghc-6.10.1\HDBC-sqlite3-2.1.0.0>runghc Setup build Preprocessing library HDBC-sqlite3-2.1.0.0... Database\HDBC\Sqlite3\Statement.hsc:41:21: sqlite3.h: No such file or directory Database\HDBC\Sqlite3\Statement.hsc: In function `main': Database\HDBC\Sqlite3\Statement.hsc:137: error: `SQLITE_NULL' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:137: error: (Each undeclared identifier is reported only once Database\HDBC\Sqlite3\Statement.hsc:137: error: for each function it appears in.) Database\HDBC\Sqlite3\Statement.hsc:148: error: `SQLITE_ROW' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:149: error: `SQLITE_DONE' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:150: error: `SQLITE_ERROR' undeclared (first use in this function) compiling dist\build\Database\HDBC\Sqlite3\Statement_hsc_make.c failed
Is the file 'sqlite3.h' missing? Or am I doing something wrong?
Thanks, David. _______________________________________________ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe
-- Sebastian Sylvan +44(0)7857-300802 UIN: 44640862

I think you're right. I didn't realize I had to install Sqlite before
installing and building the HDBC-sqlite package. So I did that, but
now I'm getting a different error, because the DLL for Sqlite isn't
getting found. How do I tell the build process where the DLL is?
Here's the new error message:
D:\Apps\ghc\ghc-6.10.1\HDBC-sqlite3-2.1.0.0>runghc Setup build
Preprocessing library HDBC-sqlite3-2.1.0.0...
D:\Apps\ghc\ghc-6.10.1\gcc-lib\ld.exe: cannot find -lsqlite3
collect2: ld returned 1 exit status
linking dist\build\Database\HDBC\Sqlite3\Statement_hsc_make.o failed
Thanks for your help!
David.
On Fri, Feb 20, 2009 at 2:25 PM, Sebastian Sylvan
I think you need to install sqlite3 first. This is just a binding to the C library.
On Fri, Feb 20, 2009 at 7:16 PM, David
wrote: I've encountered another problem while trying to install 'HDBC-sqlite3'. I did the install "manually", instead of using Cabal, and during the build phase, received the following error message:
D:\Apps\ghc\ghc-6.10.1\HDBC-sqlite3-2.1.0.0>runghc Setup build Preprocessing library HDBC-sqlite3-2.1.0.0... Database\HDBC\Sqlite3\Statement.hsc:41:21: sqlite3.h: No such file or directory Database\HDBC\Sqlite3\Statement.hsc: In function `main': Database\HDBC\Sqlite3\Statement.hsc:137: error: `SQLITE_NULL' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:137: error: (Each undeclared identifier is reported only once Database\HDBC\Sqlite3\Statement.hsc:137: error: for each function it appears in.) Database\HDBC\Sqlite3\Statement.hsc:148: error: `SQLITE_ROW' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:149: error: `SQLITE_DONE' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:150: error: `SQLITE_ERROR' undeclared (first use in this function) compiling dist\build\Database\HDBC\Sqlite3\Statement_hsc_make.c failed
Is the file 'sqlite3.h' missing? Or am I doing something wrong?
Thanks, David. _______________________________________________ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe
-- Sebastian Sylvan +44(0)7857-300802 UIN: 44640862

I thin you need to use the following two options to point cabal configure to
the right include and lib directories:--extra-include-dirs=*dir*
--extra-lib-dirs=*dir*
On Fri, Feb 20, 2009 at 8:20 PM, David
I think you're right. I didn't realize I had to install Sqlite before installing and building the HDBC-sqlite package. So I did that, but now I'm getting a different error, because the DLL for Sqlite isn't getting found. How do I tell the build process where the DLL is?
Here's the new error message:
D:\Apps\ghc\ghc-6.10.1\HDBC-sqlite3-2.1.0.0>runghc Setup build Preprocessing library HDBC-sqlite3-2.1.0.0... D:\Apps\ghc\ghc-6.10.1\gcc-lib\ld.exe: cannot find -lsqlite3 collect2: ld returned 1 exit status linking dist\build\Database\HDBC\Sqlite3\Statement_hsc_make.o failed
Thanks for your help!
David.
On Fri, Feb 20, 2009 at 2:25 PM, Sebastian Sylvan
wrote: I think you need to install sqlite3 first. This is just a binding to the C library.
On Fri, Feb 20, 2009 at 7:16 PM, David
wrote: I've encountered another problem while trying to install 'HDBC-sqlite3'. I did the install "manually", instead of using Cabal, and during the build phase, received the following error message:
D:\Apps\ghc\ghc-6.10.1\HDBC-sqlite3-2.1.0.0>runghc Setup build Preprocessing library HDBC-sqlite3-2.1.0.0... Database\HDBC\Sqlite3\Statement.hsc:41:21: sqlite3.h: No such file or directory Database\HDBC\Sqlite3\Statement.hsc: In function `main': Database\HDBC\Sqlite3\Statement.hsc:137: error: `SQLITE_NULL' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:137: error: (Each undeclared identifier is reported only once Database\HDBC\Sqlite3\Statement.hsc:137: error: for each function it appears in.) Database\HDBC\Sqlite3\Statement.hsc:148: error: `SQLITE_ROW' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:149: error: `SQLITE_DONE' undeclared (first use in this function) Database\HDBC\Sqlite3\Statement.hsc:150: error: `SQLITE_ERROR' undeclared (first use in this function) compiling dist\build\Database\HDBC\Sqlite3\Statement_hsc_make.c failed
Is the file 'sqlite3.h' missing? Or am I doing something wrong?
Thanks, David. _______________________________________________ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe
-- Sebastian Sylvan +44(0)7857-300802 UIN: 44640862
-- Sebastian Sylvan +44(0)7857-300802 UIN: 44640862

On Fri, 2009-02-20 at 14:16 -0500, David wrote:
I've encountered another problem while trying to install 'HDBC-sqlite3'. I did the install "manually", instead of using Cabal, and during the build phase, received the following error message:
D:\Apps\ghc\ghc-6.10.1\HDBC-sqlite3-2.1.0.0>runghc Setup build Preprocessing library HDBC-sqlite3-2.1.0.0... Database\HDBC\Sqlite3\Statement.hsc:41:21: sqlite3.h: No such file or directory
I'd just like to note that as of Cabal-1.6.0.2 you'll get rather more helpful error messages in this situation: cabal: Missing dependency on a foreign library: * Missing header file: sqlite3.h * Missing C library: sqlite3 This problem can usually be solved by installing the system package that provides this library (you may need the "-dev" version). If the library is already installed but in a non-standard location then you can use the flags --extra-include-dirs= and --extra-lib-dirs= to specify where it is. Hopefully this would be sufficiently clear. Duncan
participants (3)
-
David
-
Duncan Coutts
-
Sebastian Sylvan