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?
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)
thanks Juan Matias, i'll try later