# Edge\_rails, sqlserver, and an error!

**URL:** <https://www.ruby-forum.com/t/edge-rails-sqlserver-and-an-error/93296>\
**Category:** Rails\
**Created:** [March 30, 2006, 12:15am UTC](https://www.ruby-forum.com/t/edge-rails-sqlserver-and-an-error/93296 "2006-03-30T00:15:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![adambeazley](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/5f9b8f/32.png) [@adambeazley](https://www.ruby-forum.com/u/adambeazley)\
**Post date:** [March 30, 2006, 12:15am UTC](https://www.ruby-forum.com/t/edge-rails-sqlserver-and-an-error/93296/1 "2006-03-30T00:15:46Z")

</div>

Hello,

Using Edge\_Rails and SQL Server I get an error in my schema.rb file  
after  
issuing “rake migrate”.

## database.yml

development:  
adapter: sqlserver  
database: triage\_development  
username: user  
password: pass  
host: server

## schema.rb

# Could not dump table “categories” because of following

DBI::DatabaseError

# EOF

```
OLE error code:800A0E78 in ADODB.Recordset
  Operation is not allowed when the object is closed.
HRESULT error code:0x80020009
  Exception occurred.

```

Any ideas? If you need more info, I’ll be happy to supply it.  
I probably missed something, but I’m not seeing it.  
Thanks for lending an eye!

---

<div class="post-metadata">

**Author:** ![adambeazley](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/5f9b8f/32.png) [@adambeazley](https://www.ruby-forum.com/u/adambeazley)\
**Post date:** [April 21, 2006, 1:21pm UTC](https://www.ruby-forum.com/t/edge-rails-sqlserver-and-an-error/93296/2 "2006-04-21T13:21:17Z")

</div>

Hi,

I have also met this error on tables without any index (on relation  
tables created by older Rails version). So I have created an unique  
index on its keys and the error disappeared.

Regards,  
Karel

---

<div class="post-metadata">

**Author:** ![adambeazley](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/5f9b8f/32.png) [@adambeazley](https://www.ruby-forum.com/u/adambeazley)\
**Post date:** [May 10, 2006, 2:19am UTC](https://www.ruby-forum.com/t/edge-rails-sqlserver-and-an-error/93296/3 "2006-05-10T02:19:44Z")

</div>

home equity line of credit