How to query my linked server
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 posted
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.
