search for: mydsn

I am trying to connect sybase sql databast from R using RODBC pkg and getting the following error ( i chnaged names to my*** but when I actually execute it, I put down names explicitly not calling some character strings) > channel = odbcConnect(dsn='mydsn',uid='myid',pwd='mypasswd') Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRow...

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 Ctrl-C ^C There were 50 or more warnings (use warnings() to see the first 50) > warnings()[1:2] Warning messages: 1: In odbcDriverConnect("DS...

...#39;usual' way for the 64-bit ODBC (i.e., per the R Import/Export manual) and everything is fine." I have tried creating DSN's using c:\windows\sysWOW64\odbcad32.exe and referencing those with RODBC, but I come up with errors: > library(RODBC); > channel <- odbcConnect("myDSN"); Warning messages: 1: In odbcDriverConnect("DSN=myDSN") : [RODBC] ERROR: state IM014, code 0, message [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application 2: In odbcDriverConnect("DSN=myDSN") : ODBC conn...

...ete 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? Gracias -- Patricia García González [[alternative HTML version deleted]]

...ete 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? Gracias -- Patricia García González [[alternative HTML version deleted]]

...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 would be preferable to cut out the MS access middle-man. The command I'm attempting to use is: conn<- odbcConnect(dsn='myDSN', uid = "myUID", pwd = "myPWD", case = "oracle",believeNRows=FALSE) I wouldn't be surprised if there is an issue with the dsn configuration and not R (though I cant find it) so any tips as to things that I should check there would also be gratefully received....

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

...t show up :( what is really strange is that I have also set up the same odbc database for func_odbc, and registered my custom SQL functions and can access these (the db manager shows that this session is connected) cdr.conf ========== [general] enable=yes cdr_odbc.conf ========== [general] dsn=mydsn username=myuser password=mypassword loguniqueid=yes dispositionstring=yes table=PUB.cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT I must be missing something really really obvious here and would appreciate any help Julian

...person to experience it I''ve installed FreeTDS and unixODBC from DarwinPorts, along with rb- odbc and rb-dbi. I can connect to my SQL Server from tsql, but ActiveRecord won''t connect, and from in irb I get this error: irb(main):003:0> dbh = DBI.connect(''dbi:ODBC:MYDSN'',''MYUSER'',''MYPASS'') NoMethodError: undefined method `default_attributes'' for #<ODBC::Driver:0x485a24 @attrs={}, @name=nil> from /opt/local/lib/ruby/vendor_ruby/1.8/dbi/dbi.rb:580:in `connect'' from /opt/local/...

Hello R-Experts, I've got a question, concerning the automation of a number of regressions (lm) with the help of a loop (for i in ....). The situation is as follows (the code follows after that): I have my data in an access database. I have historical data for 2000 parts, for each of this parts I want to do a regression analysis, so I need to do 2000 regressions (just for one country, there