Hello !
I’m trying to create a rails project from scratch using migrations on
SQL Server 2005.
Its failing saying :
DBI::DatabaseError: Execute
OLE error code:80040E37 in Microsoft OLE DB Provider for SQL Server
Invalid object name ‘schema_info’.
HRESULT error code:0x80020009
Exception occurred.: SELECT TOP 1 version FROM schema_info
My very uneducated guess is that ActiveRecord is trying to access the
schema
when it hasn’t created it yet. This :
http://wiki.rubyonrails.org/rails/pages/UnderstandingMigrations
says a schema will be created if it doesn’t exist.
Any assistance would be much appreciated.
magpie
I have a batch file like this :
set RAILS_ENV=development
rmdir /S /Q adtcentral
call rails adtcentral
copy /Y build\database.yml adtcentral\config
osql -E -S localhost\SQLEXPRESS -i build\create.sql -n -e
ruby adtcentral\script\generate migration CreateNew
ruby utilities.rb GenFirstMig --database=ADTServer
–destpath=“adtcentral\db\migrate\”
cd adtcentral
rake migrate --trace
which creates a migrations file like this :
class CreateNew < ActiveRecord::Migration
def self.up
create_table :camera_types, :force => true do |tbl|
tbl.column :id, :string
tbl.column :make, :string
tbl.column :model, :string
tbl.column :tv_lines, :string
tbl.column :pixels_x, :string
tbl.column :pixels_y, :string
tbl.column :ccd_size_mm, :string
tbl.column :lens_size_mm, :string
tbl.column :colour_type, :string
tbl.column :iris_type, :string
tbl.column :ir_illumination, :string
tbl.column :lux_minimum, :string
end
end
def self.down
drop_table :camera_types
end
end
database.yml :
development:
adapter: sqlserver
database: adtcentral_dev
username: devuser
password: devuser34
host: .\SQLEXPRESS
mode: DBI:ADO
provider: SQLNCLI
Here goes :
R:\projects\ADT\ADTCentral>actions /build
create
create app/controllers
create app/helpers
create app/models
create app/views/layouts
create config/environments
create components
create db
create doc
create lib
create lib/tasks
create log
create public/images
create public/javascripts
create public/stylesheets
create script/performance
create script/process
create test/fixtures
create test/functional
create test/integration
create test/mocks/development
create test/mocks/test
create test/unit
create vendor
create vendor/plugins
create tmp/sessions
create tmp/sockets
create tmp/cache
create Rakefile
create README
create app/controllers/application.rb
create app/helpers/application_helper.rb
create test/test_helper.rb
create config/database.yml
create config/routes.rb
create public/.htaccess
create config/boot.rb
create config/environment.rb
create config/environments/production.rb
create config/environments/development.rb
create config/environments/test.rb
create script/about
create script/breakpointer
create script/console
create script/destroy
create script/generate
create script/performance/benchmarker
create script/performance/profiler
create script/process/reaper
create script/process/spawner
create script/runner
create script/server
create script/plugin
create public/dispatch.rb
create public/dispatch.cgi
create public/dispatch.fcgi
create public/404.html
create public/500.html
create public/index.html
create public/favicon.ico
create public/robots.txt
create public/images/rails.png
create public/javascripts/prototype.js
create public/javascripts/effects.js
create public/javascripts/dragdrop.js
create public/javascripts/controls.js
create public/javascripts/application.js
create doc/README_FOR_APP
create log/server.log
create log/production.log
create log/development.log
create log/test.log
1 file(s) copied.
use master
exec sp_password @old = null, @new = ‘adt’, @loginame = ‘sa’
IF EXISTS(SELECT * FROM sysdatabases WHERE name=‘adtcentral_dev’)
DROP DATABASE adtcentral_dev;
IF EXISTS(SELECT * FROM syslogins WHERE name=‘devuser’)
EXEC sp_droplogin ‘devuser’
CREATE LOGIN devuser WITH PASSWORD = ‘devuser34’;
CREATE DATABASE adtcentral_dev
use adtcentral_dev
CREATE USER devuser FOR LOGIN devuser;
create db/migrate
create db/migrate/001_create_new.rb
DBI:ODBC:ADTServer
(in R:/projects/ADT/ADTCentral/adtcentral)
** Invoke migrate (first_time)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
DBI::DatabaseError: Execute
OLE error code:80040E37 in Microsoft OLE DB Provider for SQL Server
Invalid object name ‘schema_info’.
HRESULT error code:0x80020009
Exception occurred.: SELECT TOP 1 version FROM schema_info
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
log' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/sqlserver_adapter.rb:485:in select’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/sqlserver_adapter.rb:238:in
select_one' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:307:in current_version’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:324:in
current_version' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:388:in irrelevant_migration?’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:330:in
migrate' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:328:in each’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:328:in
migrate' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:295:in up’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:286:in
migrate' c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/tasks/databases.rake:4 c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/tasks/databases.rake:3:in call’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in each’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:357:in invoke’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in
synchronize' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in invoke’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:364:in
invoke_prerequisites' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:363:in each’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:999:in send' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:999:in each’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:363:in
invoke_prerequisites' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:356:in invoke’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in
synchronize' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in invoke’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in each’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.1/bin/rake:7 c:/ruby/bin/rake:18:in load’
c:/ruby/bin/rake:18
R:\projects\ADT\ADTCentral>