title: Trying to establish a linked share connection with SQLite from SQL Server
body: <p>I am trying to create a linked share connection from SQL Server to SQLite. I have followed all the steps by Graham Okely in the below link. It was really nice and I have been able to create the linked share connection from SQL.</p>
  
  <p><a href="http://www.mssqltips.com/sqlservertip/3087/creating-a-sql-server-linked-server-to-sqlite-to-import-data/" rel="nofollow">Creating a Linked Server from SQL Server to SQLite to Import the Data</a></p>
  
  <p>I have used the sqliteodbc_msvcr100 to install the ODBC driver in my machine. My machine is 32 bit and I have installed the 32 bit ODBC driver.</p>
  
  <p>I am not able to download and extract the other drivers listed in the </p>
  
  <p><a href="http://www.ch-werner.de/sqliteodbc/" rel="nofollow">http://www.ch-werner.de/sqliteodbc/</a></p>
  
  <p>Created the Linked Share Connection by using the below query</p>
  
  <pre><code>USE [master]
  GO
  EXEC sp_addlinkedserver 
     @server = 'SQLite', -- the name you give the server in SSMS 
     @srvproduct = '', -- Can be blank but not NULL
     @provider = 'MSDASQL', 
     @datasrc = 'SQLite' -- the name of the system dsn connection you created
  GO
  </code></pre>
  
  <p>But when I tried to access the tables in SQLite using the Openquery</p>
  
  <pre><code>Select * from openquery(SQLite, 'select * from Test1')
  </code></pre>
  
  <p>Here the SQLite is my System DSN and Test1 is a table in the SQLite database. But this throws the following error.</p>
  
  <blockquote>
    <p>[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
    OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:   ].
    Msg 7399, Level 16, State 1, Line 1
    OLE DB provider 'MSDASQL' reported an error.  </p>
  </blockquote>
  
  <p>Can this be resolved? Please help.</p>