Displaying 20 results from an estimated 300 matches similar to: "RODBC - problems connecting to oracle through linux"
2009 Aug 12
1
In odbcDriverConnect ODBC connection failed
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
2004 May 12
1
Asterisk not loading data into table using cdr_odbc
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:
2004 Jun 18
0
Asterisk does not start when cdr_odbc ist configured
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
2012 Nov 30
0
Oracle database connction from R in Linux
Hi,
This is sasi.
I installed R 64 bit and oracle client 64 bit in fedora 17. After R is
working fine. Oracle database also working fine. but problem is, If i try
to connect oracle from R its not connecting.
So, pls guide me how to connect from R to oracle.
how, i tried:--
odbcinst.ini file code is
[ORACLE2]
Description = oracle driver
Driver =
2010 Feb 26
1
need help to resolve RODBC error
I've installed R-2.9.2 (64 bit), unixODBC-2.2.14-p2 (64 bit) and RODBC_1.2-5 (64 bit) on a 64 bit Redhat Linux server (Red Hat Enterprise Linux Server release 5.4 (Tikanga), x86_64) release 2.6.18-164.2.1.el5. I've tested the ODBC drive via isql and the test was success:
[yzhang@ROracleTest ~]$ isql -v DRTST yzhang test
+---------------------------------------+
| Connected!
2003 Jan 03
2
R talking to Oracle, ODBC drivers available ?
[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
2002 Aug 02
1
R to Oracle via RODBC
Howdy,
I'm trying to use R to access Oracle 8i using the RODBC package On Linux
Red Hat 7.3.
Specs
R version 1.51
Driver: Easysoft ODBC - Oracle driver
Driver Manager: unixODBC
I get the following error when trying to executing RODBC commands. Can
anybody give me pointers as to what I'm missing or doing wrong
> library(RODBC)
> channel <- ("DSNName")
>
2009 Feb 12
4
Rails & unixODBC
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)
2006 Jul 26
2
RODBC on linux
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
2005 Feb 23
0
Oracle Driver for Linux?
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:
2002 Aug 20
0
RODBC/Solaris/Oracle - No Data
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
2014 Apr 01
3
problema con RStudio
Hola a todos,
Tengo un problema con RStudio y la conexión a una base de datos.
Desde la terminal no tengo problemas para ejecutar, por ejemplo:
library(RODBC)
channel <- odbcConnect("MiBaseDatos", uid = "MiUsuario", pwd =
"MiContrasena")
datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \
, M.STODNR \
...
...
...")
pero desde
2005 Feb 22
6
rodbc or unixodbc error
Hi,
I'm trying to establish a connection to a MySQL database, and am using the
rodbc package for it. This is in a GNU/Debian Linux box, with the
corresponding Debian unstable packages. I can login to my MySQL databases
from any shell and directory, so the problem is probably not there. Here's
an example of what I'm doing:
R> odbcConnect("test",
2014 Apr 01
2
problema con RStudio
Carlos,
al parecer tengo instalado el paquete RODBC en :
/home/luisr/R/i686-pc-linux-gnu-library/3.0/RODBC/
no hay nada en (carpeta vacia):
/usr/local/lib/R/site-library/
en el directorio:
/usr/local/lib/R/site-library
hay paquetes que vienen con R pero RODBC no
saludos,
Luis
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
Luis Ridao Cruz
Faroe Marine Research Institute
Nóatún 1,
2014 Apr 01
3
problema con RStudio
No, no estoy usando Rstudio Server
El 1 de abril de 2014, 9:07, Carlos J. Gil Bellosta
<cgb@datanalytics.com>escribió:
> Una pregunta... no estarás utilizando RStudio server, ¿verdad?
>
> En tal caso, lo que tienes que hacer es configurar
> /etc/rstudio/rstudio.conf tal como indica en
>
> http://www.rstudio.com/ide/docs/server/configuration
>
> En particular,
2003 May 14
0
RODBC and SQL Server
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
2014 Apr 01
2
problema con RStudio
Hola, ¿qué tal?
¿Puedes comparar la salida del comando
Sys.getenv("LD_LIBRARY_PATH")
en una sesión en la que funciona RODBC y otra en la que obtienes el
error anterior?
Un saludo,
Carlos J. Gil Bellosta
http://www.datanalytics.com
P.D.: A propósito, también he estado tratando de utilizar RODBC en
Linux y me he acabado rindiendo. Sobre todo porque RJDBC funciona
bastante bien.
2014 Apr 01
2
problema con RStudio
Pues ahí lo tienes.
De alguna manera R (a través de RStudio) no está incorporando el directorio
/u01/app/luisr/product/11.1.0/client_1/lib
donde se ve que tienes las librerías de ODBC al "LD path". Échale un vistazo a
https://support.rstudio.com/hc/communities/public/questions/200641818-How-to-configure-libPaths-?locale=en-us
Aparentemente RStudio tiene su propio sistema para
2012 Feb 02
2
use wine odbc in ubuntu php application
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