search for: odbcini

...C, so it doesn't >> require LD_LIBRARY_PATH to be set up for ODBC at all. >> >> I then added the ODBC library path into the LD_LIBRARY_PATH in R Console. >> >> I found that this problem is solved... >> >> But then the R Console complained that the "ODBCINI" was set up correctly. >> >> So I compared the "ODBCINI" in RStudio vs. "ODBCINI" in R Console, found >> the R Console one seems to be missing. >> >> I then copied the "ODBCINI" from RStudio and pasted it into R Console. >> >...

...... I guess RStudio has some special configuration for RODBC, so it doesn't require LD_LIBRARY_PATH to be set up for ODBC at all. I then added the ODBC library path into the LD_LIBRARY_PATH in R Console. I found that this problem is solved... But then the R Console complained that the "ODBCINI" was set up correctly. So I compared the "ODBCINI" in RStudio vs. "ODBCINI" in R Console, found the R Console one seems to be missing. I then copied the "ODBCINI" from RStudio and pasted it into R Console. Now the load("RODBC") can run in the plain R...

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

Greetings, I have an application that connects to a remote SQL Server database using DBI/ODBC. If I run the application via the Rails console, I am able to retrieve data and work with the database just fine. If, however I try to access it via the Web application itself, I get the following error: DBI::DatabaseError (S1000 (0) [unixODBC][FreeTDS][SQL Server]Unable to connect to data source):

Hello, I want to try to connect R to PostgreSQL. I have found that there are three ways: DBI or RODBC or RPostgreSQL. I tried around with DBI and RODBC but didn't get it running. In both cases I'm not clear about how to set the driver/data source. I get this error: x > channel <- odbcConnect("rtest", uid="oliver") x Warning messages: x 1: In

Hi -- I''ve been having problems connecting to a SQL Server database that I thought might be related to the fact I was upgrading Rails to 2.0. However, I also was moving the project to my shiny new macbook. Anyway, after jumping through a few hoops (instaling DBI, etc.), I finally get to my latest error message: <error> DBI::InterfaceError: Could not load driver (no such file to