A little bit of trouble when installing sqlite3-ruby on Windows. I get this error message:
C:\ruby\bin>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
Here are the steps I followed to install it:
1. Download sqlite-3 and sqlitedll-3 from sqlite download.
2. Unzip the files to c:\ruby\bin. Total of 3 files, sqlite3.exe, sqlite3.dll, sqlite3.def.
3. In command line: gem install --version 1.2.3 sqlite3-ruby
C:\ruby\bin>gem install --version 1.2.3 sqlite3-ruby Successfully installed sqlite3-ruby-1.2.3-x86-mswin32 1 gem installed Installing ri documentation for sqlite3-ruby-1.2.3-x86-mswin32... Installing RDoc documentation for sqlite3-ruby-1.2.3-x86-mswin32...Enjoy...
18 comments:
The important point here is to use version 1.2.3.
Should you choose to build 1.2.4 yourself, in case you need some new features, remember that everything in the One-Click-Installer was built with MSVC60. If you build with MSVC8, errors in memory management will sneak up on you.
Sean, that's correct. This guide is a quick fix on making sqlite3 work. Thanks for the reminder.
Thank you very much for posting this reminder - it's kept me from tearing my hair all out! :)
Of all the posts I read on this topic this was by far the best solution out there. Thank you for taking the time to be helpful...Awesome!
Hi, I tried some solutions but nothing works. I've always the same : no such file to load.
I manage to install the rubygem sqlite3-ruby...
This didn't work for me at first.
Then, I did:
> gem uninstall sqlite3-ruby
Then, I took my command line to the directory where I unziped the sqlite files
> cd c:/ruby/bin
Then, I followed the instructions again:
> gem install sqlite3-ruby
and it worked - thanks!
THIS WORKS!! Thanks so much!!!!
Thanks a lot.
Thanks so much. Lifesaver.
thanks man, i was bothering with this for 2 befor i found your solution
Thanks m8 simple & clear solution.
This worked for me on a WinXP
;)
This just sorted by sqlite prodlem on windows vista. Thanks a lot!
Thank you, a lot. This worked when no other instructions did.
thanks for the post. Solved my issue
I have tried everything shown to install sqlite3 but it simply doesn't not work as I always get the following message "no definition for _wrap...". Can anybody help me please? Many thanks in advance
Successfully installed sqlite3-ruby-1.2.5-x86-mswin32
1 gem installed
Installing ri documentation for sqlite3-ruby-1.2.5-x86-mswin32...
Installing RDoc documentation for sqlite3-ruby-1.2.5-x86-mswin32...
No definition for _wrap_new_CallbackData
No definition for _wrap_CallbackData_proc_set
No definition for _wrap_CallbackData_proc_get
No definition for _wrap_CallbackData_proc2_set
No definition for _wrap_CallbackData_proc2_get
No definition for _wrap_CallbackData_data_set
No definition for _wrap_CallbackData_data_get
No definition for _wrap_sqlite3_libversion
No definition for _wrap_sqlite3_close
No definition for _wrap_sqlite3_last_insert_rowi
.......
.......
.......
.......
.......
.......
After struggling for quite some time, this was just the solve I needed.
Results are:
Ruby version -1.8.6 (i386-mswin32)
RubyGems version - 1.3.5
Rack version 1.0
Rails version 2.3.5
Active Record version 2.3.5
Active Resource version 2.3.5
Action Mailer version 2.3.5
Active Support version 2.3.5
Database adapter sqlite3
Database schema version 0
Many thanks - worked on Vista.
i got the exe,dll and def files and put them in ruby\bin folder. Since i dont have internet on the box i am trying to install this in, i manually got the sqlite3-ruby gem (from gemcutter) and tried installing it. It didnt work so i got the sqlite3-ruby-1.2.3-x86-mswin32 gem file but it still gives me the same error, failed to build native extension.
C:\>gem install sqlite3-ruby-1.2.3-x86-mingw32.gem
Building native extensions. This could take a while...
ERROR: Error installing sqlite3-ruby-1.2.3-x86-mingw32.gem:
ERROR: Failed to build gem native extension.
C:/Ruby/bin/ruby.exe extconf.rb
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.3-x86-mingw32 for inspection.
Results logged to C:/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.3-x86-mingw32/
ext/sqlite3_api/gem_make.out
Please help.... m a total noob at this :(
Post a Comment