# Error connecting to Sybase (odd)

**URL:** <https://www.ruby-forum.com/t/error-connecting-to-sybase-odd/174570>\
**Category:** Rails\
**Created:** [August 28, 2009, 9:37pm UTC](https://www.ruby-forum.com/t/error-connecting-to-sybase-odd/174570 "2009-08-28T21:37:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![trevoke](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/ee7513/32.png) [@trevoke](https://www.ruby-forum.com/u/trevoke)\
**Post date:** [August 28, 2009, 9:37pm UTC](https://www.ruby-forum.com/t/error-connecting-to-sybase-odd/174570/1 "2009-08-28T21:37:59Z")

</div>

I have activerecord-sybase-adapter installed – and Sybase itself, so I  
have the drivers.

In irb or in the rails console, this works:

ActiveRecord::Base.establish\_connection(  
:adapter =\> â€œsybaseâ€,  
:database =\> â€œmydbâ€,  
:host =\> â€œmyhostâ€,  
:myport =\> myport,  
:username =\> â€œread\_onlyâ€,  
:password =\> â€œread\_onlyâ€)

In Rails, I have this in my database.yml:  
pacs:  
adapter: sybase  
database: mydb  
username: read\_only  
password: read\_only  
host: myhost  
port: myport

And then I have the following model:  
class PacsPatient \< ActiveRecord::Base

establish\_connection “pacs”  
set\_table\_name “patient”  
set\_primary\_key “pat\_ckey”

end

So, when I go to the console and try to do something like…

> > PacsPatient.find 1

#Class:0x481a610: connect failed  
from c:/ruby/lib/ruby/site\_ruby/1.8/i386-msvcrt/sybct.rb:27:in  
`connect' from c:/ruby/lib/ruby/site_ruby/1.8/i386-msvcrt/sybct.rb:27:in`open’  
from c:/ruby/lib/ruby/site\_ruby/1.8/i386-msvcrt/sybsql.rb:269:in  
`initialize' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sybase-adapter-1.0.0.9250/lib/active_record/connection_adapters/sybase_adapter.rb:46:in`new’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sybase-adapter-1.0.0.9250/lib/active\_record/connection\_adapters/sybase\_adapter.rb:46:in  
`sybase_connection' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in`send’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:223:in  
`new_connection' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in`checkout\_new\_connection’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:188:in  
`checkout' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in`loop’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:184:in  
`checkout' from c:/ruby/lib/ruby/1.8/monitor.rb:242:in`synchronize’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:183:in  
`checkout' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in`connection’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/connection\_adapters/abstract/connection\_pool.rb:326:in  
`retrieve_connection' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in`retrieve\_connection’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:115:in  
`connection' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:3103:in`quoted\_table\_name’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/base.rb:1583:in  
`find_one' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1574:in`find\_from\_ids’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/base.rb:616:in  
`find’  
from (irb):1\>\>

So it seems that I’m doing something wrong… But what?
