search for: dbo

...ot;TimeH" "Day" "Holiday" [7] "Corte optimo" "Corte diario" Y si obtengo los nombres de la tabla SQL: sqlColumns(conexion1, "AUXILIAR") TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME OS MKOnline dbo AUXILIAR Date OS MKOnline dbo AUXILIAR Time OS MKOnline dbo AUXILIAR Seasson OS MKOnline dbo AUXILIAR TimeH OS MKOnline dbo AUXILIAR Day OS MKOnline dbo AUXILIAR Holiday OS MKOnline dbo AUXILIAR Corte optimo OS MKOnline dbo AUXILIAR Corte diario Los nombres son idénticos por lo que intuyo que el...

...language R > library(RODBC) library(RODBC) > channel <- odbcConnect("SCADA2","ways1","LO&B*O",case="msaccess") > channel channel [1] 0 And an abreviated table list is: ... 25 Runtime dbo AnalogHistory TABLE ... When I try to query the table, I get: > test <- sqlQuery(channel,"select datetime, value from analoghistory where tagname = 'a055-re-0020_ph_pv_flt' and datetime >= 'nov 1, 2001 2:00pm'") > test test [1] "37000...

Greetings guRus -- I have successfully queried a large (24,445 rows by 281 cols.) in-house database using the following RODBC query (without the line breaks) testout <- sqlQuery(channel, "select idSchedule,EXCL_Total from dbo.vwC1198_2006_RawData_With_CMPL_EXCL") This returns a dataframe of 24445 rows and two columns (as intended), but the following command testout <- sqlFetch(channel,"dbo.vwC1198_2006_RawData_With_CMPL_EXCL",colnames = TRUE,rownames = "idSchedule") returns the er...

...language R > library(RODBC) library(RODBC) > channel <- odbcConnect("SCADA2","ways1","LO&B*O",case="msaccess") > channel channel [1] 0 And an abbreviated table list is: ... 25 Runtime dbo AnalogHistory TABLE ... A abbreviated Column List is as follows: > odbcColumns(channel,"AnalogHistory") odbcColumns(channel,"AnalogHistory") [1] 1 > sqlGetResults(channel) sqlGetResults(channel) TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_...

I am using sqlSave to save my data into an existing table at MS SQL Server database. Previously my code ran smoothly but all of a sudden it stopped working. Here is my code: sqlSave(con, highVol, "dbo.futuresHighVol", append=TRUE, rownames=FALSE) Error: sqlSave(con, highVol, "jrgchis.dbo.futuresHighVol", append = TRUE, : 42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL Server] 'futuresHighVol' already exist [RODBC] ERROR: Could not SQLExecDirect 'CREATE TABLE jr...

...Server_Name "0.91" "03.52" "MSSDEV1" > sqlColumns(conn, "v_MAFiles") TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS 1 H41 dbo v_MAFiles ReleaseId 1 char 3 3 NA 2 H41 dbo v_MAFiles AsOfDate -9 date 10 20 NA 3 H41 dbo v_MAFiles GeneratedDate 93 datetime 23 16 3 4 H41...

...## GET DATA ########################## ##################################################################### ############################## SYSTEM spot ########################## # Hent data fra SQL Server sys <- sqlQuery (ch, paste("SELECT SP.lokaldatotid, SP.pris FROM DataIndsamling2.dbo.SpotPriser SP", "WHERE (SP.omraade_id= 0 AND SP.lokaldatotid >= '2005-01-01 00:00:00')")) #Definer dato og tid kolonne sys$lokaldatotid <- as.POSIXct(sys$lokaldatotid) #Make a XTS object sys_xts <- xts(sys[,-1], order.by=sys[,1]) # Recalc...

...e dataset "schema" into a SQL Server CREATE TABLE statement (and INSERT INTO statements)? For example. > str(cars) 'data.frame': 50 obs. of 2 variables: $ speed: num 4 4 7 7 8 9 10 10 10 11 ... $ dist : num 2 10 4 22 16 10 18 26 34 17 ... > would become create table dbo.cars ( id int identity(1,1) not null, speed int not null, dist int not null, constraint PK_id primary key clustered (id ASC) on [PRIMARY] ) insert into dbo.cars values (N'4', N'2'),...

This should be easy, but I''m stumped... class X < ActiveRecord::Base belongs_to :y end class Y < ActiveRecord::Base has_many :x end The y table has a column names. The x table has a column value. I want the list of values in x for the name "Location" in y. Yes, there are many repetitions. I can probably hack together an SQL statement to do this without too much

I got a table on SQL Server, which has columns EquationId (int) and Formula (varch(900)). I need to select Formula with certain EquationId, for example, Select Formula from OGA_DEV.dbo.Equation where EquationId = 3 I tried to work within RGui using RODBC: > library(RODBC) > conn = odbcConnect("SQL Server") > odbcQuery(conn, "Select Formula from OGA_DEV.dbo.Equation where EquationId = 3") [1] 1 > results = sqlGetResults(conn) > close(conn) >...

