similar to: Date time, MSSQL and RODBC

Here is my problem: Autoregressive models are very interesting in forecasting consumptions (eg water, gas etc). Generally time series of this type have a long history with relatively simple patterns and can be useful to add external regressors for calendar events (holydays, vacations etc). arima() is a very powerful function but kalman filter is very slow (and I foun difficulties of estimation)

I have not found an easy way to compress a file on filesystem. Especially I'd like to compress a pdf from pdf() function/device. Is it possible to compress It on the flight? I'd like to do something like: pdf(gzipconnection()) dev.off() If It is not possible, how can I create a gzip with the pdf? Thanks Daniele A. ________________________________ ORS Srl Via Agostino Morando 1/3

I have a piece of code as the one at the bottom, unfortunately since it involves time series from a db it's not easy to give to mailing list a working script. It becomes very slow after few hundred iterations over variable sp (must process several thousands). The Rprof() indicates that the problem is the use of gc(). Can someone indicate what I have to take care of not to call gc() so often?

I have data for different items (ID) in a database. For each ID I have to get: - Timestamp of the observation (timestamp); - numerical value (val) that will be my response variable in some kind of model; - a variable number of variables in a know set (if value for a specific variable is not present in DB it is 0). To get to the above mentioned values I have to cycle

I'm wondering how to save an object (models like lm, loess, etc) in a DB to retrieve and use it afterwards, an example: wind_ms <- abs(rnorm(24*30)*4+8) air_kgm3 <- rnorm(24*30, 0.1)*0.1 + 1.1 wind_dg <- rnorm(24*30) * 360/7 ms <- c(0:25) kw_mm92 <- c(0,0,0,20,94,205,391,645,979,1375,1795,2000,2040) kw_mm92 <- c(kw_mm92, rep(2050, length(ms)-length(kw_mm92))) modelspline

I?m wondering which is the most efficient (time, than memory usage) way to obtain a multivariate time series object from a data frame (the easiest data structure to get data from a database trough RODBC). I have a starting point using timeSeries or xts library (these libraries can handle time zones), below you can find code to test. Merging parallelization (cbind) is something I?m thinking at

Hi, I have tried to install the R package Rcplex on windows xp without success. I have only cplex_studio124.win-x86-32 version. I have modified the makevars.win file as indicated in the installation guide ( http://cran.r-project.org/web/packages/Rcplex/INSTALL ), then I zipped the whole folder to order an installation from a zipped file (utils :menuInstallLocal()) The message I had is file

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd" db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

Send CentOS-announce mailing list submissions to centos-announce at centos.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.centos.org/mailman/listinfo/centos-announce or, via email, send a message with subject or body 'help' to centos-announce-request at centos.org You can reach the person managing the list at centos-announce-owner at centos.org When

> I was just reading your post though a google search and was wondering how > this has been working for you since then. I need to setup the same exact > sort of thing and hoped to get any advice. I haven''t used MS SQL in Rails for awhile (lately, my backend data stores have been SOAP, MySQL, or LDAP). I''m planning to try JDBC through JRuby for an upcoming project

Hello, I have rails using a MSSQL db. The set up works fine with low volume, but with 2+ requests/second I keep on getting the following error: DBI::DatabaseError: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 Exception occurred.: SELECT

Hi All, I am having a problem to access multiple databases with mssql I am running Ruby 1.8.4 and Rails 1.1 on Windows 2000 Advanced Server. I am simply trying to integrate the application I wrote before for Oracle to Mssql. The application works perfectly with Oracle with the installed driver OCI8. The app retrives data based on a search criteria from those databases. I followed the directions

I''m trying to use activerecord outside of rails with a legacy mssql database. Reading from the db works, but when I try to save a new object (i.e. insert) I get the following error. DatabaseError: Execute (ActiveRecord::StatementInvalid) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction

hey there folks, i have a bit of a sitch here and i would love some help/input on it. i''ve inherited a horrible asp/mssql app that i''m re-writting using rails, but unfortunately i have to keep the asp version up and running. in order to do so i''ve had to write some admin functions, which i''ve done in rails. because the mssql schema wasn''t written

Hello all. I have just gotten the Agile development with ROR book and am evaluating whether ROR would be suitable for our needs. After reading some of the book I am thinking that ROR might not be able to handle the GUID datatype as primary keys in SQL server. Specifically primary keys in SQL server are created after the record is created and might not be available to the activerecord unless the

Dear Master I am new comer in this mailing list. Can you tell me how to connect BDE and ODBC for MSSQL connection using wine. I have already install BDE from Delphi 5 and DBCrab from Winetools. ODBC is OK to connect MS SQL database. But when I joint with BDE using ODBC to connect database there is some error like : [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or

Hello, I'm trying to execute a stored procedure on a MSSQL Server from the dial plan, but it's not working. I'm getting the following error: Unable to execute query.... Asterisk has been compiled with UnixODBC, and I've done the necessary configurations in func_odbc, res_odbc and odbc.ini. Has anyone done this before with success? -------------- next part -------------- An HTML

maybe someone here can help me understand why I am getting this strange behaivor. I am connecting to a MS SQL server from PHP by the ODBC module, I use unixODBC-2.2.9-1, freetds-0.63-1.2.el4.rf and php-4.3.9-3.9 all but the freetds package came with CentOS-4.2 + updates the problem is that I am getting -1 from the odbc_num_rows(); function, I search the net and it looks that this is a very

Hi all, The asterisk book states the following for using ODBC to connect to an MS database. ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple connections (up to limit connections) to a database while ensuring that each connection has only one statement executing at once (this is due to a limitation in the protocol

Hi, I have been encountering this error when I try to save text with japanese characters: DBI::DatabaseError: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server Line 1: Incorrect syntax near ''20070730''. HRESULT error code:0x80020009 Exception occurred.: INSERT INTO categories ([category_name], [updated_at], [created_by],