TKE402 did you get a linked server to work yet? I've played with SQLite a little bit now; I've used this .NET provider for SQLite[/url] in VS 2005/2008 with no problem, other than the command not allowing complex CHECK constraints.

my Google-Fu is strong, but I have not found a single working example of a linked server to SQLite;

I've also used this OLEDB provider, which i can use with vb6,.net, and the import/export wizard in SSMS to get data.

logically, if i can use the oledb SQLite Provider witht he import/export wizard, i should be able to create a linked server with it as well, but I'm still getting an error:

AFAIK, Msg 7302 is raised when there is a configuration issue with the linked server..bad provider string or whatever.

This is what I've tried so far, but no luck; have you gotten it to work?

--#################################################################################################

--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'