I am trying to connect to a remote sql server and I am getting the
following error:
c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `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:in `connect''
In my code I am creating a connection using the following code:
ActiveRecord::Base.establish_connection(
: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?
--Navjeet
--
Posted via http://www.ruby-forum.com/.
BTW, I was able to connect to the SQL Server by switching mode to ODBC
and creating a DSN on my machine and specifying it in when creating a
connection as below:
ActiveRecord::Base.establish_connection(
:adapter => "sqlserver",
:mode => "ODBC",
:dsn => "my_dsn",
:username => "TestUser",
:password => "TestUser",
:host => "machine.domain.com",
:database => "MY_DB,1150")
Not knowing SQL Server too well, it may not supporting ADO access, not
sure.
--Navjeet
Navjeet wrote:> I am trying to connect to a remote sql server and I am getting the
> following error:
>
> c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `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:in `connect''
>
>
> In my code I am creating a connection using the following code:
>
> ActiveRecord::Base.establish_connection(
> :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?
>
> --Navjeet
--
Posted via http://www.ruby-forum.com/.
Gday,> Navjeet wrote: > > I am trying to connect to a remote sql server and I am getting the > > following error: > > > > c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `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:in `connect''Could it be that the remote SQL server currently only uses domain authentication, explaining why your machine can connect, but won''t accept password-only authentication? I believe this is the default behaviour. I had a similar issue with a PHP app. - Andrew
HI Navjeet, Your first post appears to be using ADO Ok... you installed the ADO.rb from DBI right ? First, try using :host => "(local)" Second, try using :host => "machine" instead of machine.domain.com Third, use SQL Query Analyzer or your other favorite SQL maintenance app to test your userid/pw. The userid/pw is the one that burns me most often, especially if you have newly created or restored your db. Any of those ideas work? -- ------------------------------ Joyeux No?l ------------------------------ Peter Fitzgibbons On 1/5/06, Navjeet Chabbewal <navjeetc@gmail.com> wrote:> > BTW, I was able to connect to the SQL Server by switching mode to ODBC > and creating a DSN on my machine and specifying it in when creating a > connection as below: > > ActiveRecord::Base.establish_connection( > :adapter => "sqlserver", > :mode => "ODBC", > :dsn => "my_dsn", > :username => "TestUser", > :password => "TestUser", > :host => "machine.domain.com", > :database => "MY_DB,1150") > > Not knowing SQL Server too well, it may not supporting ADO access, not > sure. > > --Navjeet > > Navjeet wrote: > > I am trying to connect to a remote sql server and I am getting the > > following error: > > > > c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `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:in `connect'' > > > > > > In my code I am creating a connection using the following code: > > > > ActiveRecord::Base.establish_connection( > > :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? > > > > --Navjeet > > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060106/c9c25718/attachment.html