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

I think I figured this out. I should not have put the Driver name in braces. Changing it from {MySQL} to MySQL seems to work. -----Original Message----- From: Marcus, Jeffrey Sent: Tuesday, January 12, 2010 6:09 PM To: 'r-help at r-project.org' Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux I am sure I'm doing something wrong here but not

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

Hello, I'm using dovecot & postfix to bring smtp auth to our customers. Normal mail clients have no problem at all and I'm so satisfied. However, we're having problems with Microsoft Exchange server clients. We're using our postfix-dovecot server as smarhost for several Exchange Servers, and we wish to use TLS + basic authentication for these outgoing mails. But it seems that

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'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 =

Greetings, I'm having some trouble with the realtime engines. When asterisk loads, everything looks fine, there don't seem to be any problems via notices or anything. Furthermore, cdr_odbc is working, and actively logging my failed call attempts to db through ODBC using the same DSN. unixODBC and the mysql drivers are installed from source. Here are the relevant parts of the config:

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 =>

Hello, first i want to say that i never used a mailing list before, so if i made something wrong do not hesitate to contact me via e-mail. I try to set up multiple Dovecot instances running at the same time. Goal is to provide IMAPS with a valid SSL Certificate on selected IP Addresses. To reach this i want to set it up as follows: 1 Dovecot Daemon listening on localhost (for webmail),

Having problems getting realtime working, I'm trying to use odbc for all of this. I've got Fedora 3 and have been fighting with odbc for a day now. I think I got it working correctly, however I can't seem to get the realtime portion working. In asterisk 'odbc show' shows it connected, I see it on my (odbc) mysql server connected and all, it connects and just idles. So, without

Don't be afraid about the info that I'm going to post in this mail, but I want you to give as much info as possible. Also I want to show you what I've tried. What do I want When a voicemail-message is left via the Voicemail()-application, I want the .wav-file send to my mail-address as an attachment. My mail-setup I'm not using sendmail as MTA. I have msmtp as MTA and mutt as

I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to

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

R-help, I get the following error message when trying to connect to an Oracle database through R (2.8.1) under Linux (Ubuntu 9.04). > channel<-odbcConnect("magnus",uid="luisr",pwd="juanayzakarias") Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: state IM002, code 0, message [unixODBC][DriverManager]Data source name not found, and no

Hi I'm presently trying to connect to Oracle through RODBC / UnixODBC on linux (Red Hat 5). I've successfully connected through the easysoft drivers but the trial license has run out and I'm trying to connect via the default Oracle 11G driver. However I'm getting the following error > library(RODBC) > setwd (paste("/home/oracle/scripts/R")) > channel

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

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

Hi, This is sasi. I installed R 64 bit and oracle client 64 bit in fedora 17. After R is working fine. Oracle database also working fine. but problem is, If i try to connect oracle from R its not connecting. So, pls guide me how to connect from R to oracle. how, i tried:-- odbcinst.ini file code is [ORACLE2] Description = oracle driver Driver =

I notice you have MySQL-asterisk as your definition in your odbc.ini but you are trying to connect to simply 'MySQL' with your 'isql' command. Does isql work with 'MySQL-asterisk' as the DSN instead of simply 'MySQL' ? I have machines that use /etc/odbc.ini and machines that use /usr/local/etc/odbc.ini depending on if I used a package to instal ODBC or if I

hi, i know that the first thing i'll hear is rtfm. but i allready read it 4 times and spend some nights over this problem. i got a debian woody (stable) linux box with samba 2.2.3a-12.3 and winbind for the samba version. the nt-domain is PORTA#001-NT. my first question is: is the # in the name a problem? my second question: do i have to create a computer account on the pdc of the domain

Hello, I'm stuck with getting cdr records stored in MySql database. I have a working realtime environment and have verified that the db connection works fine when used via res_config_mysql.conf. I'd appreciate Your help on how to get the odbc connector working as I think there's something wrong with its configuration. The problem presented itself as an error when making a call that