similar to: MS SQL server connection problems

I just started investigating Ruby on Rails and am trying the tutorial. I need to connect to a SQL Server 2000 database for testing purposes. I followed the instructions in the How-To on the wiki for SQL Server. The problem is that when attempting to connect to the database I receive the following errors: DBI::DatabaseError in RecipeController#new Open OLE error code:80004005 in

Hello, I have rails using a MSSQL db. The set up works fine with low volume, but with 2+ requests/second I keep on getting the following error: DBI::DatabaseError: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 Exception occurred.: SELECT

Corect me if this is not the right place to post this. I have a mdbdriver.jar (to access an MSAccess file) under Linux. I bought the license from http://www.csv-jdbc.com/ guys. The driver work fine when tested with DBVisualizer or another JDBC thing. The problem is that driver needs 3 other more jar files to work. Under R I have tried this and does not work: > library(RJDBC) Loading required

I have installed the CVS Head as of 12/12/04, as well as the asterisk-addons to ensure that /usr/lib/asterisk/modules/res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass =

Given a directory tree like ... /foo | +-- A | +-- B | +-- C ... what is the best way to index A and C into a single Xapian database? AFAIK the alternatives are: omindex --db /my_db --no-delete /foo /foo/A omindex --db /my_db --no-delete /foo /foo/B or omindex --db /my_A_db /foo /foo/A omindex --db /my_B_db /foo /foo/B xapian-compact /my_A_db /my_B_db /my_db The first alternative does not

Hi, I?m working on a rails application that uses data from an existing ms sqlserver 2000 database. Unfortunately I can?t get the connection to work properly. I used http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer to make the connection. - Inserted the ado.rb - Changed my database.yml to development: adapter: sqlserver database: database_name host:

I have a search page with a text_field as below <%= text_field ''program'', ''program_name'' %> After I perform the search in my controller I go to a search results view which shows search results and uses Rails pagination. Now how to pass the search paramters (i.e. params[:program][:program_name] in my controller) to the pagination links (next and

Hello, I have write a schema.rb database such as this: ActiveRecord::Schema.define do create_table :arts do |t| t.string :name, :null => false, :limit => 45 end end This file is saved into test/db/schema.rb, and test/config/database.yml is correctly configured with "test_development" database created in a MySQL server. Could you help me to install the content of

Hello all, I''ve spent a while looking for a sniff of this on the wiki or google at large.. Does migrations work for SQL Server on 1.0 ? -- ------------------------------ Joyeux Noël ------------------------------ Peter Fitzgibbons _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

Hi -- I''ve been having problems connecting to a SQL Server database that I thought might be related to the fact I was upgrading Rails to 2.0. However, I also was moving the project to my shiny new macbook. Anyway, after jumping through a few hoops (instaling DBI, etc.), I finally get to my latest error message: <error> DBI::InterfaceError: Could not load driver (no such file to

I am looking for a good CMS based on Rails that has at least these attributes: 1. Ease of use ( as it will be used by people who are not html literate) 2. Very easy/flexible to change layout. So far I have looked at http://rcms.oopen.de/Home/ (have not installed it yet) http://adminpages.flowdev.de http://demo.radiantcms.org/admin/pages http://www.eribium.org/eribium/ MuraveyWeb does not seem

I am having this problem with pagination query in my controller class. I am using SQL server and following code to create pagination fails, complains about column name ''program_name'' (which is valid column/attribute of program) The error message is: DBI::DatabaseError: S0022 (207) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name

Is it possible to change error messages for Validation helpers? I am writing an app against a existing database (so no control over column names), but when there is validation error (e.g. with validate_presence_of) I would like to customize the field name. For example for telephone whose field name is PhoneNumber I would like to chnage it to "Telephone Number cannot be empty" rather

hello, I try to use samba as PDC on NetBSD, but I 've had problem with that combination.. samba work perfectly..but if someone want to write into homedir, they couldn't, and w2k workstation appear message , that disk is full.. disk isn't full, and permission are set correct I don't know, where should be a mistake, I check configuration problably 100x, but I haven't found any

Hi, I''m getting some trouble in connecting to a sql server 2000 database with ActiveRecord-2.0.1 and ruby 186-26, from win XP. Using the next conenction config: ActiveRecord::Base.establish_connection( :adapter => "sqlserver", :database => "nombre_bd", :username => "usu", :password => "contra" ) I have the next error:

Hi, i?m trying to access a MSSQL server (in a windows machine in the network) from a Visual Basic Application running under wine, using an ODBC driver. Since there aren?t any MSSQL drivers for linux i decided to use de native ones, so i installed mdac_typ.exe . Then i configured the DSN using odbcad32.exe but when i tested the connection (configured using tcp/ip) an error message appeared

Dear Master I am new comer in this mailing list. Can you tell me how to connect BDE and ODBC for MSSQL connection using wine. I have already install BDE from Delphi 5 and DBCrab from Winetools. ODBC is OK to connect MS SQL database. But when I joint with BDE using ODBC to connect database there is some error like : [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or

Hello. I reeeeally want to get Instiki running at my day job, but they are Microsoft-heads. While I can probably sell them on trying Rails, they are definitely going to want the database to sit in our SQL Server instance with our other databases. I can''t get instiki to create the tables in sql server though (I''ve added ADO.rb, and gotten a connection). When I run the

G'day If I have VFP9 working, a Mysql DSN which I can contact via isql and using unixODBC for this. Do I need to do anything else to wine ie; install MySQL drivers (Windows version) to get connectivity? I just finished checking out Paul McNett's pages, however the MYSQL drivers he used for VFP8 are "no longer supported" when I do "wine setup.exe". I have a saved

The SQL Server adapter can currently operate in two modes, ADO and ODBC, each of which uses a different interface to access the db. The ADO interface is currently the default, while ODBC can be specified as an option. I propose this situation is reversed, and that use of the ADO interface is deprecated, if not removed altogether. Here are some reasons, I'm sure there are more: a) ADO uses