Hello Everyone,
I'm still quite new to R and am having trouble reading SQL Server Tables using
RODBC. I've looked though the RODBC documentation as well as material I found
online and in the book "Data Manipulation with R," but I just can't quite seem
to get things to work.
Right now, I have code that looks something like:
channel <- odbcDriverConnect
("Driver=SQL Server;
Server=Fred; Connection=xx.x.x.xxx
Database=mydatabasename;
uid=pmiller; pwd=password;
Trusted_Connection=FALSE;")
When I run this code, I get the following error:
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified
I do seem to be able to make a connection if I use:
channel <- odbcDriverConnect("driver=SQL Server; server=Fred")
Here, I haven't specified enough information but am allowed to do so
subsequently using the SQL Server Login.
Can anyone show me how to rewrite the code above to make the connection I need
without using the SQL Server Login?
Thanks,
Paul
__________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr!
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
