...I got everything installed but am getting the following message: Prelude> :module Database.HDBC.Sqlite3 <no location info>: Could not find module `Database.HDBC.Sqlite3': it is not a module in the current program, or in any known package. ...I have the file 'sqlite3' installed in the folder: C:\users\user\downloads\sqlite-linux-x486-3070400 I'd appreciate any help... ----- Original Message ----- From: "Daniel Fischer" To: Cc: "Kathleen Lynch" Sent: Monday, January 31, 2011 10:54 AM Subject: Re: [Haskell-beginners] Installing HDBC

On Monday 31 January 2011 16:39:30, Kathleen Lynch wrote:

...

Good morning, I'm trying to install Sqlite on a Windows PC... I'm using "Real World Haskell" as a guide in regard to this... It indicates that HDBC must be installed first and points to http://hackage.haskell.org/.

I displayed this url and see the following in regard to downloading HDBC: Downloads a.. HDBC-2.2.6.1.tar.gz (Cabal source package) b.. package description (included in the package) If I'm correct, tar is a Unixy thing...

Windows can handle .tar.gz, but if you have the cabal executable (you should have it if you've installed the Haskell platform, otherwise you'll probably need it sooner or later anyway: http://www.haskell.org/cabal/download.html ), simply "cabal install HDBC" [1] in a command shell should work (unless there are some foreign [C] libraries missing, in which case you'd need to install those first).

[1] before you can cabal install something, you first need to call "cabal update" to let cabal know what is available on hackage This returned a null result - but the "cabal install HDBC' did install HDBC. In ghci: I can execute: :m Database.HDBC I then downloaded Sqlite3 using: Precompiled Binaries For Windows sqlite-shell-win32-x86-3070400.zip (275.08 KiB) A command-line shell for accessing and modifying SQLite databases. This program is compatible with all versions of SQLite through 3.7.4 and beyond. However, looks like I need to do something else, when I execute: :m Database.HDBC Database.HDBC.Sqlite3 it doesn't find Sqlite3 - the following message appears: <no location info>: Could not find module `Database.HDBC.Sqlite3': it is not a module in the current program, or in any known package. I'd appreciate any help

...

Can someone tell me how to download this to a Windows Vista PC?

Thank you

I entered the command you gave me: cabal install HDBC-sqlite3 It returned the following error: Resolving dependencies... Configuring HDBC-sqlite3-2.3.1.0... cabal: Missing dependency on a foreign library: * Missing C library: sqlite3 I then went to the link you provided: http://hackage.haskell.org/package/HDBC-sqlite3 I extracted the tar file, HDBC-sqlite3-2.3.1.0.tar, and tried to un-tar it but get the following message: "Error reading header after processing 0 entries" I'd appreciate any help... ----- Original Message ----- From: "Daniel Fischer" To: "Kathleen Lynch" Cc: Sent: Tuesday, February 01, 2011 1:33 PM Subject: Re: [Haskell-beginners] Installing HDBC

On Tuesday 01 February 2011 19:03:32, Kathleen Lynch wrote:

...

...I got everything installed but am getting the following message:

