Activerecord standalone and ODBC

Rails
1

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?

2

well, i’ve followed this guide
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)

3

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)

4

thanks Juan M., i’ll try later

On 16 maio, 17:50, Juan M. [email protected]