Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
ruby odbc
Uwe Kubosch
7/2/2007 2:22:00 PM
Hi all!
I am trying to use ActiveRecord migrations from Linux on an MS SQL
Server database running on windows. I am following the instructions on
http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRa...
I have successfully set up freetds and unixODBC, and I can connect fine
using tsql and isql.
When I try connecting using ruby I get the following:
[root@pippin laptop_scripts]# irb
irb(main):001:0> require 'odbc'
=> true
irb(main):002:0> require 'dbi'
=> true
irb(main):003:0> dbh = DBI.connect('dbi:ODBC:database_name', 'username', 'password')
NoMethodError: undefined method `default_attributes' for #<ODBC::Driver:0xb7f6ade4 @attrs={}, @name=nil>
from /usr/lib/ruby/site_ruby/1.8/dbi.rb:420:in `connect'
from /usr/lib/ruby/site_ruby/1.8/dbi.rb:215:in `connect'
from (irb):3
irb(main):004:0>
Checking the ruby odbc documentation, the default_attributes method is not defined, and the Driver class inherits from Object.
Can anybody help tell me what to do to connect using DBI?
All help is greatly appreciated.
Uwe
2 Answers
Gale Cho
7/4/2007 11:19:00 AM
0
>
http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRa...
>
>
> I have successfully set up freetds and unixODBC, and I can connect fine
> using tsql and isql.
>
Did you install Ruby ODBC and Ruby DBI ODBC driver after testing on tsql
and isql, like the page mentions ?
--
Posted via
http://www.ruby-...
.
Uwe Kubosch
7/4/2007 3:47:00 PM
0
On Wed, 2007-07-04 at 20:18 +0900, Gale CC wrote:
> >
http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRa...
> >
> > I have successfully set up freetds and unixODBC, and I can connect fine
> > using tsql and isql.
> Did you install Ruby ODBC and Ruby DBI ODBC driver after testing on tsql
> and isql, like the page mentions ?
Thank you for answering.
It turns out I had forgotten to add the --with=dbd_odbc option when
running the setup config script during the Ruby DBI installation. When
I added the option, everything worked.
Thanks again for answering.
Uwe
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
ruby odbc
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password