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:in `initialize' 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:in `sqlite 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:in `connection_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:in `retrieve_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:in `migrate' 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:in `execute'

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:in `execute'

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:in `synchronize' 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:in `invoke_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:in `send' 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:in `invoke_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:in `synchronize' 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:in `run' 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:in `run' 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...