This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 99%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Hi, i try to create linked servers in sql server 2014 to get the data from sqlite, but it showing this error messages.
Msg 7399, Level 16, State 1, Line 10
The OLE DB provider "MSDASQL" for linked server "SYNCUSERSINFO" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 10
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SYNCFROMSQLITE".
Below is my ODBD configuration
Below is my sql server linked server configuration
And how does the DSN for SQLite look like? Does it work on its own outside SQL Server?
Where is the database file for SQLite located? On the same machine as SQL Server, or on a network drive?
Rather than using the UI, run a query against the linked server from a query window. You will get the same error message, but there may be additional informational messages that gives more details about what is going wrong.
Hi Erland,
the database file for sqlite is located in documents folder and it's same machine as sql server.
i have used an alternative way to created the linked server from query window, it's success. but failed to retrieve data.
Unfortunately the were no additional error messages. This means that we are in the dark of what is going wrong. But an obvious guess is permissions. That is, the service account for SQL Server needs to have permission to your Documents folder and on the file itself.
I would put the database somewhere outside C:\Users, but that's me.
Thanks a lot Erland! I have locate my sqlite database to another path, it's working now with select statement!
Great to hear that it worked out!