similar to: R to Oracle via RODBC

R-sig-Debian help, I have installed an ODBC Driver for Linux. I want to connect to our database through R via: >library(RODBC) >con <- odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") Warning message: In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") : ODBC connection failed I don't really know whether this

Hi I have problems trying to load asterisk call data into the cdr table using cdr_odbc config. My unixODBC is properly configured and it's working fine (able to connect, load data, query tables, etc.). unixodbc is configured to use easysoft Oracle ODBC library. Table cdr was created following instructions in asterisk wiki site. My /etc/asterisk/cdr_odbc.conf is configured as follow:

Hi, i want to load the cdr into oracle using unixODBC. I'm using RH 9 2.4.20-30.9smp, unixODBC 2.2.6, easysoft odbc driver for oracle 1.3.1. My unixODBC is working well. With isql i can connect to the database, do selects, inserts and so on. I created the table cdr as described on the asterisk wiki site. When i configure the cdr_odbc.conf with the needed values, then * does not start any

Dear all, I have some problems with importing data from an Access data base via RODBC to R. The data base contains several tables, which all are imported consecutively. One table has a column with column name "NO". If I run the code attached on the bottom of the mail I get no complain, but the column name (name of the respective vector of the data.frame) is "Expr1014" instead

Hello, I successfully used RODBC very frequently, but after having updatetd to R 6.0.2, the current RODBC-Version gives me some problems. After connecting to my Oracle-Database via odbcConnect("") (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,

Hello Everyone, I have been reading this mailing list for a while and am impressed with the generous help that many here are eager to provide. Perhaps someone will be able to shed some light on a configuration issue I am having. Thank you in advance for any assistance. First, system setup details: #System Setup# * OS: Fedora Core 4 running in a VMWare box on Windows XP * Database: MS SQL

Hi I'm presently trying to connect to Oracle through RODBC / UnixODBC on linux (Red Hat 5). I've successfully connected through the easysoft drivers but the trial license has run out and I'm trying to connect via the default Oracle 11G driver. However I'm getting the following error > library(RODBC) > setwd (paste("/home/oracle/scripts/R")) > channel

All, I have a set of users who are currently using RODBC on Solaris (2.6 and up) to connect to SQL Server databases. We use unixODBC for a driver manager and Easysoft's ODBC-ODBC bridge underneath. R 1.6.2 is our standard R version. While moving to Linux (RedHat 9) I have become eager to phase out our use of Easysoft, but am tied to SQL Server for the time being. I am curious as to

[sorry, but this is a re-post - I forgot to set the subject line the first time around] Hello, I would like to access an Oracle database running on Solaris from R on my linux desktop. I have had a look at the R Data Import/Export manual, and downloaded RODBC and unixODBC, but I am still quite confused about how to proceed. It appears to me that I still need to get an Oracle ODBC driver, and

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)

Anyone out there using Linux RODBC and unixODBC to connect to a Microsoft SQL server? If possible can someone post a sample .odbc.ini file? I saw a few discussions on the archives a few years ago, but no config file details were available. Thanks, Whit This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended

I have a Zope + DCOracle2 setup, and I was thinking of moving to Zope + eGenix ODBC (which will use unixODBC) however that still leaves me lacking a driver to connect this to the Oracle server. There are a number of variously priced commercial drivers out there like EasySoft, Merant, OpenLink, etc. Someone built upon a previous open source EasySoft driver:

Hi, Version info: R: 1.5.1 RODBC: 0.8.3 Oracle: 8.1.7 unixODBC: 2.2.2 Easysoft ODBC driver: 1.0.0.6 SunOS/Solaris: 5.7 I'm trying to get RODBC working with Oracle on Solaris. I've installed unixODBC and the Easysoft ODBC driver. There are no problems connecting to the DB and executing queries using unixODBC's isql interactive client. Using R and RODBC however, I can open a connection

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

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

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

Hi, I got a big project where i need to read an visual fox pro database, got this working on a windows server running php. But i would like to run this app on a linux machine(ubuntu 11.10). My idea was to use wine to setup the odbc driver and connect to it using php running on my linux machine. Now my question is if this is posible? Many thanks, Ricardo

I try to use BusinessLine98 on my Linux. The database is store on a Win2000 server with SQL server. So I install unixODBC but now I need a ODBC-ODBC bridge to connect my Linux to Win2k/SQLserver!?? EasySoft solution is not free. Is there any free solution?? Perhaps there is another solution without the use of UnixOdbc? Perhaps I can use odbc driver from my windows install via Wine?? Have got

Hi, I have another problem, can you help? When i type: > library(RODBC) > a<-odbcConnect("oracle") > sqlQuery(a,"select DISTINCT(DOENT_ID) from EPISGDHS where (VALFACT BETWEEN 100 AND 50)") Comes the error: [1] "S1000 904 [unixODBC][Easysoft][Oracle]ORA-00904: \"DOENT_ID\": invalid identifier at offset 16" [2] "[RODBC] ERROR: Could