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