venkata reddy wrote in post #959736:
i tried downloading the sqlite3.exe (not the dll) and placinig that
my system32 folder. But still the same problem persists. I got error
msg like ""The
rocedure entry point sqlite3_backup_finish could not be loacated in
the dynamic link library Sqlite3.dll"
If u dont mind can u tell me from the first step how to install ruby
on rails and how to build a sampla application using ROR pls...
Sorry to hear about your problems - setup is never quite universal, eh?
In my experience, the "sqlite3_backup_finish" error always comes up when
there is a difference between the gem you are using and the current
SQLite3 runtime. Basically you did:
gem install sqlite3-ruby
And it installed the newest version (eg. 1.3.2) and it said something
like "This gem was built with SQLite 3.5.3." - or you built it with a
different SQLite. Then when you do:
It says that it is not the same version (3.5.3 in this case).
You can either:
1) Change the SQLite runtimes to match the gem, or
2) Change the gem to match the runtimes (.exe, .dll, etc.)
For #1, on Windows you change Computer + (rt-click) -> Properties ->
Advanced System Settings -> Environment Variables... -> Edit, and put
the path of the other version of SQLite at the start, eg.
PATH=C:\Tools\Sqlite3_3_5;...(everything already there)". Be certain
you have the .exe and .dll in that directory for it to work.
#2 What works is to tell Rails which version of the gem you want it to
use for that application. Unfortunately there doesn't seem to be a way
to ask the gem what SQLite version it requires after the install, nor a
list of what gem sqlite3-ruby versions deal with which SQLite
versions... For those who installed sqlite3 and had it build the gem -
In environment.rb add a line like this in the lower part (search for
config.gem and you'll see some comment examples - put it there):
config.gem "sqlite3-ruby", :version => '1.2.5'
When you start Rails this time it will spit out tons of
errors/stacktrace and say that sqlite3-ruby isn't installed. But
Rails/gem installed it and your webapp will run now.