similar to: RODBC Oracle and VB automation with R(D)COM

Hi all, I'm having trouble connecting to an oracle database using RODBC under winXP. Unfortunately I can't really send a reproducable error as the initial call to odbcConnect seems to hangs R and I have to kill the session. I have been using RODBC to sucessfully connect to an MS Access DB that has tables linked through to the oracle database in question and that seems to work OK but it

Given a directory tree like ... /foo | +-- A | +-- B | +-- C ... what is the best way to index A and C into a single Xapian database? AFAIK the alternatives are: omindex --db /my_db --no-delete /foo /foo/A omindex --db /my_db --no-delete /foo /foo/B or omindex --db /my_A_db /foo /foo/A omindex --db /my_B_db /foo /foo/B xapian-compact /my_A_db /my_B_db /my_db The first alternative does not

Hi all I''d like to create fixtures using Fixtures.create_fixtures But it seems that this one needs .yml files that have the same name like the table they correspond to: countries.yml => my_db.countries readers.yml => my_db.readers Is it possible to use any desired filenames somehow? some_cool_countries.yml => my_db.countries some_other_cool_countries.yml =>

I have installed the CVS Head as of 12/12/04, as well as the asterisk-addons to ensure that /usr/lib/asterisk/modules/res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass =

I have installed the CVS Head as of 12/12/04, as well as the asterisk-addons to ensure that /usr/lib/asterisk/modules/res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass =

Atlantis Land A03-P551(V1.2) battery.charge: 100 battery.voltage: 13.70 battery.voltage.high: 13.00 battery.voltage.low: 10.40 battery.voltage.nominal: 12.0 device.mfr: device.model: device.type: ups driver.name: blazer_usb driver.parameter.langid_fix: 0x0409 driver.parameter.pollinterval: 2 driver.parameter.port: x driver.version: 2.6.4 driver.version.internal: 0.08 input.current.nominal: 0.0

Hi, all: Two questions. Environment: Ubuntu 12.04 1) mount: unknown filesystem type 'smbfs' With default Samba 2:3.6.3-2ubuntu2.3 installed, all the following 3 commands failed: a) $ sudo mount -t *smbfs* -o username=MYNAME,password=MYPWD //mybooklive/myfolder /media/smb/ mount: unknown filesystem type 'smbfs' b) /media$ sudo mount -t *cifs* -o username=MYNAME,password=MYPWD

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connection so that I can implement it in my sql query below. I'm currently getting the following error:

hi, i am using the RODBC package to read .xls files. now after i installed the package and loaded the library and tried to read a file this is the error i got. >channel<-odbcConnect("D:/rstuff/1.xls") Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: ODBC connection failed

Hi, I'm setting up SQL quota usage in Dovecot2. I've created a MAILBOX parameter table, 'PARAMS', that contains unique <user>@<domain> pairs, with quota data. mysql> select * from PARAMS; +----+------------------------+------------+-------------+------------+ | ai | MAILBOX_user_domain | quota | quota_bytes | quota_msgs |

I get the following errors when attempting an ODBC connection to a MySQL db. 1: [RODBC] ERROR: state HY000, Code 0, message [MySQL] [ODBC 3.51 Driver] Could not determine the driver name so could not lookup setup library. 2: ODBCConnection failed in: odbcDriverConnect(st, case=case, believeNRows=believeNRows). Win XP sp2 MySQL 4.1.8 My SQLODBC 3.51.10 Package RODBC (latest) is installed.

I have a backup server (Linux Debian 3.1) that connects to several Windows 2000 and 2003 servers shares with smbmount 3.0.14a. This is how I mount the shares: smbmount "\\\\win2000\\inetpubd" /mnt/win2000/ -o username=backups,password=mypwd If I list items with accents, this is a sample of how they appear on the mounted share: drwxr-xr-x 1 root root 4096 2005-12-01 16:45 D?but de

I am trying to connect sybase sql databast from R using RODBC pkg and getting the following error ( i chnaged names to my*** but when I actually execute it, I put down names explicitly not calling some character strings) > channel = odbcConnect(dsn='mydsn',uid='myid',pwd='mypasswd') Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver

If I run a normal ldapsearch it gives me the gidnumber and uidnumber attributes. It looks like the AD is set up properly. ---------- Forwarded message ---------- From: Urs Golla <urs.golla@gmail.com> Date: Oct 4, 2007 9:47 AM Subject: could not read attribute 'gidNumber' To: samba@lists.samba.org Hi I am using samba 3.0.23c on RHEL5 with security = ads. If I use "idmap

I have a home network based on Win XP Pro, with one Linux machine running Red Hat 9. All updates have been applied. There's no domain controller. I can connect from the Linux machine to the XP machines via Konqueror using smb://mymachine/myshare However, I can't use the mount command. I'm trying to use syntax like mount -t smbfs -o username=myname,password=mypwd //192.168.0.1

Hello Users: I'm using R version 2.0.1, and having problems with RODBC. Everything works fine when I use Rgui, but when I try to use Rterm and issue the commands library(RODBC) con <- odbcConnect("MySQL", "test") I get the following error: Error in sqlQuery(con, str) : first argument is not an open RODBC channel In addition: Warning messages:

Hello, I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to connect to a PostgreSQL server on the local network. I can't tell whether my problem is in R, or in ODBC setup. I got drivers from OpenLink, created a dsn and tested it using the iODBC application. then I load the RODBC package, use this code and get the following error. I tried with both the

I am trying to connect to a remote sql server and I am getting the following error: c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `connect'': Open (DBI::Databa seError) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. HRESULT error code:0x80020009 Exception

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package When issuing a SqlQuery, I get the following error > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,

All, I'm having a problem connecting to an MS SQL Database via RODBC on OS X. If I try to connect through the GUI using chan <- odbcConnect("drewdb", uid="user", pwd ="pwd") it simply crashes R with the following crash report: Date/Time: 2005-03-28 12:30:48 -0600 OS Version: 10.3.8 (Build 7U16) Report Version: 2 Command: R Path: