venkata reddy wrote in post #959736:
> Dear sir,
>
> i tried downloading the sqlite3.exe (not the dll) and placinig that
> in
> 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?
PROBLEM
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:
> sqlite3
It says that it is not the same version (3.5.3 in this case).
SOLUTION
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 -
good luck!
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.
Cheers,
-Chris
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
