Sqlite3 rake migrate

Hello,

I installed sqlite3 properly on win xp, everything works fine but when
executing rake migrate I get the following error message:

rake aborted!
could not open database

Can anyone help me out? I’m using sqlite 3.3.7 and sqlite3-ruby 1.1.0.

Cheers,
Jörg
The complete trace:

** Invoke migrate (first_time)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
could not open database
C:/Programme/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0-mswin32/lib/sqlite3/
errors.rb:94:in check' C:/Programme/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0-mswin32/lib/sqlite3/ database.rb:112:ininitialize’
C:/Dokumente und
Einstellungen/J÷rg/radrails/Portfolio/config/…/vendor/rails/ac
tiverecord/lib/active_record/connection_adapters/sqlite_adapter.rb:17:in
new' C:/Dokumente und Einstellungen/J÷rg/radrails/Portfolio/config/../vendor/rails/ac tiverecord/lib/active_record/connection_adapters/sqlite_adapter.rb:17:insqlite
3_connection’
C:/Dokumente und
Einstellungen/J÷rg/radrails/Portfolio/config/…/vendor/rails/ac
tiverecord/lib/active_record/connection_adapters/abstract/connection_specificati
on.rb:252:in send' C:/Dokumente und Einstellungen/J÷rg/radrails/Portfolio/config/../vendor/rails/ac tiverecord/lib/active_record/connection_adapters/abstract/connection_specificati on.rb:252:inconnection_without_query_cache=’
C:/Dokumente und
Einstellungen/J÷rg/radrails/Portfolio/config/…/vendor/rails/ac
tiverecord/lib/active_record/query_cache.rb:54:in connection=' C:/Dokumente und Einstellungen/J÷rg/radrails/Portfolio/config/../vendor/rails/ac tiverecord/lib/active_record/connection_adapters/abstract/connection_specificati on.rb:220:inretrieve_connection’
C:/Dokumente und
Einstellungen/J÷rg/radrails/Portfolio/config/…/vendor/rails/ac
tiverecord/lib/active_record/connection_adapters/abstract/connection_specificati
on.rb:78:in connection' C:/Dokumente und Einstellungen/J÷rg/radrails/Portfolio/config/../vendor/rails/ac tiverecord/lib/active_record/migration.rb:283:inmigrate’
C:/Dokumente und
Einstellungen/J÷rg/radrails/Portfolio/config/…/vendor/rails/ra
ilties/lib/tasks/databases.rake:4
C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in
call' C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:inexecute’

C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in
each' C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:inexecute’

C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:357:in
invoke' C:/Programme/ruby/lib/ruby/1.8/thread.rb:135:insynchronize’
C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in
invoke' C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:364:ininvoke_p
rerequisites’
C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:999:in
each' C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:999:insend’
C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:999:in
each' C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:363:ininvoke_p
rerequisites’
C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:356:in
invoke' C:/Programme/ruby/lib/ruby/1.8/thread.rb:135:insynchronize’
C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in
invoke' C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:inrun’
C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in
each' C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:inrun’
C:/Programme/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/bin/rake:7
C:/Programme/ruby/bin/rake.bat:25:in `load’
C:/Programme/ruby/bin/rake.bat:25

Are you working with an existing database or are you trying to create a
new
one?
If using existing database, check to make sure it’s actually a SQLite3
database and not SQLITE2.

If using new database, check to make sure you have permissions set to
write
to the folder where the database should be.

Never seen this before… I use SQLite constantly.

Make sure sqlite3.exe and sqlite.dll both exist on your path so that
Ruby
can find them.

Had an ‘umlaut’ in my project path, that was the problem…