I am trying to connect to a remote sql server and I am getting the
connect': Open (DBI::Databa seError) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. HRESULT error code:0x80020009 Exception occurred. from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:5 84:inconnect’
In my code I am creating a connection using the following code:
:adapter => “sqlserver”,
:username => “TestUser”,
:password => “TestUser”,
:host => “machine.domain.com”,
:database => “MY_DB,1150”)
I can connect to the database from my machine using DBVisualizer, using
the same parameters.
What could be the issue here?