How to use dotConnect for SQLite for SQL Server Linked Server

[tohagan]

GOAL: I'm trying to import tables from a SQLite database into a SQL Server Express database. I'd like to be able to create a temporary linked server in SQL Server

My guess was ...

exec sp_addlinkedserver @server= 'T1', @srvproduct='Devart dotConnect for SQLite', @provider='Devart.Data.SQLite', @datasrc= 'E:\MySQLiteDB.db'
...
But this fails when used reporting that the provider is not registered.

[Pinturiccio]

Linked server can be created only for OLE DB providers. Since dotConnect for SQLite is a ADO.NET provider, it cannot be used as a linked server provider.