[R] Read in data from Microsoft SQL
Jan_Svatos@eurotel.cz
Jan_Svatos at eurotel.cz
Tue Nov 2 08:35:08 CET 2004
Hi,
the DSN should be exactly the same as "name" of the (probably system) DSN
stated in Windows ODBC settings.
Just keep in mind, that DSN in general often holds information about the
Default Database, and that switching database os stating database as
prefix may be necessary.
Jan
- - - Original message: - - -
From: r-help-bounces at stat.math.ethz.ch
Send: 1.11.2004 19:10:47
To: <R-help at stat.math.ethz.ch>
Subject: [R] Read in data from Microsoft SQL
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-client or other applicable privileges, or constitute non-public
information. It is intended to be read only by the individual or entity
to whom it is addressed or by their designee. If you are not an intended
recipient of this message, please notify the sender by replying to this
message and then delete it from your system. You are on notice that
further use, dissemination, distribution, or reproduction of this
message is strictly prohibited and may be unlawful.
[[alternative HTML version deleted]]
______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html
More information about the R-help
mailing list