# Problem : no such file to load -- sqlite3

**URL:** <https://www.ruby-forum.com/t/problem-no-such-file-to-load-sqlite3/152929>\
**Category:** Rails\
**Created:** [November 10, 2008, 1:43am UTC](https://www.ruby-forum.com/t/problem-no-such-file-to-load-sqlite3/152929 "2008-11-10T01:43:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vlad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/3bc359/32.png) [@vlad](https://www.ruby-forum.com/u/vlad)\
**Post date:** [November 10, 2008, 1:43am UTC](https://www.ruby-forum.com/t/problem-no-such-file-to-load-sqlite3/152929/1 "2008-11-10T01:43:19Z")

</div>

i followed a tutorial/course and it didn’t work so i copied the source  
files from it and it still doesn’t work

> **[jhl.it](http://www.jhl.it/Courses/LUGPC10.html)**
>
> This domain may be for sale!

MissingSourceFile in UsersController#index

no such file to load – sqlite3

RAILS\_ROOT: C:/courses/LUGPC10/WebAlbum  
Application Trace | Framework Trace | Full Trace

C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem_original_require' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require’  
vendor/rails/activesupport/lib/active\_support/dependencies.rb:496:in  
`require' vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in `new\_constants\_in’  
vendor/rails/activesupport/lib/active\_support/dependencies.rb:496:in  
`require' vendor/rails/activesupport/lib/active_support/core_ext/kernel/ requires.rb:7:in `require\_library\_or\_gem’  
vendor/rails/activesupport/lib/active\_support/core\_ext/kernel/  
reporting.rb:11:in `silence_warnings' vendor/rails/activesupport/lib/active_support/core_ext/kernel/ requires.rb:5:in `require\_library\_or\_gem’  
vendor/rails/activerecord/lib/active\_record/connection\_adapters/  
sqlite3\_adapter.rb:10:in `sqlite3_connection' vendor/rails/activerecord/lib/active_record/connection_adapters/ abstract/connection_specification.rb:291:in `send’  
vendor/rails/activerecord/lib/active\_record/connection\_adapters/  
abstract/connection\_specification.rb:291:in `connection=' vendor/rails/activerecord/lib/active_record/connection_adapters/ abstract/connection_specification.rb:259:in `retrieve\_connection’  
vendor/rails/activerecord/lib/active\_record/connection\_adapters/  
abstract/connection\_specification.rb:78:in `connection' vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache’  
vendor/rails/actionpack/lib/action\_controller/caching.rb:677:in  
`perform_action' vendor/rails/actionpack/lib/action_controller/base.rb:524:in `send’  
vendor/rails/actionpack/lib/action\_controller/base.rb:524:in  
`process_without_filters' vendor/rails/actionpack/lib/action_controller/filters.rb:685:in `process\_without\_session\_management\_support’  
vendor/rails/actionpack/lib/action\_controller/session\_management.rb:  
123:in `process' vendor/rails/actionpack/lib/action_controller/base.rb:388:in `process’  
vendor/rails/actionpack/lib/action\_controller/dispatcher.rb:171:in  
`handle_request' vendor/rails/actionpack/lib/action_controller/dispatcher.rb:115:in `dispatch’  
vendor/rails/actionpack/lib/action\_controller/dispatcher.rb:126:in  
`dispatch_cgi' vendor/rails/actionpack/lib/action_controller/dispatcher.rb:9:in `dispatch’  
vendor/rails/railties/lib/webrick\_server.rb:112:in `handle_dispatch' vendor/rails/railties/lib/webrick_server.rb:78:in `service’  
C:/Ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' C:/Ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' C:/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' C:/Ruby/lib/ruby/1.8/webrick/server.rb:95:in `start’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `each' C:/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `start’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:23:in `start' C:/Ruby/lib/ruby/1.8/webrick/server.rb:82:in `start’  
vendor/rails/railties/lib/webrick\_server.rb:62:in `dispatch' vendor/rails/railties/lib/commands/servers/webrick.rb:66 C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem\_original\_require’  
C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`require' vendor/rails/activesupport/lib/active_support/dependencies.rb:496:in `require’  
vendor/rails/activesupport/lib/active\_support/dependencies.rb:342:in  
`new_constants_in' vendor/rails/activesupport/lib/active_support/dependencies.rb:496:in `require’  
vendor/rails/railties/lib/commands/server.rb:39  
C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem_original_require' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require’  
script/server:3

C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem_original_require' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require’  
vendor/rails/activesupport/lib/active\_support/dependencies.rb:496:in  
`require' vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in `new\_constants\_in’  
vendor/rails/activesupport/lib/active\_support/dependencies.rb:496:in  
`require' vendor/rails/activesupport/lib/active_support/core_ext/kernel/ requires.rb:7:in `require\_library\_or\_gem’  
vendor/rails/activesupport/lib/active\_support/core\_ext/kernel/  
reporting.rb:11:in `silence_warnings' vendor/rails/activesupport/lib/active_support/core_ext/kernel/ requires.rb:5:in `require\_library\_or\_gem’  
vendor/rails/activerecord/lib/active\_record/connection\_adapters/  
sqlite3\_adapter.rb:10:in `sqlite3_connection' vendor/rails/activerecord/lib/active_record/connection_adapters/ abstract/connection_specification.rb:291:in `send’  
vendor/rails/activerecord/lib/active\_record/connection\_adapters/  
abstract/connection\_specification.rb:291:in `connection=' vendor/rails/activerecord/lib/active_record/connection_adapters/ abstract/connection_specification.rb:259:in `retrieve\_connection’  
vendor/rails/activerecord/lib/active\_record/connection\_adapters/  
abstract/connection\_specification.rb:78:in `connection' vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache’  
vendor/rails/actionpack/lib/action\_controller/caching.rb:677:in  
`perform_action' vendor/rails/actionpack/lib/action_controller/base.rb:524:in `send’  
vendor/rails/actionpack/lib/action\_controller/base.rb:524:in  
`process_without_filters' vendor/rails/actionpack/lib/action_controller/filters.rb:685:in `process\_without\_session\_management\_support’  
vendor/rails/actionpack/lib/action\_controller/session\_management.rb:  
123:in `process' vendor/rails/actionpack/lib/action_controller/base.rb:388:in `process’  
vendor/rails/actionpack/lib/action\_controller/dispatcher.rb:171:in  
`handle_request' vendor/rails/actionpack/lib/action_controller/dispatcher.rb:115:in `dispatch’  
vendor/rails/actionpack/lib/action\_controller/dispatcher.rb:126:in  
`dispatch_cgi' vendor/rails/actionpack/lib/action_controller/dispatcher.rb:9:in `dispatch’  
vendor/rails/railties/lib/webrick\_server.rb:112:in `handle_dispatch' vendor/rails/railties/lib/webrick_server.rb:78:in `service’  
C:/Ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' C:/Ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' C:/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' C:/Ruby/lib/ruby/1.8/webrick/server.rb:95:in `start’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `each' C:/Ruby/lib/ruby/1.8/webrick/server.rb:92:in `start’  
C:/Ruby/lib/ruby/1.8/webrick/server.rb:23:in `start' C:/Ruby/lib/ruby/1.8/webrick/server.rb:82:in `start’  
vendor/rails/railties/lib/webrick\_server.rb:62:in `dispatch' vendor/rails/railties/lib/commands/servers/webrick.rb:66 C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem\_original\_require’  
C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`require' vendor/rails/activesupport/lib/active_support/dependencies.rb:496:in `require’  
vendor/rails/activesupport/lib/active\_support/dependencies.rb:342:in  
`new_constants_in' vendor/rails/activesupport/lib/active_support/dependencies.rb:496:in `require’  
vendor/rails/railties/lib/commands/server.rb:39  
C:/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem_original_require' C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require’  
script/server:3

This error occurred while loading the following files:  
sqlite3

Request

Parameters:

None

Show session dump

* * *

flash: !map:ActionController::Flash::FlashHash {}

Response

Headers:

{“cookie”=\>[],  
“Cache-Control”=\>“no-cache”}

---

<div class="post-metadata">

**Author:** ![vlad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/3bc359/32.png) [@vlad](https://www.ruby-forum.com/u/vlad)\
**Post date:** [November 11, 2008, 5:55am UTC](https://www.ruby-forum.com/t/problem-no-such-file-to-load-sqlite3/152929/2 "2008-11-11T05:55:15Z")

</div>

Your tutorial is looking to use sqlite3 as the database for it’s  
application - if you check the file config/database.yml you will see  
some words to the effect.

Check this site for details how if you can’t find instructions with  
the tutorial itself.

> **[Setting up SQLite3 for Ruby on Rails Development - Accidental Technologist](https://accidentaltechnologist.com/ruby-on-rails/setting-up-sqlite3-for-ruby-on-rails-development/)**
>
> Tweet UPDATE: Thanks to an astute reader, it seems to have full SQLite3 support on Windows you need to add the SQLite3.dll and the SQLite3.def files also in your path.  I put these in my ruby/bin folder, which is where they will be in the...

Rick