Could not find activerecord-sqlserver-adapter locally or in a repository

casper_the_ghost · December 10, 2007, 3:58pm

I’m trying to connect to a SQL Server db. I thought I installed the
DBI component per the instructions, but its not working.

When trying to start the ruby server, I get the message:

Please install the sqlserver adapter: gem install activerecord- sqlserver-adapter

But when I try to install the repository, I get this error message:

could not find activerecord-sqlserver-adapter locally or in a
repository

Anyone?

casper_the_ghost · December 13, 2007, 6:39pm

Hey,

I just ran into the exact same problem yesterday. I have been playing
with RoR 1.x with a local version of MSSQL Server 2005 for a few
months now but after I upgraded to RoR 2.0 this week, I received the
same error message you did. This worked fine for me today. There have
been a few other issues I’ve been getting but at least this ones done.

navigate to
http://svn.rubyonrails.org/rails/adapters/sqlserver/lib/active_record/connection_adapters/

and save save sqlserver_adapter.rb to

<rails_app_home>\lib\ruby\gems\1.8\gems\activerecord-2.0.1\lib
\active_record
\connection_adapters

as long as you have the ado.rb from ruby-dbi in your <rails_app_home>
\lib\ ruby\site_ruby\1.8\DBD\ADO folder, you should be good to go.

On Dec 10, 6:57 am, “[email protected]” [email protected]

casper_the_ghost · December 26, 2007, 3:48pm

Use

gem install activerecord-sqlserver-adapter --source=http://
gems.rubyonrails.org

casper_the_ghost · March 31, 2008, 9:58am

Dejan D. wrote:

Use

gem install activerecord-sqlserver-adapter --source=http://
gems.rubyonrails.org

http://gems.rubyonrails.org

Forbidden

any sugestions?

casper_the_ghost · November 9, 2010, 11:55pm

Stephen A. wrote in post #819208:

Milan Jaric wrote:

Dejan D. wrote:

Use

gem install activerecord-sqlserver-adapter --source=http://
gems.rubyonrails.org

http://gems.rubyonrails.org

Forbidden

any sugestions?

It appears that browser connections are forbidden. The gem install
command works fine.

It didn’t work for me:
C:\Ruby187>gem install activerecord-sqlserver-adapter
–source=http://gems.rubyonrails.org
ERROR: Could not find a valid gem ‘activerecord-sqlserver-adapter’ (>=
0) in any repository

Not that I’m a MS fan or anything but I’m new to Ruby and I would think
that finding an MS adapter should be relativity easy. Any help would be
greatly appreciated.

casper_the_ghost · November 10, 2010, 2:56pm

It didn’t work for me:
C:\Ruby187>gem install activerecord-sqlserver-adapter
–source=http://gems.rubyonrails.org
ERROR: Could not find a valid gem ‘activerecord-sqlserver-adapter’ (>=
0) in any repository

Have you tried simply:
gem install activerecord-sqlserver-adapter

I am using MSSQL all the time and that is working for me.

casper_the_ghost · May 23, 2009, 11:03pm

Milan Jaric wrote:

Dejan D. wrote:

Use

gem install activerecord-sqlserver-adapter --source=http://
gems.rubyonrails.org

http://gems.rubyonrails.org

Forbidden

any sugestions?

It appears that browser connections are forbidden. The gem install
command works fine.

casper_the_ghost · November 10, 2010, 3:08pm

pepe wrote in post #960517:

It didn’t work for me:
C:\Ruby187>gem install activerecord-sqlserver-adapter
–source=http://gems.rubyonrails.org
ERROR: Could not find a valid gem ‘activerecord-sqlserver-adapter’ (>=
0) in any repository

Have you tried simply:
gem install activerecord-sqlserver-adapter

I am using MSSQL all the time and that is working for me.

Thanks pepe. I had gone to RubyGems.org and it instructed me to do the
same thing you advised and it works!

Since you use MSSQL all the time perhaps you could answer my next
hurdle. How do I convert my connection into a dsn? My connection
string is:
jdbc:jtds:sqlserver://rogue:1433/AALite;

My ruby client is on windows so I think I need a dsn. Each time I try
to set up a dsn I get the error: SQLState 42000 SQL Server Error: 4064

Any idea what I’m doing wrong?

Thanks again for the help.

casper_the_ghost · November 10, 2010, 3:23pm

Since you use MSSQL all the time perhaps you could answer my next
hurdle. How do I convert my connection into a dsn? My connection
string is:
jdbc:jtds:sqlserver://rogue:1433/AALite;

Hi there,

This is a list I use when setting up a new MSSQL based application.
You might need to skip/change some of the steps. I hope it helps:

Install Ruby (1.8.6): Download Ruby
Install rubygems:
a. Download RubyGems | RubyGems.org | your community gem host (zip version)
b. Unpack to a directory and cd there
c. ruby setup.rb
Install rails: gem install rails v=2.3.5
Install mongrel: gem install mongrel
Install mongrel service: gem install mongrel_service
Install SQL Server adapter: gem install activerecord-sqlserver-
adapter
Install ODBC gem: gem install odbc-rails
Install SQL Server Management utility (from Microsoft)
Create SQL Server DB (name <your_name_here>)
Create login in SQL Server (<your_name_here> For simplicity I use
the same name as DB)
Create DB user (<your_name_here>)
Create DSN in Windows:
a. Control Panel → Adminstrative Tasks → Data Sources (ODBC)
b. Click on System DSN → Add
c. Select type SQL Server
i. Name: <your_name_here> For simplicity I use the same name as
the DB
ii. Description: <your_description_here>
iii. Server: Server name (<value_from_SQL_Server_Management>
Something like XXXXXXXXXX\SQLEXPRESS)
iv. Use SQL Authentication

Then in your database.yml something like this:
development:
adapter: sqlserver
mode: odbc
dsn: <your_dsn_name_here>
username: <your_db_user_here>
password: <your_db_password_here>

host: not required when DSN is used

I read in a post a few days ago that if you use DSN you don’t even
need username and password. I have not tried that so I can’t say for
sure.

Good luck.