[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Accessing SQL Server named instance

greg.kujawa

10/25/2007 12:44:00 AM

I apologize in advance for posting a Rails question in the general
Ruby news group, but here goes. Does anyone know of a way I can
configure my Rails app to access a SQL Server named instance? My
version of Rails is a couple of years old (ActiveRecord v1.10.0 if
that means anything). I am using ADO and when I refer to the SQL
Server named instance as SERVERNAME\INSTANCE the app errors out that
it cannot connect. The app was previously hosted on anothe server that
used the default instance. No problems then. I had googled a posting
on another board where someone had similar issues. But no follow-up as
to if it was fixable.

Anyone know?

1 Answer

Robert Klemme

10/25/2007 12:36:00 PM

0

2007/10/25, gregarican <greg.kujawa@gmail.com>:
> I apologize in advance for posting a Rails question in the general
> Ruby news group, but here goes. Does anyone know of a way I can
> configure my Rails app to access a SQL Server named instance? My
> version of Rails is a couple of years old (ActiveRecord v1.10.0 if
> that means anything). I am using ADO and when I refer to the SQL
> Server named instance as SERVERNAME\INSTANCE the app errors out that
> it cannot connect. The app was previously hosted on anothe server that
> used the default instance. No problems then. I had googled a posting
> on another board where someone had similar issues. But no follow-up as
> to if it was fixable.
>
> Anyone know?

Unfortunately no Rails experience here, but: you did make sure the
port on the DB server is reachable from your Rails machine?

Kind regards

robert