I have searched SSC threads. Looked at
linkedserver.database.schema.table
My linked server is linked to a SQLite db on another server. I can see the tables by expanding the linked server but I am unsuccessful in querying data. My odbc connection is set to the db. Have I created linked server wrong?update to my question. If I right click on a table in my linked server and try to script a query I get msg that no fields are in table or I do not have access. I can connect to same SQLite db on client machine using visual studio. very frustrated. it is probably security but not sure where.
sorry this double postedAnswer by DataJoe · Dec 26, 2018 at 06:32 PM
update to my question. If I right click on a table in my linked server and try to script a query I get msg that no fields are in table or I do not have access. I can connect to same SQLite db on client machine using visual studio. very frustrated. it is probably security but not sure where.
Transfer Linked Server along with Password 0 Answers
AVG in Weeks 1 Answer
SQL form query 1 Answer
Grab Point cooridinates from Geometry Collection SQL Server 1 Answer