similar to: SQLServer + (OSX/linux) + accents

Hello all, I am trying to connect to my remote MS SQL server from Ubuntu. I have followed HowtoConnectToMicrosoftSQLServerFromRailsOnLinux<http://http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux>as best that I can. TSQL is working, example below. My configs are found below. When I run isql : > isql -v pubs name password [IM002][unixODBC][Driver

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

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

Hello Everyone, I have been reading this mailing list for a while and am impressed with the generous help that many here are eager to provide. Perhaps someone will be able to shed some light on a configuration issue I am having. Thank you in advance for any assistance. First, system setup details: #System Setup# * OS: Fedora Core 4 running in a VMWare box on Windows XP * Database: MS SQL

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver

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

Good Evening, I need some advice. I am in a position at work where I''ve got the boss pretty excited about rails. I think I could swing the Next Generation version of our product to use rails as the platform, but I find myself a little hesitant to do so until I''ve answered a few issues that I''m hoping people on this list could help me with. Firstly, we are tied to

Hello Everyone, I have an installation where the client has a Microsoft SQL database that holds all of their case information. They would like the asterisk system to require users to enter a valid case number when making an outgoing call. I?m seeing some documentation regarding people using Microsoft SQL for CDR storage, however nothing regarding validating authentication using a Microsoft SQL

Hey :) We''re doing this large project, based on a legacy MSSQL database. We''ve had some issues, particularly with datetimes, when communicating with the server. These issues dissapeared after updating our ruby-odbc package to a new version (we''re developing on Linux and MacOS X, and connecting to the remote MSSQL server via FreeTDS and UnixODBC/iODBC, and then ruby-odbc

Hi, I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage (FreeTDS -> Mssql 2008 database). Everything it's working fine, but sometimes I receive this error and Asterisk crashes. [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk /voicemail/default/7002/INBOX'] [Aug 25

Hi all, I have a working 1.0.7 installation and it is recording CDR to mysql. I am using FreeTDS on the system currently to access our MS SQL 2000 server for account verification, we may use it to store CDR records there in the future. I have decided to update the installation to 1.0.9. However, during "make", I receive: make[1]: Entering directory `/usr/src/asterisk/cdr' gcc

Hi! I have this errors compiling Asterisk 1.4.5 cdr_tds.c:86:2: warning: #warning "You have older TDS, you should upgrade!" cdr_tds.c: In function `tds_log': cdr_tds.c:213: error: too many arguments to function `tds_process_simple_query' cdr_tds.c: In function `mssql_connect': cdr_tds.c:326: error: `TDSCONNECTINFO' undeclared (first use in this function) cdr_tds.c:326:

Hi, I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section "Call Detail Recording" -> "cdr_tds" it's "disabled". It only writes that "Depends on: freetds(E)". On another server (same

Hello Dear experts, I am new to Ruby on Rails. Though I want to access to MSSQL 2005 from ruby. I installed tiny_tds using following commands: >sudo apt-get install freetds-dev >gem install tiny_tds And now when I executed @client = TinyTds::Client.new( :username => ''username'', :password => ''password'', :host =>

Hi, I want to use the cdr to record the call log to my Microsoft SQL Server using unixodbc and freetds.... but when I compile, I've got this message.... Does anyone have the same problem and/or know how to solve it ? Thanks Baste regards David Masure make[1]: Entering directory `/usr/src/asterisk/bristuff-0.2.0-RC7k/asterisk-1.0.6/cdr' gcc -pipe -Wall -Wstrict-prototypes

Hi there, I''m running ROR 2.x on Win32 tried to run gem install activerecord-sqlserver-adapter --source http://gems.rubyonrails.org and get this: D:\>gem install activerecord-sqlserver-adapter -source http://gems.rubyonrails.org Bulk updating Gem source index for: http://gems.rubyonrails.org ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find

Buenas, Alguno usa alguno de los paquetes de Microsoft R para la conexion a SQL Server? De ser asi, que paquete y que comandos usais? Yo hasta ahora he usado odbc, de Rstudio, pero me da siempre problemas con el tipo de datos que tiene SQLServer ... Un saludo Jes?s [[alternative HTML version deleted]]

Olly Betts, Has anyone tested the new Edit Distance(SQLServer) algorithm compared to the current one? If you need any inditional information or code, please let us know. Thank you.

Hi! I''ve just started using AR on top of SqlServer 2005 (through ADO: http://www.softiesonrails.com/articles/2006/06/28/activerecord-with-sqlserver-without-rails). Not a Rails site per se, but I''m using AR and ruby to build data aggregation tools. If you have used AR with SqlServer 2005 and met quirks or caveats of some kind, I''d be happy to get some feedback from your

I have been trying to find the adtiverecord adaptor for MS SQL server and attempted to install with the command found on the http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer wiki page: gem install activerecord-sqlserver-adapter --source=http:// gems.rubyonrails.org I then got the error message: ERROR: could not find activerecord-sqlserver-adapter locally or in a