Thanks to those who responded to my post about reading SQL server tables using
RODBC. Someone in our IT department sent me a link that contained the following
information:
SQL ODBC connection strings
Standard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=
Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"
Trusted connection:< br>
"Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;
Trusted_Connection=yes;"
This turned out to have all the infomation I needed.
My code wound up looking like:
channel <- odbcDriverConnect(
"Driver=SQL Server;
Server=FRED; Database=StudyXYZ;
Uid=my_id; Pwd=my_password;")
I used sqlTables(channel) to see what tables were available and a whole bunch
of things popped up. So it seems to be working correctly now.
Thanks,
Paul
__________________________________________________________________
[[elided Yahoo spam]]
avourite sites. Download it now
[[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.
