How to use dotConnect for SQLite for SQL Server Linked Server
Posted: Mon 17 Jun 2013 01:00
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.
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.