title: R: [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found
body: <pre><code>setwd("/mnt/mountpoint/abc/")
  sqlServerConnString &lt;- "SERVER=server;DATABASE=sqldwdb;UID=xyz;PWD=abc;"
  sqlServerDataDS &lt;- RxSqlServerData(sqlQuery = "SELECT * FROM xyz",
                                 connectionString = sqlServerConnString)
  sqlServerDataDF &lt;- rxImport(sqlServerDataDS)
  </code></pre>
  
  <p>This is my code. I am getting the followin error in R</p>
  
  <blockquote>
    <p>[unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found</p>
    
    <p>[unixODBC][Driver Manager]Connnection does not exist ODBC Error in
    SQLDisconnect Could not open data source.Error in
    doTryCatch(return(expr), name, parentenv, handler) : Could not open
    data source.</p>
  </blockquote>
  
  <p>I have installed MSSQL and unixODBC driver on my linux machine and it is getting refelected in /etc/odbc.ini file too</p>
  
  <p>Can someone please help me in this?</p>