...am using RStudio. I wish to connect to several SQL Server 2012 databases from R. This page helped me get started. http://andersspur.wordpress.com/2013/11/26/connect-r-to-sql-server-2012-and-14/ I set up my connection with TSQLFundamentals2008 as the default database. I then read in the table dbo.orders with the following code. > library(RODBC) > con = odbcConnect("SQLServer2012") > orders1 = sqlFetch(con,"dbo.orders") > odbcClose("SQLServer2012") Error in odbcClose("SQLServer2012") : argument is not an open RODBC channel > >...

Hi, I want to retrieve the set of key & values which returns from a stored procedure : connection.select_all "exec common.dbo.scr_lookupric ''AAP.N'' ". The results i want to display in a view screen call result.rhtml. Please help me out ASAP. Thanks in advance. joshua... -- Posted via http://www.ruby-forum.com/.

Dear all, I would like R to retrieve a table resulting from execute sql stored procedures. What function can I use? Can RODBC do it. I tried channel1 <- odbcConnect("ptsecmstqa01-alpha") query <- paste("execute DB.dbo.usp_test") Data<- sqlQuery(channel1, query) However, it returned blank. Best Regards, Suphajak Ngamlak Equity and Derivatives Trading Phatra Securities Public Company Limited Tel: (66)2-305-9179 Email: suphajak@phatrasecurities.com [[alternative HTML version deleted]]

...base. When I create a recipe object, it works fine and I can see all the feeds that it''s a part of but when I create a feed object and try to access all its recipes I get an error saying: OLE error code:80040E37 in Microsoft OLE DB Provider for SQL Server Invalid object name ''dbo.msn_lifestyles_feeds_recipes'' I''ve also tried this using has_many :through and I get the same error. Any help on this would be greatly appreciated. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups &q...

Hello, Now I'm testing func_odbc and hash. My configurations are: func_odbc.conf [GETNUMBER] dsn=sqlserver ;mode=multirow ;rowlimit=10 readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers WHERE number=${SQL_ESC(${ARG1})} extensions.conf exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(NUMERIS=37037210602) exten => s,n,Set(HASH(RESULTATAS)=${ODBC_GETNUMBER(${NUMERIS})}) exten => s,n,Verbose(1, Number is ${HASH(RESULTATAS, numb...

...| +---------------------------------------+ When I make a call I get the following error in console: Unable to retrieve database handle. CDR failed. SQL Execute returned an error -1: 23000: [FreeTDS][SQL Server]Cannot insert the value NULL into column 'calldate', table 'production.dbo.cdr'; column does not allow nulls. INSERT fails. (153) SQL Execute returned an error -1: 01000: [FreeTDS][SQL Server]The statement has been terminated. (55) SQL Execute error -1! Attempting a reconnect... Connection is down attempting to reconnect... Disconnected 0 from sqlserver [DSN_NAME] Dat...

...ist(y=list(relation="free")),type="b", skip=c(rep(F,11),T)) 2- Actually i've another question concerning the same code, i also have to plot the sum of each of the values for a given year (cause they're mass loadings of pollutants), e.g. for each year with variable "DBO" and state "MAGDALENA" i've to sum the values and show them as a single point in a plot, i tried this but it's not working xyplot(sum(Valor,na.rm=T)~Año|Dpto+Var,groups=Rio,data=na.omit(car), layout=c(3,3),scale=list(y=list(relation="free")),type="p") Co...

Buenas, Tengo un problema y es que intentando conectarme a una base de datos SQL Server, tras cosneguirme conectarme usando el paquete odbc, me deja acceder al contenido de algunas tablas (mediante un select), pero sin embargo en otras me pone lo siguiente: Error in new_result(connection en ptr, statement) : std::bad_alloc No entiendo muy bien porque me salta ese error, ya que desde SQL si

...7] ERROR[2545]: cdr_tds.c:464 tds_error_handler: General SQL Server error: Check messages from the SQL Server (207) [Dec 23 09:25:17] NOTICE[2545]: cdr_tds.c:266 tds_log: Failed to execute INSERT statement, retrying... I executed this (as indicated in cdr_tds.c) to create the table: CREATE TABLE [dbo].[cdr] ( [accountcode] [varchar] (20) NULL , [src] [varchar] (80) NULL , [dst] [varchar] (80) NULL , [dcontext] [varchar] (80) NULL , [clid] [varchar] (80) NULL , [channel] [varchar] (80) NULL , [dstchannel] [varchar] (80) NULL , [last...

I have a legacy DB without access to change the user or group table (must use StoredProcedures to edit those). But I do have access to the usergroup join so I thought the joins would be pretty much like my other rails apps where I do HABTM checkboxes. I''ve created a page that just shows habtm checkboxes for the join and the updates are occuring for the join but I''m