# Activerecord standalone and ODBC

**URL:** <https://www.ruby-forum.com/t/activerecord-standalone-and-odbc/90733>\
**Category:** Rails\
**Created:** [March 31, 2007, 4:37pm UTC](https://www.ruby-forum.com/t/activerecord-standalone-and-odbc/90733 "2007-03-31T16:37:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PaSSS\_lo\_Geyer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/eb9ed0/32.png) [@PaSSS\_lo\_Geyer](https://www.ruby-forum.com/u/PaSSS_lo_Geyer)\
**Post date:** [March 31, 2007, 4:37pm UTC](https://www.ruby-forum.com/t/activerecord-standalone-and-odbc/90733/1 "2007-03-31T16:37:29Z")

</div>

i’m trying to connect to a SQL Server from my ruby script, to fetch  
some data to a new database (using MySQL)

but i get these errors:  
paulo@shuffle:/tmp/sql$ ruby test.rb  
WARNING: no ODBC driver manager found.  
/usr/lib/ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect’: INTERN (0)  
[RubyODBC]Cannot allocate SQLHENV (DBI::DatabaseError)

any ideas?

---

<div class="post-metadata">

**Author:** ![PaSSS\_lo\_Geyer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/eb9ed0/32.png) [@PaSSS\_lo\_Geyer](https://www.ruby-forum.com/u/PaSSS_lo_Geyer)\
**Post date:** [April 1, 2007, 12:13am UTC](https://www.ruby-forum.com/t/activerecord-standalone-and-odbc/90733/2 "2007-04-01T00:13:52Z")

</div>

well, i’ve followed this guide  
[http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux](http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux)

and got something workign, now i have another error message:  
paulo@shuffle:/tmp/sql$ ruby test.rb  
/usr/lib/ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect’: IM003 (0) [iODBC]  
[Driver Manager]Specified driver could not be loaded  
(DBI::DatabaseError)

---

<div class="post-metadata">

**Author:** ![PaSSS\_lo\_Geyer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/eb9ed0/32.png) [@PaSSS\_lo\_Geyer](https://www.ruby-forum.com/u/PaSSS_lo_Geyer)\
**Post date:** [May 16, 2007, 10:50pm UTC](https://www.ruby-forum.com/t/activerecord-standalone-and-odbc/90733/3 "2007-05-16T22:50:31Z")

</div>

I got the same error on my Debian Etch and I fix it installing the  
package ‘libiodbc2’ with apt-get.  
I hope this will be usefull.  
Juan M. Repetti.(ARG)

---

<div class="post-metadata">

**Author:** ![PaSSS\_lo\_Geyer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/eb9ed0/32.png) [@PaSSS\_lo\_Geyer](https://www.ruby-forum.com/u/PaSSS_lo_Geyer)\
**Post date:** [May 17, 2007, 4:32pm UTC](https://www.ruby-forum.com/t/activerecord-standalone-and-odbc/90733/4 "2007-05-17T16:32:47Z")

</div>

thanks Juan M., i’ll try later

On 16 maio, 17:50, Juan M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)