search for: odbctabl

...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 In...

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

...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)...

...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 no error message so I really don't know what's wrong there. -- Saved useragent "wengo/v1/wengophoneng/wengo/rev12359/trunk/" for peer 2001 -- Executing [100 at my-phones:1] VoiceMail("SIP/2001-08225788", "2000") in new st...

...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 know the asterisk is actually executing that command? also i'm using unixodbc for my voicemail odbcstorage=mydb odbctable=mytable not sure if that has an effect or not. TIA Regards Ron

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 MailboxNumber is the same as the Extension) 2000 => 1234,Dave Robinson,outraspace at hotmail.com 2001 => 1234,Colleen Robinson,petedao at gmail.com 2002...

..._odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 18 14:00:37] WARNING[19914] res_odbc.c: Unable to deallocate database handle? 0 errno=0 [unixODBC][Driver Manager]Function sequence error I have configured in voicemail.conf [general] format=wav49 odbcstorage=sqlserver odbctable=pbx_VoiceMail odbc.ini [kupalaodbc] Description = ODBC connection Driver = ms-sql Servername = ms-sql UID = TestDatabaseDemo database = TestDatabaseDemo Port = 1364 odbcinst.ini [ms-sql] Description = TDS conn...

...same => n,VoiceMail(${EXTEN}@default,u) exten => 703,1,Dial(SIP/ffa9,17,tT) same => n,VoiceMail(${EXTEN}@default,u) *Voicemail Configuration* [general] format=wav49|wav attach=yes maxmsg=999 maxsecs=600! minsecs= 3 skipms=3000 maxlogins=3 odbcstorage=asterisk odbctable=voicemessages emailbody=Dear ${VM_NAME}:\n\n\tjust wanted to let you know you were just ${IF($["${VM_CIDNUM}" = "${ORIG_VM_CIDNUM}"]?left:forwarded)} a ${VM_DUR} long message (number ${VM_MSGNUM})\nin mailbox ${VM_MAILBOX} from ${VM_CALLERID}, on ${VM_DATE},\n${IF($["${VM...

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

...ols ; of connections, Asterisk can be made to work with these servers. [sqlserver] enabled => no dsn => mickeysoft pooling => yes limit => 5 username => oscar password => thegrouch pre-connect => yes [root at Aiur asterisk]# cat /etc/asterisk/voicemail.conf odbcstorage=mysql odbctable=voicemail_messages [root at Aiur asterisk]# asterisk -vvv | grep odbc == Parsing '/etc/asterisk/res_odbc.conf': Found [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load_odbc_config: Adding ENV var: INFORMIXSERVER=my_special_database [Feb 22 18:21:46] NOTICE[21214]: res_odbc.c:229 load...