[R] Data source name not found, and no default driver specified

From: Omar Lakkis <uofiowa_at_gmail.com>
Date: Tue 10 May 2005 - 04:38:30 EST

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 value from within R using Sys.getenv().

I connect using odbcConnect("mydsn") where "mydsn" is defined in the .ini file. I also tried
odbcDriverConnect("DRIVER=/opt/informix/lib/cli/libifcli.so;UID=myid;PWD=mypwd;DATABASE=dbname;HOST=myhost;SERVER=myserver;SERVICE=service_port;PROTOCOL=soctcp;") but kept getting teh same error.

What are the usual suspects in this case? how can I track the source of this problem?

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue May 10 04:48:39 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:31:40 EST