search for: odbctables

...ot;) (or the necessary information) I receive a much longer output than usual: RODB Connection 0 Details: case=nochange DRIVER={Oracle in OraHome90} ... with all the details. Previously, I just received my connection number (channel). When I try to get data, now, I get an error, e.g. > odbcTables(0) Error in odbcTables(0) : first argument is not an open RODBC channel However, I use the same DSN as ever and it works perfectly from MS-Query, MS- Access and Quest-Toad to connect to Oracle My machine is a Pentium 3 with Windows XP. Any help or suggestions are appreciated! Thanks a lot Ingo...

...as to what I'm missing or doing wrong > library(RODBC) > channel <- ("DSNName") > sqlQuery(channel,"select * from tableX") Error in odbcQuery(channel, query) : NAs in foreign function call (arg 1) In addition: Warning message: NAs introduced by coercion > odbcTables(channel) Error in odbcTables(channel) : NAs in foreign function call (arg 1) In addition: Warning message: NAs introduced by coercion I am successfully able to run queries on the Oracle 8i database using Oracle SqlPlus and also using Easysoft's isql(which uses the odbc.ini file) The .odbc.in...

...the error still remaines. An import into excel via ODBC works fine. So there is no way to figure it out whether this is a bug or a feature.-) The second problem I have is that when I rerun "rm(list = ls(all = T)); gc()" and the import several times I get the following error: Error in odbcTables(channel) : Calloc could not allocate (263168 of 1) memory In addition: Warning messages: 1: Reached total allocation of 447Mb: see help(memory.size) in: odbcQuery(channel, query, rows_at_time) 2: Reached total allocation of 447Mb: see help(memory.size) in: odbcQuery(channel, query, rows_at_time)...

Dear friends, Asterisk's voicemail functions work fine for me, but I am having difficulty storing the voice messages inside mysql. My real-time CDR recording works so I assume the odbc connection is fine. The voicemail.conf I have is : [general] format = wav attach = yes dbuser=root dbpass=sqlpass dbhost=localhost dbname=asterisk odbcstorage=asterisk odbctable=voicemessages Asterisk shows

Hi All, I'm trying to use a php script to send voicemail e-mail so i can send custom e-mail message based on what mailbox. on my voicemail.conf i have mailcmd=/var/www/voicemail.php but when i tried to call an extension and goe to voicemail i'm not receiving the e-mail. but when i execute "php /var/www/voicemail.php" on the shell, i can receive the e-mail. how would i

Dear all, I am still not able to store voicemail into mysql and I am hoping someone can help me out. Here is my voicemail.cof: [general] format = wav attach = yes dbuser=ast dbpass=sqlpass dbhost=localhost dbname=asterisk odbcstorage=asterisk odbctable=voicemessages [default] ; Syntax for new entries looks like this: ; MailboxNumber => password,name,e-mail,pager,options ; (usually, the

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

Hi, I have some issue with voice mail with ODBC on asterisk 11.7 box. I may not understand database functionality on asterisk fully. The most suspected area is func_odbc. I already googled but not luck. Your guide is warmly welcomed *Error messages when I make call and leave message.* -- <SIP/1ffa9-00000007> Playing 'auth-thankyou.g722' (language 'en') [2014-05-28

Hi, I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Back end database DB2 Database name voiceml

I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to