# ODBC Error

**URL:** <https://www.ruby-forum.com/t/odbc-error/75030>\
**Category:** Ruby\
**Created:** [November 7, 2006, 11:06am UTC](https://www.ruby-forum.com/t/odbc-error/75030 "2006-11-07T11:06:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [November 7, 2006, 11:06am UTC](https://www.ruby-forum.com/t/odbc-error/75030/1 "2006-11-07T11:06:55Z")

</div>

I am running a ruby script to import some data into an MS SQL Server  
Express database. The script works but I am getting errors. The error  
message looks like this  
“WARNING: STMT 0xXXXXXX was not dropped before garbage collection.”

BTW, I am running Ruby 1.8.5 and Windows XP

Any ideas on how to fix this?

thanks,

Luis

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [November 7, 2006, 11:10pm UTC](https://www.ruby-forum.com/t/odbc-error/75030/2 "2006-11-07T23:10:38Z")

</div>

Hi Irlebron

There’s a very handy ODBC reference on  
[Ruby ODBC Reference](http://www.ch-werner.de/rubyodbc/odbc.html).  
stmt.drop() or stmt.close() should do the trick

regards  
Scratchy