title: connect to SQL server on Parallel VM from R
body: <p>I have my Rstudio installed on Mac, and SQL server Management studio in Parallel VM. now, I am trying to connect R with SQL server using RODBC package. I think I have the sql server driver installed on my computer. i am not familiar with database. below are what I did:</p>
  
  <ol>
  <li><p>set up User DSN 'orca4' in Parallel VM (Windows 7), driver name 'SQl Server Native Client 11.0' (it was tested successfully).</p></li>
  <li><p>run R odbcConnect('orca4'), it gave me message '[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded'</p></li>
  <li>then I tried cn &lt;- odbcDriverConnect(connection="Driver={SQL Server 
  Native Client 11.0};server='1244gfgfgr';database='NewHome';
  trusted_connection=yes;"). i got similar message
  ERROR: state IM003, code -1988948897, message [iODBC][Driver Manager]Specified driver could not be loaded </li>
  </ol>
  
  <p>Could anyone let me know what is the problem here?</p>