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