Prelude> :module Database.HDBC.Sqlite3 <no location info>: Could not find module `Database.HDBC.Sqlite3': it is not a module in the current program, or in any known package.

It's in http://hackage.haskell.org/package/HDBC-sqlite3

$ cabal install HDBC-sqlite3

(similarly for mysql, postgresql, odbc). I suppose those packages depend on having the foreign library installed, so they come alone. It's a bit annoying (especially if one is not told which packages one needs), but having to install multiple databases when one wants to use only one would be at least as bad.

Cheers, Daniel

On Tuesday 01 February 2011 20:20:22, Kathleen Lynch wrote:

I entered the command you gave me: cabal install HDBC-sqlite3 It returned the following error:     Resolving dependencies...     Configuring HDBC-sqlite3-2.3.1.0...     cabal: Missing dependency on a foreign library:     * Missing C library: sqlite3

That means you don't have the C library installed, or at least that cabal can't find it. You have to install it otherwise or put it in a directory in your %PATH%. I'm not familiar with Windows, so I can't tell you how to do that. You could search on the haskellwiki, perhaps there are instructions there.

I then went to the link you provided: http://hackage.haskell.org/package/HDBC-sqlite3 I extracted the tar file, HDBC-sqlite3-2.3.1.0.tar, and tried to un-tar it but get the following message:     "Error reading header after processing 0 entries"

If cabal complains about a missing foreign dependency, trying a manual install won't help, runhaskell ./Setup configure won't look anywhere cabal doesn't.

On Tuesday 01 February 2011 22:39:02, Kathleen Lynch wrote:

...almost a rhetorical question - but does Haskell support "Microsoft SQL Server 2005 Compact Edition"?

I doubt anybody wrote a binding yet. I didn't find anything on hackage and most library writers work on *nixen, so the likelihood isn't large. In principle, however, I see no reason why it shouldn't be possible to write a binding.

On 2/1/11 5:00 PM, Kathleen Lynch wrote:

...I put it in my PATH [C:\users\user] and put the file Sqlite3 in that folder [C:\users\user] where I'm running Cabal and extended the Cabal command as follows - nothing helps... cabal install HDBC-sqlite3 --extra-include-dirs=C:\Users\User --extra-lib-dirs=C:\Users\User

...At this point, I'm unable to install Sqlite3 and GTK...

...I know this is 'open source' but it really shouldn't be this hard to do these installations...

...I'll go back to my Monads and see if I can figure them out and then take a look at F# - I might have better luck there...

Bye Any progress on your Mac efforts? In OS X, once you've installed Xcode and the (*very important*) Unix Development Support part of it, it's as easy as:

sudo port install sqlite ...if you've also installed Macports, or "port", which is the cabal-install of the Mac world. You just run that command in the Terminal command line app (found in Applications/Utilities) and it automatically puts the app or lib that you've requested in your path, because macports adds itself and its /opt directory to your path when you install it. You'll probably find it a lot easier to add things and have cabal be able to find them, and it'll be a bit easier for others to help too, because OS X is *nix-y.

Eureeka! Your info helped...I can't thank you enough... I can now connect to the database shown in "Real World Haskell" - I was just about ready to give up... Now if I can only get GTK and my Mac to work...well we'll start that tomorrow...enuf to do today... Thank you Ps If anyone want to get a task force started in regard to installing Sqlite3 and GTK, I'll definitely participate... ----- Original Message ----- From: "Patrick LeBoutillier" To: "Kathleen Lynch" Cc: Sent: Tuesday, February 01, 2011 9:49 PM Subject: Re: [Haskell-beginners] Installing HDBC Kathleen, Grab this: http://www.sqlite.org/sqlite-dll-win32-x86-3070500.zip Extract the sqlite3.dll file from inside, copy it to c:\users\user and to c:\windows\system32 Grab: http://www.sqlite.org/sqlite-autoconf-3070500.tar.gz Extract the sqlite3.h file from inside, copy it to c:\users\user Then

cabal install HDBC-sqlite3 --extra-include-dirs=C:\Users\User --extra-lib-dirs=C:\Users\User

should work. I have only installed it though, I didn't run it. Patrick On Tue, Feb 1, 2011 at 5:00 PM, Kathleen Lynch wrote:

...I put it in my PATH [C:\users\user] and put the file Sqlite3 in that folder [C:\users\user] where I'm running Cabal and extended the Cabal command as follows - nothing helps... cabal install HDBC-sqlite3 --extra-include-dirs=C:\Users\User --extra-lib-dirs=C:\Users\User

...At this point, I'm unable to install Sqlite3 and GTK...

...I know this is 'open source' but it really shouldn't be this hard to do these installations...

...I'll go back to my Monads and see if I can figure them out and then take a look at F# - I might have better luck there...

Bye

----- Original Message ----- From: "Daniel Fischer" To: "Kathleen Lynch" Cc: Sent: Tuesday, February 01, 2011 3:07 PM Subject: Re: [Haskell-beginners] Installing HDBC

On Tuesday 01 February 2011 20:20:22, Kathleen Lynch wrote:

...

I entered the command you gave me: cabal install HDBC-sqlite3 It returned the following error: Resolving dependencies... Configuring HDBC-sqlite3-2.3.1.0... cabal: Missing dependency on a foreign library: * Missing C library: sqlite3

That means you don't have the C library installed, or at least that cabal can't find it. You have to install it otherwise or put it in a directory in your %PATH%. I'm not familiar with Windows, so I can't tell you how to do that. You could search on the haskellwiki, perhaps there are instructions there.

...

I then went to the link you provided: http://hackage.haskell.org/package/HDBC-sqlite3 I extracted the tar file, HDBC-sqlite3-2.3.1.0.tar, and tried to un-tar it but get the following message: "Error reading header after processing 0 entries"

If cabal complains about a missing foreign dependency, trying a manual install won't help, runhaskell ./Setup configure won't look anywhere cabal doesn't.

_______________________________________________ Beginners mailing list Beginners@haskell.org http://www.haskell.org/mailman/listinfo/beginners

-- ===================== Patrick LeBoutillier Rosemère, Québec, Canada