search for: dsn

Hi, I have a data base in oracle and need to link R using ODBC. When i use the command odbcConnect a dsn is needed. I would like to create a dsn.Do you know how can i do it? Thank you. Margarida,Portugal

...t;, size=1613090, nrcpt=31 (queue active) May 13 17:58:33 mail1 postfix/smtpd[28164]: disconnect from unknown[192.168.0.103] May 13 17:58:33 mail1 postfix/pipe[28169]: 1D6508FD93FF: to=<xy at city.company.net>, orig_to=<xy at company.net>, relay=dovecot, delay=1.9, delays=1.5/0/0/0.35, dsn=2.0.0, status=sent (delivered via dovecot service) May 13 17:58:33 mail1 postfix/pipe[28299]: 1D6508FD93FF: to=<xy at city.company.net>, orig_to=<xy at company.net>, relay=dovecot, delay=1.9, delays=1.5/0.02/0/0.34, dsn=2.0.0, status=sent (delivered via dovecot service) May 13 17:58:33...

Hi, to get a 'Delivered-to' header based on ORCPT, I wrote a patch (attached) to force Dovecot lmtp to advertise DSN after a LHLO command. In this way, Postfix add an ORCPT to the RCTP command (http://postfix.1071664.n5.nabble.com/pipe-flags-vs-lmtp-td11587.html#a11596). Be carefully: in this way DSN notification is broken, but they were broken in any case at the time I wrote the patch (read the entire post link...

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

Under WinXP, I have a system DSN called foo. It has stored username/password information. (I can click Configure in ODBC Administrator and then Test Data Source connects to MySQL without me re-entering data.) Using RODBC, I can connect to the same database. But when I do odbcConnect("foo"), I get a window that requi...

Hi, Is there a faster way to do this? It takes forever, even on a moderately sized dataset. n <- dim(dsn)[1] dsn2 <- dsn[order(-dsn$xhat),] dsn2[1, "cumx"] <- dsn2[1, "xhat"] for (i in 2:n) { dsn2[i, "cumx"] <- dsn2[i - 1, "cumx"] + dsn2[i, "xhat"] } [[alternative HTML version deleted]]

An ODBC DSN has been setup successfully on wine. "wine isql DSN" has verified the connection. Now a linux application wishes to connect this DSN. Is it possible? Proxies like ODBCSocketServer or DBTCP would be the last choice because there shouldn't be any need for yet another layer. Put it...

Happy New Year to all in the list! I am trying to issue an SQL query to a database from R using RODBC (on Windows). The data source file is on my PC hard disk : C:\Program Files\ODBC\sql.dsn The "\" character does not get interpreted properly in R - it is removed from the file-spec string or if I specify "\\" it appears as such with a syntax error in odbcConnect(dsn, uid="", pwd="", host="localhost", case="nochange") Can an...

Hi I am trying to use RODBC in R installed on Windows to access MySQL database (on a linux box). I set up a DSN and specified this DSN in R as follows library(RODBC); channel <- odbcConnect("mysqldsn"); RODB Connection 5 Details: case=nochange PORT=3306 ........ Although this seems to connect properly, running any command yields NO results. i.e. sqlQuery(channel, "show tables") yie...

Hi I have in an existing windows installation a large number of 'system DSN data sources' which I would like to have under wine. Is it possible to import these? I know about the file DSN and that they are files in a directory, but that doesnt help. Rainer

...l2TMYqwj004379 at myserver .vwh.net>, proto=ESMTP, daemon=MTA-v4, relay=localhost [127.0.0.1] Mar 29 22:34:52 myserver sendmail[4379]: l2TMYqwj004379: to=testuser3 at myserver.vwh.net, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pr i=30054, relay=localhost.. [127.0.0.1], dsn=2.0.0, stat=Sent (l2TMYqMi004380 Message accepted for delivery) Mar 29 22:34:52 myserver sm-mta[4381]: l2TMYqMi004380: to=<testuser3 at myserver.vwh.net>, ctladdr=<root at myserver.vwh.net> (0/0), delay=00:00:00, xdelay=00:00:0 0, mailer=local, pri=30560, relay=local, dsn=5.0.0, stat...

...RODBC in both cases from the same depository gotten by install.packages(‘RODBC’), Oracle ODBC client software installed in 64 and 32 bit respectively) 1. The code looks like library(RODBC) credentials <- read.csv("~/credentials.csv", head=T, row.names=1) db <- odbcConnect(dsn="DSN", uid=credentials["DSN", "username"], pwd=credentials["DSN", "password"], rows_at_time=1024) on which the odbcConnect call fails with the following error code Error in nchar(uid) : 'nchar()' requires a character vector ( credential...

...lp [tablename] | | quit | | | +---------------------------------------+ SQL> So here are the config file for asterisk. /etc/asterisk/res_odbc.conf ----------------------------- [mysql] enabled => yes dsn => MySQL-asterisk username => asterisk password => qpalym pre-connect => yes and /etc/asterisk/cdr_odbc.conf ---------------------------- [global] dsn=MySQL-asterisk loguniqueid=yes dispositionstring=yes table=cdr But after a call hangup I get the following error: cdr_odbc.c: Unable...

Hi, I am trying to read data from Microsoft SQL. I tried to use odbcConnect (in RODBC) but failed. What should the "dsn" be? Does anyone know how to do it? I will appreciate it. Thank you! Xiaorong ________________________________________________________________________ The preceding e-mail message (including any attachments) contains information that may be confidential, be protected by the attorney-clien...

...Dec 13 08:42:38 mailserver pop3-login: Login: robin [::ffff:192.168.1.103] Dec 13 08:42:53 mailserver pop3-login: Disconnected [::ffff:192.168.1.246] Dec 13 08:43:04 mailserver sendmail[16422]: jBD6fU3g016421: to=<Luis@dubaisa.co.za>, delay=00:01:32, xdelay=00:00:30, mailer=local, pri=68583, dsn=2.0.0, stat=Sent Dec 13 08:43:05 mailserver pop3-login: Disconnected [::ffff:192.168.1.217] Dec 13 08:43:08 mailserver pop3-login: Disconnected [::ffff:192.168.1.81] Dec 13 08:43:16 mailserver sendmail[16463]: jBD6hFwK016463: from=<russells@dubaisa.co.za>, size=2112751, class=0, nrcpts=1, msg...

Dear All, I want to connnect R with oracle. I am using RODBC package for this connection. Following is my code to connect library(RODBC) channel <- odbcConnect("Vikrant") I am getting following error. 1: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 2: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state 01000, code 0, message [...

...rying to get to grips with accessing my postgresql tables in R using RODBC. I have Mac OS 10.2.8 (Darwin 6.8) installed and R 1.8.0 installed from source and I have updated RODBC to 1.0-4. On the ODBC manager end, I am using OpenLink software's iODBC Administrator and I've set up a User DSN called "PostGRES" - odbctest suggests that this is functioning: > [doibook:~] dorme% /usr/bin/odbctest > iODBC Demonstration program > This program shows an interactive SQL processor > > Enter ODBC connect string (? shows list): dsn=PostGRES > > Have a nice day. &g...

...ccess database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me? I have a MS Access database in my computer and I went to the control panel in order to create a DSN file linked to that database. When I'm in R I tried to coneect to it using the command odbcConnect("testdb") but it doesn't work. I received these messages: Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not fou...

...=1, msgid=<Asterisk-1-227856683-222-3479 at PROSIMA>, proto=ESMTP, daemon=MTA, relay=MYSERVER [127.0.0.1] * n7OCivth003603: to="Test User 1" <testuser at mydomain.com>, ctladdr=root (0/0), delay=00:00:06, xdelay=00:00:05, mailer=relay, pri=35340, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (n7OCiw9W003604 Message accepted for delivery) * n7OCiw9W003604: to=<testuser at mydomain.com>, ctladdr=< root at localhost.localdomain> (0/0), delay=00:00:01, xdelay=00:00:01, mailer=esmtp, pri=125473, relay=mx1.datagrama.net. [212.9.65.111], dsn=5.1.8, stat=User unkno...

Hello I'm trying to get the proportion "true" for dichotomous variable for various subgroups in a survey. This works fine, but obviously doesn't give proportions directly: svytable(~SurvYear+problem.vandal, seh.dsn, round=TRUE) problem.vandal SurvYear FALSE TRUE 1995 8906 786 1997 17164 2494 1998 17890 1921 1999 18322 1669 2001 17623 2122 ... Note some years are missing - they are part of the dataset, but all responses are NA (the question wasn't asked). However, this...