Hi All, I am having a problem to access multiple databases with mssql I am running Ruby 1.8.4 and Rails 1.1 on Windows 2000 Advanced Server. I am simply trying to integrate the application I wrote before for Oracle to Mssql. The application works perfectly with Oracle with the installed driver OCI8. The app retrives data based on a search criteria from those databases. I followed the directions given at: http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer to connect to the database with mssql Also my .yml file looks like the following: development: adapter: sqlserver database: GME_CCON host: DBI:ADO:Provider=SQLOLEDB;Data Source=satchel;Initial Catalog=GME_CCON;User ID=genesys;Password=**** username: genesys password: **** GME_CONFIG: adapter: sqlserver database: GME_CONFIG host: DBI:ADO:Provider=SQLOLEDB;Data Source=satchel;Initial Catalog=GME_CONFIG;User ID=genesys;Password=**** username: genesys password: **** The GME_CONFIG is the second database that I am trying to connect to. Also, the model for that looks like this: class CfgDn<ActiveRecord::Base set_table_name "cfg_dn" set_primary_key "dbid" has_many :gcdrs, :class_name => "Gcdr", :foreign_key => "dn" has_many :scdrs, :class_name => "Scdr", :foreign_key => "locdn" has_many :evrefs, :class_name => "Evref", :foreign_key => "dn" has_many :arecs, :class_name => "Arec", :foreign_key => "dn" establish_connection :"GME_CONFIG" end Normally, when I do this for multiple oracle databases, it works perfectly. When I try to set it up with Mssql, I am ending up connecting the first database but not the second. The reason that I know I am connecting to the first database is that: from ruby script/console: a=Gcdr.find(:all) returns all the information in that table. And finally the error from rails is: Open OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Can not open database requested in login ''GME_CONFIG". Login Fails. HRESULT error code:0x80020009 Exception Occured I find this error deceptive because the same credentials work with ODBC, and I am able to make sql queries with an external tool (Brio). So, I am not sure what I''m missing here? Does the driver for Mssql support multiple database access like OCI8? Is this Rails specific problem? or Is it the limitations of the driver for Mssql (if there are any)?. Please kindly advise Thank You Deniz Rende -- Posted via http://www.ruby-forum.com/.