similar to: DCOM - RODBC/RMySQL problem

Hi all, I have installed RODBC package. But am not able to connect it for using MySQL. For accessing MySQL Db a connector is required.For that can i use the mysql db which is a part of WAMP server or use separate mysql db. I know there is a package called RMySQL. But i find it very difficult to install the RMySQL package under .Which is better one for accessing MySQL Database. Thanks Amrita

Hi. My VB program run a R - script located in the server with R DCOM server. The R - script is designed to send a query to DB through ODBC. There is NOT any problem when I run each code from R-window interface. However, when I call the R-script from my VB program it stucked after calling "sqlQuery" statement. I can check that odbcConnect(dsn, uid, pwd) returns -1.

R-help list, I ported some R code from MS Windows PC to sun-solaris. Both do queries on the same MySQL database. PC version of R is 1.6.1 and solaris version is 1.6.0. I use RMySQL_0.5-0 (on solaris) and RODBC 1.0-1 on PC to connect to MySQL. The PC version took about 65 mins. to run wheras the Solaris (SunOS 5.7) version took 375 mins. (> 6 hrs). R and RMySQL are resident on the same host

Hello R users, I am reading data into R from RMySQL or SQLite databases which are in Spanish language. I am using RMySQL library and function dbReadTable but I could not get characters with ñ and tilde, instead R does put ?. In the past I could manage it modifying the R options as (using windows): op <- options() op$encoding <- "iso-8859-1" options(op) but now in ubuntu it did

I'm using R on a Linux box: > version platform i686-pc-linux-gnu arch i686 os linux-gnu system i686, linux-gnu status major 1 minor 5.0 year 2002 month 04 day 29 language R I want to use data that is stored in a MySQL database.

Hi, I'm thankful for any help on installing RMySQL on Windows XP for R 1.9.1 The thread http://tolstoy.newcastle.edu.au/R/help/04/01/1021.html already tried to discuss the matter. It concludes that Windows Sources for Packages are alike the Linux ones. So I extracted the files from the RMySQL_*.tar.gz from http://stat.bell-labs.com/RS-DBI/download/index.html and stuffed them into a zip-file

Dear List In my short life as a beginning R-user i've encountered a following problem that i'm unable to solve myself: I have a database in MySQL containing table and field names as well as some data containing Polish accentuated characters (like ????), utf8-encoded. It works just fine with just any external query browser i can find, jdbc, odbc, native, whatever. Also mysql is happy

I'm trying to move our asterisk setup from an i686 server to an x86_64 (Dual AMD Opteron) server. Everything has been manually compiled: MySQL 4.1.10, MyODBC 3.51.11, unixODBC 2.2.10 (because I couldn't find any usable RPMs). And obviously Asterisk, where I'm using the STABLE release CVS-Nv1-0-5-02/21/05. The OS is Redhat Enterprise ES 4.0, kernel 2.6.9-5.0.3.ELsmp. Asterisk is

I'm having a problem with * (tried both HEAD and STABLE). When logging with cdr_odbc through unixODBC to MySQL, I get "insane" integer values in the duration, billsec, disposition and amaflags fields. I have enabled MySQL logging, and that's the query I get: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,dura

Hi all, OPC is a standard that specifies a collection of DCOM interfaces heavely used in the industrial automation domain. (http://www.opcfoundation.org) I would like to access these OPC objects that run in Windows from Linux computers, using the DCOM framework. Instead of implementing DCOM from scratch for Linux, I was considering 'stealing' some code off the SAMBA project relating

I have the following problem. First the native Windows XP-XP setting: I have a DCOM service on a remote XP workstation machine (The service is OPC server simulator, but this is not relevant for my problem). My (local) client application needs access to the DCOM service on the (remote) server, and following the documentation which came with the server and a lot of browsing, I managed to set it up

Hi everyone, after a classicupgrade from a samba3 domain to a samba4, I have a weird issue related to DCOM and named pipes. The switch to samba4 went fine and everything works perfectly except one old software that uses Windows named pipes and DCOM for client-server communication. When trying to access the DCOM server the software fails. The failure can be easily reproduced with a simple

Dear users, I can access an database oracle database using sql developer. This was done by importing an xml file that contains the login details - username, password and specifies that it uses the KERBEROS_AUTHENTICATION. I'm trying to connect R - so that it can access this database - do sql queries and convert the resulting tables into dataframes. I am a novice in SQL and database access

Hello, I have been using RODBC on Windows with version 1.41 of R successfully, connecting to a mysql database using MyODBC. Now I would like to do so with R under Debian/GNU Linux. I just tried RMySQL (install failed, since mysql libraries were not found), DBI (no MySQL driver available) and I can't find the RODBC package any more on CRAN. Any suggestions? Johannes Ranke P.S.: Thanks for

Hi! I am trying to display a graphic using the dcom server and the dcom graphics object. Works fine without the embedded graphics object, in it's own windows, but if i use the embedded object (what I need to do) the colors are gone. Graphics are always only black and white. Even in the DCOM examples for VB the graphics are without color - is this a bug? Can I do anything about it?

hi, i want to install a program under wine that's written in vb and uses ado which itself needs dcom. dcom cannot be installed because rundll32.exe is missing (i try to do this without installing windows). as far as i understood until now i must write the dlls to a config file, but i do not know how and which. has someone already installed ado, dcom and vb runtime and if how it is done?

Hallo Everyone, I have a problem getting R DCom to work on a MS Server 2003. I am using Visual Studio 2005 to use some statistical functions from R. I have installed DCOM 1.3.5. but as soon as the statement iR.Init("R") is executed I get the following error: Exception from HRESULT: 0x80040013 I have checked the path and the environmental variables and there are none associated with

Hi, What dcom do? Is it necessary install dcom with wine release 0.9.31-1? Thanks. -- S?vio Martins Ramos - Arquiteto Rio de Janeiro ICQ 174972645 Pirataria n?o! Seja livre: Linux http://www.debian.org

For me, current is latest 'packaged' wine, so 0.9.45 (it's not git wine if this is your question) LvR Sylvain Petreolle a ?crit : > how would you define "current", ie whats your installed Wine version ? > > Kind regards, > Sylvain Petreolle (aka Usurp) > --- --- --- --- --- --- --- --- --- --- --- --- --- > Run your favorite Windows apps with free

I am currently using a window based system to run R. I need to have a C++ program to call some functions in R. With what I have read, the DCOM R server seems to have a way to interface R with C++. However with the readme.txt file that is with download, It gives example from VB and python, but there is no interface for C++. Does anyone what's the interface in C++ to initialize R, Call