![]() To query the linked server, click New Query in the toolbar:Įnter your SQL query in the editor window and click Execute to run the query:Īs a result, you can see the contents of the selected table retrieved directly from the SQLite account you are connected to.3e49bb744bef83cb50a01f88c6e739365507b11d0820cb9de9ec62a6413bc342 The SQLite tables are already available to be fetched. In the Product Name and Data Source fields you need to indicate the System DSN that you've previously created - more info on System DSN setup can be found here. Now you need to input the Linked Server name, e.g. Make sure to select Microsoft OLE DB Provider for ODBC Drivers: In the appeared Provider Options window, enable the Allow inprocess checkbox: For this, find the MSDASQL provider in the list of Linked Servers and double-click on it Retrieving Data From SQLiteĮnsure the Allow inprocess option of MSDASQL OLE DB Provider for ODBC Drivers is enabled. You can now issue distributed queries and access SQLite databases through SQL Server. The linked server will appear under the Linked Servers in the Object Explorer Pane. Alternatively, you can input the ODBC Driver connection string in the Provider field.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |