search for: trusted_connection

Displaying 14 results from an estimated 14 matches for "trusted_connection".

2010 Mar 25
3
Reading SQL Server Tables using RODBC
...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...
2007 Jul 26
1
SQL server service pack 2 prob? (PR#9810)
...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...
2009 Feb 12
4
Rails & unixODBC
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)
2018 Mar 14
1
Problem with reading data from an UTF-16 database
...#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...
2006 Feb 27
4
prepared query with RODBC ?
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
2018 Mar 02
2
Problemas de conexion con base de datso
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
2003 Aug 06
1
RODBC with Windows XP
...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...
2009 May 21
1
Error in importing table from SQL to R
...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 ...
2009 Sep 08
0
RODBC version 1.3-0 crashes with systemtables using SQL server 2000
...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...
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
...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...
2017 Jul 12
2
consulta por varTypes de sqlSave en RODBC
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
2007 Jul 26
0
(PR#9810) Problem with careless user of RODBC (was SQL
...> 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...
2018 Mar 02
3
Problemas de conexion con base de datso
...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...
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
...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...