similar to: FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux

I am sure I'm doing something wrong here but not sure what. Our system administrator recently installed UnixODBC and the MyODBC driver on a Linux box running Linux version 2.6 x86_64. I have an .odbc.ini file in my home directory with following lines: [mydb] Description = MySQL server on my-server Driver=/usr/lib64/libmyodbc3.so SERVER=my-server I can successfully do the following:

R-sig-Debian help, I have installed an ODBC Driver for Linux. I want to connect to our database through R via: >library(RODBC) >con <- odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") Warning message: In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") : ODBC connection failed I don't really know whether this

hi i am using technoweenie-restful-authentication plug-in for authentication in my application. i want to send a activation link to the user''s mail-id. for that i need to set the smpt server for our rails application, for that i added the follwing code in config/environment.rb file ActionMailer::Base.delivery_method:smpt ActionMailer::Base.smpt_settings = { :address =>

Hi, I'm trying to use RODBC without having to set up a DSN, using hte direct connection string in odbcDriverConnect. My connection attempt looks something like: > odbcDriverConnect(connection = "SERVER=localhost;DRIVER={/usr/lib/odbc/libmyodbc.so};DATABASE=myDB;UID=reader;PASSWORD=insecure;") And this returns the message: Warning messages: 1: In odbcDriverConnect(connection =

Hi everybody, I'm having a problem with connecting to my MySQL database. Each time I try to connect library(RMySQL) m <- dbDriver("MySQL") con <- dbConnect (m, host="my_host",username="my_username", password="my_password", dbname="name_of_db") it says Fehler in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect

Hi, i am now in the process of building a newsletter system which will send out emails to users that have enlisted to a certain group; everything''s going fine, and i an towards the end of this project...now the real part of the story kicks in, where i need to check to see if the thing is working or not. i have been looking over the development.log file, and i see that the emails

I have a matrix of, say, M and N dimensions: my_matrix=matrix(c(1:60),nrow=6,ncol=10) I have two "id" vectors corresponding to the rows and columns, e.g.: id_m=seq(10,60,by=10) id_n=seq(100,1000,by=100) I would like to create a "proper" database (let's say a data.frame for this example -- i'm going to be loading these into an SQLite database, but we'll leave

I am having trouble updating packages for R 2.8.1 in Windows XP. Note that I *am* able to update packages for R 2.7.0 (see bottom of posting) so this is not an Internet proxy problem. The steps I took were to (a) Copy over packages from my existing (2.7.0) library subdiretory to the R 2.8.1 library subdirectory. This included a long list of packages including RODBC, rpart, RGraphViz, ggplot2

Hello, I want to try to connect R to PostgreSQL. I have found that there are three ways: DBI or RODBC or RPostgreSQL. I tried around with DBI and RODBC but didn't get it running. In both cases I'm not clear about how to set the driver/data source. I get this error: x > channel <- odbcConnect("rtest", uid="oliver") x Warning messages: x 1: In

I am using pyramid.plot() from the plotrix package. I have something like this ############################################ xy.pop<-dados$masfr xx.pop<-dados$femfr #agelabels<-dados$femlab xycol<-color.gradient(c(0,0,0.5,1),c(0,0,0.5,1),c(1,1,0.5,1),11) xxcol<-color.gradient(c(1,1,0.5,1),c(0.5,0.5,0.5,1),c(0.5,0.5,0.5,1),11) xylab<-dados$maslab xxlab<-dados$femlab

http://bugzilla.mindrot.org/show_bug.cgi?id=872 Summary: SSH client fails for non-root users with "Host key verification failed" Product: Portable OpenSSH Version: 3.8.1p1 Platform: ix86 OS/Version: Linux Status: NEW Severity: major Priority: P2 Component: ssh

[I posted this problem a couple of weeks ago and got no responses. So I'm trying again] I have a couple of applications on a WinXP/SP2 system that use data files on a Samba (v2.2.12, on Linux) shared drive. Immediately after booting the WinXP system these data files cannot be seen, yet become visible when the share is browsed with Windows Explorer. These applications are started

Hello Im using Asterisk as a SIP client of Kamailio with RTPproxy. Asterisk is behind NAT. X-Lite and SNOM phones behind NAT work fine. But when I try to connect with an Asterisk behind NAT, the Asterisk client doesn't receive sound. I already tried in 2 different NATs, with no firewalls. This is my Asterisk config: [kamailio] type=peer host=xxx.xxx.xxx.xxx disallow=all allow=ulaw

I only want to load a limited number of rows by dbReadTable(). I don't see an option in the help. Is there an option to do so?

I have a data.frame obj with 5 columns whose colnames match the fields in my "contact" table. The only other field my MySQL table has is an id field which is the PK and is set to auto increment. I'd like to load this data.frame using something like: dbWriteTable(con, "contact", dat, append=TRUE) However, I get this error: Error in mysqlExecStatement(conn, statement,

Please cc me on replies. My employer recently upgraded to W2K3. I have no control over the employer's set up and limited access to information. Under the old server, everything was working fine. Now I can't mount the shared drive anymore. I'm running Debian sid; samba 3.0.6-3. ################################################ # mount shared_drive cli_negprot: SMB signing is

followed the instruction for installing dashboard, and created user mysql -pmy_password -e "CREATE DATABASE dashboard CHARACTER SET utf8;CREATE USER ''dashboard''@''localhost'' IDENTIFIED BY ''my_password''; GRANT ALL PRIVILEGES ON dashboard.* TO ''dashboard''@''localhost'';" however, I keep getting

Hi I have a question, as im not able to import a csv file which contains a big dataset(100.000 records) someone knows how many records R can handle without giving problems? What im facing when i try to import the file is that R generates more than 100.000 records and is very slow... thanks a lot!!!

Hi list I'm trying to setup dovecot 2.2.36 on a Centos6 to communicate with a wforce daemon on the remote side. wforce is latest released from git repo. Daemon part is working and I can successfully send queries from remote systems to wforce via curl For dovecot I configured in /etc/dovecot/conf.d/95-wforce.conf > auth_policy_server_url = http://REMOTE_IP:8084/ >

Hi there! I am PHP developer and trying to learn ROR. Currently I am building my first Rails website (OS X Snow Leopard, TextMate) and decided to switch from sqlite to mysql. After many-many hours of searching the internet I managed to install mysql gem. Now I get this error when I try to run rake migrations: rake aborted! Mysql::Error: query: not connected: CREATE TABLE `schema_migrations`