RE: [R] dsn

2004-03-18 Thread David Middleton 

Margarida

 odbcConnect(H:\\Desktop\\bd1,uid=tiago,pwd=archi,case=nochange,believeNRows=TRUE)
 [1] -1
 Warning messages:
 1: [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver 
 Manager]Data source name not found, and no default driver specified

You simply need to give the data source name (DSN), not a path, as the first argument 
to odbcConnect.  If you want to connect directly to a database file, rather than via a 
DSN, the RODBC package also provides odbcConnectAccess etc.

I am slightly surprised that you appear to be using unixODBC on what appears to be 
(from the path specification) a windows system.  I guess this may be possible via 
cygwin - maybe there's even a win32 release of unixODBC.  RODBC works fine with the 
standard MS ODBC setup on windows systems as far as I can tell.

David

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

Re: [R] dsn

2004-03-18 Thread Prof Brian Ripley 
You appear to be using unixODBC and DOS paths!

You haven't told us what OS, what version of R, what version of RODBC, 
what driver manager, what driver   But it does seem unlikely that
unixODBC understands DOS paths.

The issue is very simple: the driver manager is not finding the path you 
specified.  We can only guess at why.


On Wed, 1 Jan 1997, Margarida =?iso-8859-1?Q?Júlia?= Rodrigues Igreja wrote:

Wow, your computer is living in the past!

 I've finally got a DSN working on my ODBC installation and I've tested it 
 with the ODBC DataManager so I'm sure it's working.
 However when trying to connect to the DSN via R interface I get an error:
 
   
 odbcConnect(H:\\Desktop\\bd1,uid=tiago,pwd=archi,case=nochange,believeNRows=TRUE)
 [1] -1
 Warning messages:
 1: [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver 
 Manager]Data source name not found, and no default driver specified
 2: ODBC connection failed in: odbcDriverConnect(paste(DSN=, dsn, ;UID=, 
 uid, ;PWD=, pwd,
 
 Before the odbcCOnnect() command I gave the library(RODBC) command and it 
 gave no error
 What am I missing?
 
 Margarida
 
 __
 [EMAIL PROTECTED] mailing list
 https://www.stat.math.ethz.ch/mailman/listinfo/r-help
 PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
 
 

-- 
Brian D. Ripley,  [EMAIL PROTECTED]
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel:  +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UKFax:  +44 1865 272595

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

[R] dsn

2004-03-08 Thread Margarida Júlia Rodrigues Igreja 
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

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

RE: [R] dsn

2004-03-08 Thread Wayne Jones 
Hi 

If you are using windows then do this: 

Basically you need to add your oracle database as an ODBC data source. 

Control Panel - Administrative tools  - Data Sources (ODBC)

Select the System DSN tab and then Add. Select which type of Data source
i.e. Oracle database. Then follow the instructions.

Regards

Wayne



-Original Message-
From: Margarida Júlia Rodrigues Igreja [mailto:[EMAIL PROTECTED]
Sent: 01 March 1997 20:48
To: [EMAIL PROTECTED]
Subject: [R] 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

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html


KSS Ltd
Seventh Floor  St James's Buildings  79 Oxford Street  Manchester  M1 6SS  England
Company Registration Number 2800886
Tel: +44 (0) 161 228 0040   Fax: +44 (0) 161 236 6305
mailto:[EMAIL PROTECTED]http://www.kssg.com


The information in this Internet email is confidential and m...{{dropped}}

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html