Displaying 9 results from an estimated 9 matches for "wsid".
Did you mean:
sid
2007 Jul 26
1
SQL server service pack 2 prob? (PR#9810)
...uage 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 confirmed th...
2016 Apr 12
2
Procesos paralelos
...ta función:
subida <- function( datos, tab)
{
flush.console()
canal2 <- odbcDriverConnect( "case=nochange; Driver=xxx; Server=xxx; Database=xxx; uid=xxx; pwd=xxx; wsid=xxx;")
sqlSave(canal2,datos,tablename= tab, rownames = FALSE, append=TRUE, fast=TRUE )
close(canal2)
rm(canal2)
}
La barr...
2016 Apr 12
2
Procesos paralelos
...bida <- function( datos, tab)
> {
> flush.console()
> canal2 <- odbcDriverConnect( "case=nochange; Driver=xxx; Server=xxx; Database=xxx; uid=xxx; pwd=xxx; wsid=xxx;")
> sqlSave(canal2,datos,tablename= tab, rownames = FALSE, append=TRUE, fast=TRUE )
> close(canal2)
> rm(canal2)
>...
2013 May 09
0
Barra de progreso en RODBC
...de la tabla donde se realizara
la inserción de los datos
asubir <- as.numeric(nrow(datos)) #Numero de registros (filas) de nuestro
df datos que se van a subir al #SQL Server
canal <- odbcDriverConnect( "case=nochange; Driver=SQL Server; Server=X;
Database=X; uid=X; pwd=X; wsid=X;") #Abrimos conexion RODBC
entabla <- as.numeric(sqlQuery(canal,paste("SELECT Count(*) ", " FROM
",tab, sep=""))) #Nº de registro
que hay actualmente en tabla en la que vamos a insertar #los datos
close(canal)...
2003 Aug 06
1
RODBC with Windows XP
...log box appears
and an error message 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: odbcDriverCon...
2009 May 21
1
Error in importing table from SQL to R
...while running the below 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 odbcTableEx...
2007 Jul 26
0
(PR#9810) Problem with careless user of RODBC (was SQL
...rsion.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 (th...
2016 Apr 12
2
Procesos paralelos
...os, tab)
> > {
> > flush.console()
> > canal2 <- odbcDriverConnect( "case=nochange;
> Driver=xxx; Server=xxx; Database=xxx; uid=xxx; pwd=xxx; wsid=xxx;")
> > sqlSave(canal2,datos,tablename= tab, rownames =
> FALSE, append=TRUE, fast=TRUE )
> > close(canal2)
> > rm(canal2)
&...
2011 May 10
0
Series temporales
...gamos la libreria RODBC y forecast para calcular modelos ARIMA
automaticos
library(RODBC)
library(forecast)
#Establecemos la conexion con el SQL Server
channel <- odbcDriverConnect( "case=nochange; Driver=SQL Server;
Server=+++++++; Database=+++++++++; uid=++++++++; pwd=++++++++++;
wsid=++++++++++++;")
#Una vez establecida la conexion consultamos la tabla de la BBDD y la
guardamos en un data frame llamado Total
Total <- sqlQuery(channel,paste("SELECT * FROM
DATOS_FOMENTO_PROVINCIAL_BASE2005 WHERE codprovi is not null "))
#Definimos funcion para calcul...