similar to: App_odbcexec

Hi all, I am trying to install the ODBCexec and ODBCquery functions into my dialplan but I'm having difficulties in the installation of app_odbcexec.c itself. I'm using Asterisk 1.2.1 and I've downloaded and installed unixODBC. But when I try to run "make" after editing Makefile and copying the app_odbcexec.c to my asterisk/apps location, this is the output I get: cc -fPIC

Hi all, I am trying to install the ODBCexec and ODBCquery functions into my dialplan but I'm having difficulties in the installation of app_odbcexec.c itself. I'm using Asterisk 1.2.1 and I've downloaded and installed unixODBC. But when I try to run "make" after editing Makefile and copying the app_odbcexec.c to my asterisk/apps location, this is the output I get: cc -fPIC

Ok, sorry for the response on the same thread. This is a new one. The main thing is that with this I set the Store Procedure or Query directly on the dialplan line, is easier to configure, change, manage, etc. I also know that works great with heavy load, and it reconnects when the network goes down and up. Can you help me porting this app? I think woun`t be difficult for someone that

Actually the docs for the Queue application say: 'w' -- allow the called user to write the conversation to disk via Monitor 'W' -- allow the calling user to write the conversation to disk via Monitor couldn't get these to work tho. Does this mean I can do one touch recording with agents, or does it mean I can use the monitor() command? Very confusing... Doug.

Hello, I am new to the RODBC package, but I have looked over the PDF as well as a few websites that go over the SQL language. I can connect to my database fine using >channel<-odbcConnect("Oracle ODBC") # then am prompted to enter my user id and password After that I'd like to use the odbcQuery function and the SQL statement: SELECT * FROM table_name WHERE SAMPLE_YEA LIKE

I have a client requirement that multiple phones can be dialed, however they don't want the pstn phone to pick up automatically because of voicemail etc, nothing can be changed on the phones, how can I handle this requirement, by the way no zap channels are involved, all the pstn phones are behing another sip gateway.

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package When issuing a SqlQuery, I get the following error > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,

Asterisk Ready. *CLI> -- Executing route("SIP/7408-02e3", "370263") in new stack -- odbcquery: query=370263 > Query = 370263 : SQLcmd = select routing, ring_timer from ddi_pool where ddi_inbound = '370263' Urgent handler > app_route: Query Successful! -- Varname= 55 -- odbcquery: set route 721017101 -- odbcquery: set timer 15

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package When issuing a SqlQuery, I get the following error > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,

Hi everyone, I am doing an analysis of reviews in IMDB and am running into trouble getting my data into the right shape for analysis. Key question: I want to know for each word in the IMDB, whether it is over- or under-represented in a particular category (Rating x Genre). I was figuring on estimating this with a g-test, fwiw. But the basic question I'm asking here is about data

Hi, Does anyone know how to pass dynamic sql statement to RODBC function "odbcQuery()" or "sqlQuery()"? eg.: under R session, I did: >library(RODBC) >channel<-odbcConnect(...) >data1<-2.5 >data2<-5.0 I want to construct the INSERT sql statement using variables "data1" and "data2" and pass this statement to odbcQuery() . Can I do this?

New to R, sorry if one or either of these is an inappropriate list for a question like this below; please let me know if this is a general help question. Jill Willie Open Seas Safeco Insurance jilwil at safeco.com -----Original Message----- From: WILLIE, JILL Sent: Thursday, January 25, 2007 2:27 PM To: r-help at stat.math.ethz.ch Subject: reducing RODBC odbcQuery memory use? Basic

Dear R cracks I am trying to fetch 38 Tables from 38 ESRI Geodatabases through an ODBC connection. I stored the 38 channels in a list and the 38 tablenames in an other list. With a for(i in 1:38) .... sqlFetch(....) I try to read the tables into a third list. But always after a certain amount of rounds (mostly 16) i get Fehler in odbcQuery(channel, query, rows_at_time) : Calloc konnte

1. Can I avoid having RODBC use so much memory (35 times the data size or more) making a data.frame & then .rda file via. sqlQuery/save? 2. If not, is there some more appropriate way from w/in R to pull large data sets (2-5GB) into .rda files from sql? [R] reducing RODBC odbcQuery memory use? From: WILLIE, JILL <JILWIL_at_SAFECO.com> Date: Thu 25 Jan 2007 - 22:27:02 GMT

Hello, I am new to R progaming and have just started using this program since last week. What i want to achieve is to use R to determine patterns in sales/ customer complaint etc. information located in a mysql database. I am not sure how to approach this or which technique i should use to do so. However, i had proceeded to add a dataset to RStudio using the following code: library(RODBC) 

Dear list, RODBC is mostly working very well on Windows XP talking to MS SQL Server. However, when trying to retrieve a result set in repeated batches the first batch returns results ok, but then subsequent calls return no data (see code below). I tried setting believeNRows=FALSE both in odbcConnect() and in sqlGetResults() but this doesn't appear to make any difference. Also odbcFetchRows()

I'm trying to load Affy Annotation data from an Access database into R using RODBC. This has worked fine for quite some time. The bug seems to be correlated to RODBC versions 1.1-7 and later. Works fine: R 2.2.0 with RODBC 1.1-4; R 2.3.0 or R 2.4.1 with RODBC 1.1-6 Fails: R 2.3.1 with RDOBC 1.1-7; R 2.4.1 with RODC 1.1-7 or 1.1-8 Details ===== This works fine: Version 2.2.0

You could construct your SQL statement as a character string using paste() and pass this as an argument to sqlQuery. Maybe something like this will work for you: >data1<-2.5 >sql.statement <- paste("SELECT * FROM somewhere WHERE something=", data1, ";", sep="") >library(RODBC) >channel <- odbcConnect(...) >sqlQuery(channel, query =

Hi all, On a fresh CentOS 4.3 box, suddenly what should have took usually around 60 seconds, now it makes me wonder if I can still perform simple sysadmin tasks, or should I get a long vacantion... # yum groupinstall "MySQL Database" Repository update is listed more than once in the configuration Repository base is listed more than once in the configuration Repository addons is listed

Hi everyone, My name is Jennifer Turliuk. I''m currently in Santiago, Chile for the next 6 months as part of the Startup Chile program. I think you may be able to help me out. We are looking to bring on a developer ASAP (see description below). We''d love to hear from you. Or, if you know of anyone that may be interested, we''d be very grateful if you would pass this