title: Linked server "Data source name not found and no default driver specified" error
body: <p>I made a linked server with Microsoft OLE DB Provider for ODBC Drivers:</p>
  
  <pre><code>EXEC master.dbo.sp_addlinkedserver @server = N'TEST', 
                                  @srvproduct=N'Microsoft Visual FoxPro Driver', 
                                  @provider=N'MSDASQL', 
                                  @datasrc=N'TEST'
  </code></pre>
  
  <p><br>
  It worked fine still I used WIndows Authentication Mode, but when I created a login user and switch to SQL AUthentication it did not work.
  <br>
  What changes are needed to work with SQL Authentication?
  <br>
  In providers I have enabled:"Nested queries","Allow inpocess", Level zero only".
  <br>
  The error is:
  <br>
  <br></p>
  
  <blockquote>
    <p>OLE DB provider "MSDASQL" for linked server "TEST" returned message
    "[Microsoft][ODBC Driver Manager] Invalid connection string
    attribute". OLE DB provider "MSDASQL" for linked server "TEST"
    returned message "[Microsoft][ODBC Driver Manager] Data source name
    not found and no default driver specified". Msg 7303, Level 16, State
    1, Line 1 Cannot initialize the data source object of OLE DB provider
    "MSDASQL" for linked server "TEST".</p>
  </blockquote>