# Beginner help: Problem installing sqlite3 on Windows XP

**URL:** <https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116>\
**Category:** Ruby\
**Created:** [August 28, 2008, 3:18pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116 "2008-08-28T15:18:38Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 3:18pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/1 "2008-08-28T15:18:38Z")

</div>

Hi Everyone,

I am new to Ruby, and i keep getting stuck in the same place getting  
started.

I hope someone is able to help me. I am trying to install sqlite3 and  
have been following several tutorials, and it all looke very simple, but  
i keep running in to this problem.

I have installed ruby and gem.

C:\>ruby -v  
ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32]

C:\>gem --version  
1.2.0

I have placed sqlite3.dll, sqlite3.def, sqlite3.exe in my c:\ruby\bin

I keep getting the following error:

* * *

C:\>gem install sqlite3-ruby  
Building native extensions. This could take a while…  
ERROR: Error installing sqlite3-ruby:  
ERROR: Failed to build gem native extension.

c:/ruby/bin/ruby.exe extconf.rb install sqlite3-ruby  
checking for fdatasync() in rt.lib… no  
checking for sqlite3.h… no

nmake  
‘nmake’ is not recognized as an internal or external command,  
operable program or batch file.

Gem files will remain installed in  
c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1  
.2.4 for inspection.  
Results logged to  
c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3\_  
api/gem\_make.out

* * *

Does anyone have an idea what is wrong?

Thanks for your help in advance.

Kind regards,

Kasper

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 3:24pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/2 "2008-08-28T15:24:40Z")

</div>

You could try installing nmake , and run it again . You can find nmake  
here :

> **[Microsoft Support](https://support.microsoft.com/en-US)**
>
> Microsoft support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft 365, Windows, Surface, and more.

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 3:40pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/3 "2008-08-28T15:40:46Z")

</div>

On Thu, Aug 28, 2008 at 7:13 AM, Kasper Frederiksen  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)wrote:

> nmake
> 
> –  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).

try the sqlite3-ruby gem

–  
“Hey brother Christian with your high and mighty errand, Your actions  
speak  
so loud, I can’t hear a word you’re saying.”

-Greg Graffin (Bad Religion)

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 3:57pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/4 "2008-08-28T15:57:30Z")

</div>

Lex W. wrote:

> You could try installing nmake , and run it again . You can find nmake  
> here :  
> [http://support.microsoft.com/default.aspx?scid=kb;en-us;Q132084](http://support.microsoft.com/default.aspx?scid=kb;en-us;Q132084)

I tried to download nmake and placed NMAKE.EXE & NMAKE.ERR in the  
c:\ruby\bin directory.

This is the result:

C:\>gem install sqlite3-ruby  
Building native extensions. This could take a while…  
ERROR: Error installing sqlite3-ruby:  
ERROR: Failed to build gem native extension.

c:/ruby/bin/ruby.exe extconf.rb install sqlite3-ruby  
checking for fdatasync() in rt.lib… no  
checking for sqlite3.h… no

nmake

Microsoft (R) Program Maintenance Utility Version 1.50  
Copyright (c) Microsoft Corp 1988-94. All rights reserved.

NMAKE : fatal error U1073: don’t know how to make ‘ruby.h’  
Stop.

Gem files will remain installed in  
c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1  
.2.4 for inspection.  
Results logged to  
c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3\_  
api/gem\_make.out

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 3:59pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/5 "2008-08-28T15:59:07Z")

</div>

> try the sqlite3-ruby gem
> 
> –

Sorry i am new to this. What do you mean by this? thanks for your help

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 4:05pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/6 "2008-08-28T16:05:26Z")

</div>

On Thu, Aug 28, 2008 at 7:54 AM, Kasper Frederiksen  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)wrote:

> > try the sqlite3-ruby gem
> > 
> > –
> 
> ## Sorry i am new to this. What do you mean by this? thanks for your help
> 
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).

gem install sqlite3-ruby rather than sqlite. sqlite3-ruby works great  
for  
me in Windows XP.

–  
“Hey brother Christian with your high and mighty errand, Your actions  
speak  
so loud, I can’t hear a word you’re saying.”

-Greg Graffin (Bad Religion)

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 11:28pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/7 "2008-08-28T23:28:49Z")

</div>

From what I can tell sqlite3-ruby VERSION 1.2.4 does not have an mswin32  
gem. To get this to install (with out a lot of C comp) I did this  
gem install --version 1.2.3 sqlite3-ruby

version 1.2.3 has a mswin32 gem and installed the correct mswin32  
version.

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 7:34pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/8 "2008-08-28T19:34:44Z")

</div>

This thread explains what is going on for you. I use the mswin32  
version and have no problems on XP. Sound like you went with the ruby  
version and it borked on the compilation step because of missing  
tools.

[http://groups.google.com/group/comp.lang.ruby/browse\_thread/thread/9d5c9ee6167dace4](http://groups.google.com/group/comp.lang.ruby/browse_thread/thread/9d5c9ee6167dace4)

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 28, 2008, 11:42pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/9 "2008-08-28T23:42:47Z")

</div>

On Thu, Aug 28, 2008 at 3:24 PM, Jim C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> From what I can tell sqlite3-ruby VERSION 1.2.4 does not have an mswin32  
> gem. To get this to install (with out a lot of C comp) I did this  
> gem install --version 1.2.3 sqlite3-ruby
> 
> ## version 1.2.3 has a mswin32 gem and installed the correct mswin32 version.
> 
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).

Good to know, I guess I haven’t installed it in a while.

–  
“Hey brother Christian with your high and mighty errand, Your actions  
speak  
so loud, I can’t hear a word you’re saying.”

-Greg Graffin (Bad Religion)

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [September 3, 2008, 3:49pm UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/10 "2008-09-03T15:49:05Z")

</div>

Jim C. wrote:

> From what I can tell sqlite3-ruby VERSION 1.2.4 does not have an mswin32  
> gem. To get this to install (with out a lot of C comp) I did this  
> gem install --version 1.2.3 sqlite3-ruby
> 
> version 1.2.3 has a mswin32 gem and installed the correct mswin32  
> version.

Anyone know when and/or if 1.2.4 will have a mswin32 gem built? Not  
having the current version causes a ‘gem update’ command to fail when it  
gets to trying to update sqlite3-ruby. Is there a way to have gem update  
skip a gem, or continue to the next one if needed, instead of failing  
completely?

Thanks.

---

<div class="post-metadata">

**Author:** ![champ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@champ](https://www.ruby-forum.com/u/champ)\
**Post date:** [August 29, 2008, 10:29am UTC](https://www.ruby-forum.com/t/beginner-help-problem-installing-sqlite3-on-windows-xp/147116/11 "2008-08-29T10:29:39Z")

</div>

Jim C. wrote:

> From what I can tell sqlite3-ruby VERSION 1.2.4 does not have an mswin32  
> gem. To get this to install (with out a lot of C comp) I did this  
> gem install --version 1.2.3 sqlite3-ruby

Using version 1.2.3 fixed the problem. Thanks to all of your for trying  
to help.
