search for: trusted_connection

...book "Data Manipulation with R," but I just can't quite seem to get things to work.   Right now, I have code that looks something like:   channel <- odbcDriverConnect ("Driver=SQL Server;  Server=Fred; Connection=xx.x.x.xxx Database=mydatabasename;  uid=pmiller; pwd=password;  Trusted_Connection=FALSE;")   When I run this code, I get the following error:   [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified   I do seem to be able to make a connection if I use:   channel <- odbcDriverConnect("dr...

...language R version.string R version 2.5.0 (2007-04-23) > library(RODBC) > channel <- odbcConnect("TLIAS01", uid="jeff.lindon") > channel RODB Connection 1 Details: case=nochange DSN=TLIAS01 UID=jeff.lindon Trusted_Connection=Yes WSID=TLIJLINDON DATABASE=tliresearch > d <- sqlFetch(channel, District) Error in odbcTableExists(channel, sqtable) : object "District" not found I have checked this problem with our CIO and he confirmed my Data Source configuration is correct (the connection test c...

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)

...#39;?' are returned as '?'. I've added the sessionInfo() output from both machines. Any suggestions on how to fix the problem? Best regards, Thierry library(DBI) con <- dbConnect(odbc::odbc(), .connection_string = "Driver=the_drive;Server=our_server;Database=the_database;Trusted_Connection=Yes;") dbGetQuery(con, sql_statement) R version 3.4.2 (2017-09-28) Platform: i386-w64-mingw32/i386 (32-bit) Running under: Windows 7 x64 (build 7601) Service Pack 1 Matrix products: default locale: [1] LC_COLLATE=Dutch_Belgium.1252 LC_CTYPE=Dutch_Belgium.1252 LC_MONETARY=Dutch_Belgium.125...

Dear List, Would anyone know how to perform prepared queries with ROBC ? I had a shot with some of the internal (non-exported) functions of the package but ended up with a segfault, so I prefer asking around before experimenting further... Thanks, Laurent

Perdon, corrijo, es justo eso... En cuanto hay uan cadena de tipo varchar falla. Es por temas de codificaciones en el driver. ?Como cambio la codificacion? Un saludo Jesus ________________________________ De: David Luna <ofc587a87 en gmail.com> Enviado: viernes, 2 de marzo de 2018 15:02 Para: Jes?s Para Fern?ndez Cc: r-help-es en r-project.org Asunto: Re: [R-es] Problemas de conexion con

...sage is displayed. I am using version 1.6.2 of R. The following is an example of this bewildering problem. > library(RODBC) > channel<-odbcConnect("") > > channel RODB Connection 0 Details: case=nochange DSN=Sheetz2 UID= PWD= WSID=WS1223 DATABASE=Sheetz2 Trusted_Connection=Yes > > > > odbcClose(channel) > > channel<-odbcConnect("") Warning messages: 1: [RODBC] ERROR: state IM008, code 0, message [Microsoft][ODBC Driver Manager] Dialog failed 2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn, ";UID=&q...

...ow codes. Can anyone identify and let me know where did i go wrong??? Thanks in anticipation :) library(RODBC) myconn <- odbcConnect("RDATABASE") myconn RODB Connection 6 Details: case=nochange DSN=RDATABASE Description=Database for R UID=Madana_Babu WSID=IBLPN1B049040 Trusted_Connection=Yes NEWDATASQL1 <- sqlFetch(myconne, CampaignDataLarge) Error in odbcTableExists(channel, sqtable) : object 'CampaignDataLarge' not found NEWDATASQL2 <- sqlFetch(myconne, CampaignDataLarge, colnames = FALSE, rownames = TRUE) Error in odbcTableExists(channel, sqtable) : object ...

...works well with RODBC Version 1.2-5 but not with version 1.3-0. Here is the code of the test example: sink(file = "proto.txt", append = FALSE, type = "output",split = TRUE) library(RODBC) sessionInfo() str <- "DRIVER=SQL Server;SERVER=NN;APP=Test;DATABASE=Northwind;Trusted_Connection=YES" sql.ch <- odbcDriverConnect(connection = str, case = "nochange", believeNRows = TRUE) sql <- "Select top 10 * From sysindexes" cat(date(),"Start query\n") rc <- sqlQuery(sql.ch, sql) print(rc) odbcCloseAll() sink() This is the output of the c...

...utilicé para aprender, espero que le sea útil. > > > > > > cn <- odbcDriverConnect(connection="Driver={SQL Server Native Client > 11.0}; > > server=localhost; > > database=far; > > trusted_connection=yes;") > > # DESKTOP-HEO7TLB > > cosa <- sqlFetch(cn,'cosa') > > cosa > > > > A <- c(1,2,3,4) > > B <- c(4,5,6,7) > > dat <- data.frame(A,B) > > colnames(dat) <- c("A", "B") > > sqlSave(cn, dat, ta...

Buen dia compañerxs de R, les traigo una pregunta bastante especifica. En el trabajo me estan requiriendo el uso de SQL, asi q estoy aprendiendo a usarlo desde R, con el paquete RODBC. Mi problema puntual es que al crear una tabla en el servidor SQL a partir de un data frame en R (usando la funcion sqlSave) no puedo definir el tipo de variables que quiero usar en el data frame. Segun entiendo

...> language R > version.string R version 2.5.0 (2007-04-23) >> library(RODBC) >> channel <- odbcConnect("TLIAS01", uid="jeff.lindon") >> channel > RODB Connection 1 > Details: > case=nochange > DSN=TLIAS01 > UID=jeff.lindon > Trusted_Connection=Yes > WSID=TLIJLINDON > DATABASE=tliresearch >> d <- sqlFetch(channel, District) > Error in odbcTableExists(channel, sqtable) : > object "District" not found > > I have checked this problem with our CIO and he confirmed my Data Source > configuration...

...exion con base de datso Estimado Jes?s Para Fern?ndez Pruebe realizar algo desde cero solo con el fin de comprobar la respuesta, algo gen?rico como puede ser: cn <- odbcDriverConnect(connection="Driver={SQL Server Native Client 11.0};server=localhost;database=AdventureWorksDW2012;trusted_connection=yes;") dataFetchEUR <- sqlFetch(cn, 'vResellerSalesAmountEUR', colnames=FALSE, rows_at_time=1000) Reemplace lo menos posible, si falla posiblemente hay un mensaje de error con alguna pista. Javier Rub?n Marcuzzi El 2 de marzo de 2018, 11:19, Jes?s Para Fern?ndez <j.pa...

...utilicé para aprender, espero que le sea útil. > > > > > > cn <- odbcDriverConnect(connection="Driver={SQL Server Native Client > 11.0}; > > server=localhost; > > database=far; > > trusted_connection=yes;") > > # DESKTOP-HEO7TLB > > cosa <- sqlFetch(cn,'cosa') > > cosa > > > > A <- c(1,2,3,4) > > B <- c(4,5,6,7) > > dat <- data.frame(A,B) > > colnames(dat) <- c("A", "B") > > sqlSave(cn, dat, ta...