Displaying 20 results from an estimated 500 matches similar to: "odbcConnect - no data source and default driver"
2003 Aug 25
1
ODBC Oracle access
Hi all,
I'm having trouble connecting to an oracle database using RODBC under
winXP. Unfortunately I can't really send a reproducable error as the
initial call to odbcConnect seems to hangs R and I have to kill the
session.
I have been using RODBC to sucessfully connect to an MS Access DB that
has tables linked through to the oracle database in question and that
seems to work OK but it
2010 Dec 17
2
RODBC for 64-bit R with 32-bit Access
Hello Folks,
I do hope this is the correct place to post (and not in R-SIG-DB). I have
spent the better part of a day searching for an answer to this question, and
have yet to resolve it.
I am trying to query an .accdb Access database (with 32-bit Office 2007
currently residing on the machine) with 64-bit R via RODBC. There seem to
be some conflicting accounts as to whether or not this is
2013 Oct 13
0
RODBC not connecting from my Mac
iODBC appears no longer to come standard with OSX, so I installed unixodbc and set it up following instructions here: http://www.boriel.com/en/2013/01/16/postgresql-odbc-connection-from-mac-os-x/
I connected to my remote database with isql -v mydsn. No problem. Then I tried from R:
> library(RODBC)
> pg <- odbcConnect("mydsn") # waited for a couple of minutes before pressing
2005 Apr 08
2
BUG in RODBC with OS X?
This is my second posting on this topic, the first recieved no
replies. Has anyone successfully used RODBC on the OS X platform?
I've tested the ODBC drivers I'm using with two other applications and
I've had no problems. I begining to think the problem is with R/RODBC
and not the drivers.
Here are the specifics:
I'm having a problem connecting to an MS SQL Database via RODBC
2011 Nov 15
2
RODBC conectar MySQL con R
Hola,
Alguno ha usado el paquete RODBC para acceder a una BBDD MySQL desde R en
Windows?
Qu'e mas tengo que hacer a parte de:
1) Aniadir el Driver de MySQL a la lista de User DSN en Control panel ->
Administrative tools -> Data Sources(ODBC)
2) Testear que funciona la conexion
2) Ejecutar: ch <- odbcConnect("mydsn",uid="myui",pwd="mypass")
Alguna idea?
2011 Nov 15
2
RODBC conectar MySQL con R
Hola,
Alguno ha usado el paquete RODBC para acceder a una BBDD MySQL desde R en
Windows?
Qu'e mas tengo que hacer a parte de:
1) Aniadir el Driver de MySQL a la lista de User DSN en Control panel ->
Administrative tools -> Data Sources(ODBC)
2) Testear que funciona la conexion
2) Ejecutar: ch <- odbcConnect("mydsn",uid="myui",pwd="mypass")
Alguna idea?
2005 Oct 29
2
RODBC Error
Hello,
I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to
connect to a PostgreSQL server on the local network. I can't tell
whether my problem is in R, or in ODBC setup.
I got drivers from OpenLink, created a dsn and tested it using the
iODBC application. then I load the RODBC package, use this code and
get the following error. I tried with both the
2005 May 09
0
Data source name not found, and no default driver specified
Using R 2.1.0, RODBC works very well for me. When I move my
application to run for the www-data user under apache I get the
message:
[unixODBC][Driver Manager]Data source name not found, and no default
driver specified
I made sure that the .odbc.ini file is in www-data home's directory
and it is readable. I also defined its location using the environment
variable ODBCINI and verified its
2006 Jun 17
1
ODBC cdr tearing my hair out
svn trunk.
I'm trying to get cdr to work with my odbc database. I have followed a
checklist that I had previously but still can't get it to work. There
are no errors (verbose 40 and debug 40), I get
[cdr_odbc.so] => (ODBC CDR Backend)
== Parsing '/etc/asterisk/cdr_odbc.conf': Found
*CLI> cdr status
CDR logging: enabled
CDR mode: simple
CDR registered backend:
2016 Jun 20
4
RODBC on Mac & _R_CHECK_FORCE_SUGGESTS_
"R CMD check sos" with R 3.3.0 under Mac OS X 10.11.5 ends as
follows:
>* checking package dependencies ... ERROR
>Package suggested but not available: ?RODBC?
>
>The suggested packages are required for a complete check.
>Checking can be attempted without them by setting the environment
>variable _R_CHECK_FORCE_SUGGESTS_ to a false value.
2005 Mar 12
2
RODBC, IODBC and Mac OS X
Dear All,
As some of you in the archive, i am experiencing problems in using
RODBC with IODBC on Mac OS X Panther.
I am currrently facing two problems.
The first one is apparently linked with IODBC (according to returned R
error message) although testing the database access from IODBC manager
seems to work fine.
The second is by far more radical, R purely and simply reports an error
,
2011 Nov 25
1
Help for RODBC usage on mac
Hi all,
I try to use RODBC on my mac machine. I google a lot but could not find a
very comprehensive tutorial. Finally, I install iODBC, but there's no
driver in iODBC. And I found some commercial ODBC driver. Actaully I just
want to learn it ,so free driver will be suitable for me.
Does anyone how to use RODBC on mac environment ? And is there any
comprehensive tutorial on it ?
Thanks
--
2005 Oct 04
1
IODBC instead of UNIXODBC
Hello.
It's possible to use IODBC instead UNIXODBC with realtime?
As I see, the res Makefile load a odbcinst.h file, but
in IODBC there's not this file.
I change the res Makefile (iodbcinst.h instead odbcinst.h)
and the make create the res_odbc.so.
But when asterisk boot it don't start showing:
[res_odbc.so]Oct 4 10:24:43 WARNING[9748]: loader.c:314 __load_resource:
libiodbc.so.2:
2001 Jun 22
4
RODBC
Hi,
I have tried to install.packages("RODBC"), but it balks:
Installing source package `RODBC'' ...
creating cache ./config.cache
checking for library containing SQLTables... no
configure: error: no ODBC driver manager found
ERROR: Configuration failed for package `RODBC''
What am I missing?
What and where should "SQLTables" be? In another package?
What
2002 Jan 11
1
RODBC finding dsn information using OpenLink iODBC drivers
I'm using RODBC to connect to a MS SQL server. I've been able to get it
to work without much of a hitch in windows. However, I'm using
OpenLink's iODBC drivers on the Linux side and I'm not sure how RODBC is
able to find information about the dsn's (which is in the odbc.ini
file?). I've tested the connection with the test program included by
OpenLink and
2003 Oct 15
1
RODBC on Mac OSX pointers?
Hi,
I'm trying to get to grips with accessing my postgresql tables in R
using RODBC. I have Mac OS 10.2.8 (Darwin 6.8) installed and R 1.8.0
installed from source and I have updated RODBC to 1.0-4.
On the ODBC manager end, I am using OpenLink software's iODBC
Administrator and I've set up a User DSN called "PostGRES" - odbctest
suggests that this is functioning:
>
2006 Feb 02
3
Strange SQL Server error
Hi,
In an app I''m developing I''ve run into a strange problem. I''ve created
some controllers and models using the scaffolding generator and
everything seemed to work fine.
However I''ve noticed that a particular model I''ve created always fails
its tests and I can''t test it out in a browser due to the same error I''m
getting which is:
2002 Oct 30
1
RODBC update
There is a new version of RODBC, 0.9-1, with a new maintainer (me)
now on CRAN (Vienna) which works with R 1.6.x. The Windows binary
will be there tomorrow, and both will then propagate around CRAN.
This has been tested on Linux under unixODBC against MySQL and Postgresql
(thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and
Excel. The CRAN compilation checks were against
2002 Oct 30
1
RODBC update
There is a new version of RODBC, 0.9-1, with a new maintainer (me)
now on CRAN (Vienna) which works with R 1.6.x. The Windows binary
will be there tomorrow, and both will then propagate around CRAN.
This has been tested on Linux under unixODBC against MySQL and Postgresql
(thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and
Excel. The CRAN compilation checks were against
2002 Jan 25
1
RODBC, Apache, Linux
This may be as much of a Linux Newbie question as an RODBC question. I've
managed to get iODBC working on my RedHat 7.2 system. I can load the
library and run it as root. However, I would like to be able to run it via
Perl and Apache over the web. I'm not sure what I need to change in order
to let "nobody" (the user running the scripts off of Apache) load the
library. I can