Displaying 20 results from an estimated 700 matches similar to: "func_odbc.c: Unable to execute query"
2007 Nov 28
3
Multiple Return Values from func_odbc
Is there any way to return multiple values from functions defined in func_odbc.conf?
It appears that you can only return one value.
True? Hope not....
Doug.
____________________________________________________________________________________
Be a better pen pal.
Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/
-------------- next part
2014 Apr 03
1
func_odbc
Hi All
Anyone know how to do include files with func_odbc.conf?
I now have several pages of functions in my func_odbc.conf and it is
getting harder to maintain it.
I would like to break them up into files by category. The standard method
of using the #include does not seem to work .
Ideas are appreciated.
Bryant
-------------- next part --------------
An HTML attachment was
2007 Dec 06
3
Setting Multiple Values via func_odbc ...?
I need to insert/update multiple MySQL columns in a single row with the func_odbc function at the SAME TIME.
Someone showed me how to use ARRAY to retrieve multiple values at the same time, but I need to SET multiple values.
Can this be done?
If not, I will just stick with MySQL, but that's a pain in the ass because the asterisk-addons package has no default rpm spec file for building an
2008 Dec 09
2
Func_ODBC question
Hi I have
On func_odbc
[EXEC]
readhandle=ressqlserver
writehandle=ressqlserver
readsql=${ARG1}
writesql=${ARG1}
I'm trying an update on dialplan:
exten=> 141,3,Set(dummy=${ODBC_EXEC(UPDATE Tabla set campo = ${EXTEN})})
On Cli:
WARNING[3579]: func_odbc.c:353 acf_odbc_read: Error -1 in FETCH [UPDATE
Tabla set campo = 4356]
Any idea why is this??
The query
2009 Aug 11
4
func_odbc insert with mssql
I'm trying to use func_odbc to write to a MS SQL db.
Here's my func_odbc conf:
[OPTIN]
dsn=MSSQL-Optin
write=INSERT into OptIn (orgID) values (${VAL1})
Dial Plan
exten => +18665551212,n,Set(ODBC_OPTIN()=dave)
When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using
2015 Mar 10
1
func_odbc 123
with func_odbc, in the definitive asterisk guide, they were suggesting
the possibility that part, or perhaps all of, the dialplan could be
written as SQL statement!?
First off, that sounds like a good idea to me, but the tone of the
authors was suggesting not so much, but that it was a personal preference.
>From a naive perspective, why SQL statements at all? Why not just
database config
2007 Jan 20
1
func_odbc still working in trunk?
Is func_odbc still working in trunk? I've recently (in the last few weeks)
started having a problem where my custom functions don't work. The module
loads, the configuration file is parsed fine, and the functions are even
created and visible in "core show functions", but when executed from the
dialplan I get a "no such function" error. Here's a bit of console
2010 Oct 22
1
MS-SQL / Freetds -- func_odbc
Hi folks,
How would I go about running a stored procedure call from asterisk via
func_odbc.
I'm after an example entry in func_odbc if possible for ast 1.4
Also, if someone could post an insert statement that actually works,
would be nice.
Thanks,
:)
2011 Jan 26
1
Return variables from func_odbc calls?
This is primarily aimed at Sir Lesher, whose name graces the source
code for func_odbc that I'm currently trying to read to answer this
question.
Tilghman (or anyone else who has determined the answer to this query),
I have googled, searched wikis, and I'm currently perusing the source
code, but the long and short of it is that I cannot seem to find any
reference to variables set by
2011 Jan 23
3
FUNC_ODBC and ARRAY
Gentlemen,
I have googled, searched the mailing list archives, and even spoke on
the IRC channel, but have not found an answer to the following
problem. I am attempting to retrieve multiple columns in an ODBC query
using ARRAY per the solutions offered by many individuals. My dialplan
code is as follows:
exten => _.,n,Set(ARRAY(var1,var2,var3)=${ODBC_LOOKUP(${KEYVAL})})
exten =>
2008 Dec 02
1
func_odbc and hash problem
Hello,
Now I'm testing func_odbc and hash. My configurations are:
func_odbc.conf
[GETNUMBER]
dsn=sqlserver
;mode=multirow
;rowlimit=10
readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers
WHERE number=${SQL_ESC(${ARG1})}
extensions.conf
exten => s,1,Ringing
exten => s,n,Wait(4)
exten => s,n,Answer
exten => s,n,Set(NUMERIS=37037210602)
exten =>
2008 Dec 01
1
func_odbc questions
Hello,
I'm working with asterisk 1.6. And I have success using func_odbc with one
row query results (SELECT source,destination from cc WHERE ... ):
exten => s,1,Ringing
exten => s,n,Wait(4)
exten => s,n,Answer
exten =>
s,n,Set(ARRAY(NUMBER,REALNUMBER1,REALNUMBER2,STATUSAS)=${ODBC_GETVARIABLES(${NUMERIS})})
exten => s,n,Verbose(1| ${NUMERIS}, ${REALNUMBER1} ${REALNUMBER1},
2011 Dec 29
0
func_odbc not returning whole smalldatetime MS Sql field.
Hey All,
Odd thing. I am just trying to return the whole date time stamp from a
SMALLDATETIME field in a MS SQL server.
func_odbc.conf = readsql=SELECT DateCreated FROM [REDACTED] WHERE Code
= '${ARG1}'
Problem is I only get the first 15 back from the field. Like so...
Connected to Asterisk 1.8.6.0 currently running on [REDACTED]-dev (pid =
2240)
Verbosity is at least 3
2014 Mar 13
2
func_odbc do not read LIKE predicate
Hello everyone,
I would be extremely glad if someone could help me with the following issue:
cat /etc/asterisk/func_odbc.conf
[call_user]
prefix=GET
dsn=asterisk_odbc_sip
readsql=SELECT name FROM asterisk_sippeers WHERE name = '%477'
Asterisk CLI show the following issue:
-- Executing [205 at phones_wildcard:1]
NoOp("SIP/Y_MD_vlungu_477-00000008",
2008 Jan 30
2
func_odbc - trouble
Hello,
we are migrating an Asterisk install from Trixbox/Asterisk 1.2 to Elastix
0.92 with asterisk-1.4.17 on CentOS 5. I need to migrate an funtion that
consults a remote sybase database, using ODBC and freetds. On the new
server I am able to connect to the database using isql without problems.
When I try to connect from asterisk logs show:
pbx.c: Function ODBC_SQL not registered
Indeed I
2010 May 24
1
[0017330] 1.6.1 and 1.6.2 + MySQL crases on ODBC Query (via func_odbc or sip realtime)
Hi,
I'm expiriencing very annoying issue with Asterisk while using ODBC
on Linux box running Debian with following packages:
Asterisk-node0:/tmp# dpkg -l | grep -i odbc
ii libiodbc2 3.52.6-2
iODBC Driver Manager
ii libmyodbc 3.51.15r409-4 the
MySQL ODBC driver
ii libodbcinstq1c2
2007 Mar 16
1
Problems with MFCR2 and Meridian
Hi List,
I'm trying to connect Asterisk with a Nortel Meridian using an E1 with
MRFR2 signaling.
I've connected both cards, and compiled all the required software...
The problem is every call (outgoing or incoming) got dropped,
complaining about some "T1 timed out"
Only for testing purposes I'm using an application called testcall
included on the lib-unicall package, and
2018 Dec 06
3
how to use a database
On 12/05/2018 05:00 PM, Antony Stone wrote:
> On Wednesday 05 December 2018 at 15:31:38, hw wrote:
>> I don't see a table for that.
>
> You need to create that for yourself.
>
> Asterisk can write to database tables, but doesn't help you set them up, for
> reasons I can't comment on.
How do I know what the schema needs to be? Does anybody have a scheme
for
2009 Jul 27
1
Fax for Asterisk quick question
Hi guys, I have this question:
Can asterisk + fax for asterisk do this ?? Send Fax on Machine A to Fax
machine B??
Fax Machine A--> FXS port on digium card --> asterisk 1.6 --> Sip with t.38
--> internet --> Sip with t.38 --> asterisk 1.6 --> FXS port --> Fax Machine
B
I've been reading documentation for fax for asterisk, but I'll appreciate if
someone can
2010 May 05
3
CDR to MS-SQL via ODBC issue
Hi guys,
Having issue with getting CDR to write to MS-SQL via ODBC.
> cdr_odbc: Connected to freetds-connector
> cdr_odbc: Error in PREPARE -1
> cdr_odbc: Query FAILED Call not logged!
== Spawn extension (cisco, ##########, 2) exited non-zero on
'IAX2/astYYYY-507
Isql test:
[xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY