# Ruby dbi and sql server 2000

**URL:** <https://www.ruby-forum.com/t/ruby-dbi-and-sql-server-2000/145153>\
**Category:** Ruby\
**Created:** [August 6, 2008, 3:06pm UTC](https://www.ruby-forum.com/t/ruby-dbi-and-sql-server-2000/145153 "2008-08-06T15:06:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aidy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@aidy](https://www.ruby-forum.com/u/aidy)\
**Post date:** [August 6, 2008, 3:06pm UTC](https://www.ruby-forum.com/t/ruby-dbi-and-sql-server-2000/145153/1 "2008-08-06T15:06:03Z")

</div>

I hava a class that connects to SQL Server 2000

class SQLServerConnection  
attr\_reader :row

```
def initialize(server_name, db)
  @db = db
  @dbh=DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

```

Source=#{server\_name};Intitial Catalog=#{@db};Integrated  
Security=SSPI")  
end

```
def execute_sql(sql)
  @dbh.execute("USE #{@db}")
  sth = @dbh.prepare(sql)
  sth.execute
  @row=sth.fetch
end

```

end

sql\_server = SQLServerConnection.new(‘v-w-dcs-test1’,  
‘DcsOrderTracking’)  
sql\_server.execute\_sql(“DELETE FROM [OrderLineStatus]”)

I am receiving this error

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.

But I am not sure why.

Any ideas?

Thanks

Aidy

---

<div class="post-metadata">

**Author:** ![aidy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@aidy](https://www.ruby-forum.com/u/aidy)\
**Post date:** [August 6, 2008, 3:40pm UTC](https://www.ruby-forum.com/t/ruby-dbi-and-sql-server-2000/145153/2 "2008-08-06T15:40:37Z")

</div>

On Aug 6, 3:00 pm, aidy [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> end  
> ‘DcsOrderTracking’)  
> HRESULT error code:0x80020009
> 
> Exception occurred.
> 
> But I am not sure why.
> 
> Any ideas?
> 
> Thanks
> 
> Aidy

Take look at [http://www.kitebird.com/articles/ruby-dbi.html](http://www.kitebird.com/articles/ruby-dbi.html)

---

<div class="post-metadata">

**Author:** ![aidy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/eada6e/32.png) [@aidy](https://www.ruby-forum.com/u/aidy)\
**Post date:** [August 7, 2008, 7:33am UTC](https://www.ruby-forum.com/t/ruby-dbi-and-sql-server-2000/145153/3 "2008-08-07T07:33:40Z")

</div>

aidy wrote:

> I am receiving this error
> 
> 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.

Why not just something like this:  
sql\_server.dbh.do(“DELETE FROM [OrderLineStatus]”)

by  
TheR