Hi, I'm running an app in a FedoraC6, Apache (using fcgi) and a local MySql primary database, also a secondary SqlServer database at other box
I've followed this tutorial step by step and now the connection to sqlServer its working through command line tsql and performing well, also working through ruby but not so well.
1. If I ask the database for a big amount of data I'm getting an Application error Rails application failed to start properly message
2. If ask for just a couple of rows it do the job and retrieve the data
I use unix “top” command to see how proccesses consume resources CPU & MEM and for case (1) I can see up to three or four dispatch.fcgi proccess “eating” a lot of resources
Does somebody know if this is this normal? what can be happening?, how to solve?
thanks in advance
George Roman, 2009/09/15 17:16
I just finished wrestling with the following problem and thought I could help others avoid it as well.
If you get this error running isql:
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
make sure the properties in all three conf files do not have any indentation. The examples above were indented and it took me a while to figure out why things weren't working.
Ken Collins, 2009/10/27 15:35
I would defer to the adapter's wiki page for upto date info. For instance, if you just install the latest DBI/DBD-ODBC, things are not going to work. There are specific blessed versions and the README and wiki for the adapter project stay current. http://wiki.github.com/rails-sqlserver/2000-2005-adapter/platform-installation
thiago neves, 2010/07/01 19:19
How can i call sql server procedure within an application ruby on rails?
The connection with the sql server works great.
database-support/ms-sql.txt · Last modified: 2009/07/14 00:58 by rps
Discussion
Here are some additional notes on getting MS SQL connections (via FreeTDS) with DSN-less OSBC connections:
http://lists.ibiblio.org/pipermail/freetds/2009q1/024482.html
I did not find activerecord-sqlserver-adapter. Instead I installed akitaonrails-activerecord-sqlserver-adapter-1.1.1.
Robert, run this command first :
That should solve your problem.
I'm located behind a firewall with no way out. Where can I download the official file ?
…
Found a host with direct HTTP connection to the internet so I just ran the following and copied the file to the other server:
sudo gem sources -a http://gems.rubyonrails.org
sudo gem fetch activerecord-sqlserver-adapter
Hi, I'm running an app in a FedoraC6, Apache (using fcgi) and a local MySql primary database, also a secondary SqlServer database at other box
I've followed this tutorial step by step and now the connection to sqlServer its working through command line tsql and performing well, also working through ruby but not so well.
1. If I ask the database for a big amount of data I'm getting an Application error Rails application failed to start properly message
2. If ask for just a couple of rows it do the job and retrieve the data
I use unix “top” command to see how proccesses consume resources CPU & MEM and for case (1) I can see up to three or four dispatch.fcgi proccess “eating” a lot of resources
Does somebody know if this is this normal? what can be happening?, how to solve?
thanks in advance
I just finished wrestling with the following problem and thought I could help others avoid it as well.
If you get this error running isql:
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
make sure the properties in all three conf files do not have any indentation. The examples above were indented and it took me a while to figure out why things weren't working.
I would defer to the adapter's wiki page for upto date info. For instance, if you just install the latest DBI/DBD-ODBC, things are not going to work. There are specific blessed versions and the README and wiki for the adapter project stay current. http://wiki.github.com/rails-sqlserver/2000-2005-adapter/platform-installation
How can i call sql server procedure within an application ruby on rails?
The connection with the sql server works great.