question

DataJoe avatar image
DataJoe asked

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?
sql querylinked server
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·
DataJoe avatar image
DataJoe answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DataJoe avatar image
DataJoe answered
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.