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;DatabaseYour_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]]