我搜索得很远,但没有找到解决这个问题的办法.我发现的最接近的尝试是：

http://www.sqlservercentral.com/Forums/Topic866972-149-1.aspx

--#################################################################################################
--Linked server Syntax for sqlite 
--using OLE provider C:\Program Files\Cherry City Software\sqliteProvider\sqlitePV.dll
--from http://cherrycitysoftware.com/ccs/Download/Download.aspx
--#################################################################################################
DECLARE @server     sysname,@srvproduct nvarchar(256),@provider   nvarchar(256),@datasrc    nvarchar(100),@location   nvarchar(100),@provstr    nvarchar(100),@catalog    sysname,@sql        varchar(1000)
--add an sqlite Database as a linked server
SET @server = N'MysqLite'
SET @srvproduct = N'sqlite Provider'
SET @provider = N'Olesqlite.sqliteSource.1'
SET @datasrc = N'C:\Data\LowellSSC.db3'
set @provstr    = ''
EXEC sp_addlinkedserver  @server,@srvproduct,@provider,@datasrc,NULL,@provstr
exec sp_addlinkedsrvlogin @rmtsrvname='MysqLite',@useself = N'false',@locallogin = NULL,@rmtuser = N'Admin',@rmtpassword = NULL

--list all the tables and their names
EXEC sp_tables_ex 'MysqLite'
--above fails with this error:
--Msg 7302,Level 16,State 1,Procedure sp_tables_ex,Line 41
--Cannot create an instance of OLE DB provider "Olesqlite.sqliteSource.1" for linked server "MysqLite".
GO
EXEC dbo.sp_DropServer 'MysqLite','DropLogins'