similar to: ROR and MSSQL server.

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008 database. I configured ODBC, but I receive this errors. [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail

Hello, running plain samba 3.023c on debian, I'm trying to connect to a samba share from within a stored procedure. This works as long as samba is in "share" mode: [2006/09/29 14:53:01, 5] auth/auth.c:check_ntlm_password(309) check_ntlm_password: guest authentication for user [] -> [] -> [nobody] succeeded When I try to attach samba share manually when logged in as the

maybe someone here can help me understand why I am getting this strange behaivor. I am connecting to a MS SQL server from PHP by the ODBC module, I use unixODBC-2.2.9-1, freetds-0.63-1.2.el4.rf and php-4.3.9-3.9 all but the freetds package came with CentOS-4.2 + updates the problem is that I am getting -1 from the odbc_num_rows(); function, I search the net and it looks that this is a very

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 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, 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

Hi All, I am having a problem to access multiple databases with mssql I am running Ruby 1.8.4 and Rails 1.1 on Windows 2000 Advanced Server. I am simply trying to integrate the application I wrote before for Oracle to Mssql. The application works perfectly with Oracle with the installed driver OCI8. The app retrives data based on a search criteria from those databases. I followed the directions

Hello I am having trouble setting up the cdr_odbc with MSSQL server. Has anybody done this? I have followed what little documentation I can find. Asterisk errors on a connection error, but tcpdump doesn't even show an attempt. Does anybody have some examples for MSSQL ODBC CDR? I've downloaded unixODBC and the FreeTDS project, recompiled asterisk.... Thanks Duane Cox --------------

Hi all, I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server using freetds and unixodbc, which works with 1.6.1.20. With the same config in 1.8 I get an error when trying to start asterisk which says: [Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined

Hi, I took the following doc: http://karlkatzke.com/centos-44-ms-sql-freetds-and-php/ (which now appears offline, but was written by Karl Katzke) And ported it to CentOS 5.x (php-5.1.6) by modifying the php.spec that he supplied I'd like to import this into the wiki under the HowTO section. My username is KyleODonnell Let me know what you think. Regards, Kyle O'Donnell

Hi, guys! I'm trying to use php-mssql and I've tested the same php program on two servers (CEntOS-5 and Debian). CEntOS-5.2 (final) - php 5.1.6-20 - php-mssql 5.1.6-15 (from "extras" repository). - freetds 0.64-11 --------------------------- php test code -------------------------------- <?php ini_set('display_errors',1); error_reporting(E_ALL);

The activerecord-sqlserver-adapter gem is still sort of available via gems.rubyonrails.org, but it will not install on machines that have Rails 2.1 (or its version of ActiveSupport) installed. This has been confirmed with versions of rubygems through 1.2. This seems to indicate that Rails is no longer tested against the MSSQL adapter and that the adapter is also no longer tested against Rails

Hi there ! I''m drilling for some framework/apserver solution and come to RoR. After using InstantRails, I would try to run it on my test platform (Solarix 10 x86 on 1 machine, Sybase ASE on another, FreeTDS for the join). I could not manage to have the sybase driver for ruby compile with FreeTDS. So I try to run a ODBC bridge. All seems good (freeTDS runnin, unixODBC working with

I am having a strange issue. I have upgraded to ruby 1.9.1 to do some testing on one of my machines. My app accesses a MSSQL database to pull in some information. Everything worked fine with ruby 1.8.6, but now if I try to navigate to a page that accesses that database I get this error: DBI::InterfaceError in PagesController#company Unable to load driver ''ODBC'' (underlying

So I got my rails app to connect to the SQLServer via ODBC, and I can model/scaffold, yada yada.. but when I need to exec a stored proc using sql_server.rb I get undefined local variable or method `connection'' how can that be, if I can connect for everthing else? thanks -- Posted via http://www.ruby-forum.com/.

Hi everyone. I'm trying to use a windows third part software, and it uses a MSSQL database stored in a Windows 2008 Server. For this, I have Ubuntu 11, Wine 1.2 and WineTricks. Following the instructions on "How to configure Wine", the chapter 3.6 tell me to install MDAC_TYP.EXE, and then run CLICONFG.EXE and ODBCAD32.EXE. I did this. I run ODBCAD32 to configure my System DNS, but

Hi All I have an Asterisk 1.8.32.3 instance that will at random intervals stop logging CDR data to MSSQL via FreeTDS. On investigation I'll find that the FreeTDS module has been unloaded somehow. It is not listed in cdr show status or show module like. Trying module load cdr_tds results in module cdr_tds does not provide a license key and the module is not loaded. The only way to get

Hi all, When i use the ''delete_all'' function to remove a few rows from my database, it causes a deadlock on the sql server. The delete seems to be successful, it then redirects to the ''view'' page, and the record does appear to be deleted as far as the ''view'' rails page shows. BUT if i go into sql query analyser, i can''t do a

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