How to query my linked server

Question

question

DataJoe asked Dec 24, '18

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 query linked server

1

10 |1200 characters needed characters left characters exceeded

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

DataJoe · Dec 26, 2018 at 06:33 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.

sorry this double posted

0 ·

Answer 1 · 2018-12-26T18:32:16Z

DataJoe answered Dec 26, '18

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

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

Answer 2 · 2018-12-26T18:32:53Z

DataJoe answered Dec 26, '18

https://ask.sqlservercentral.com/answers/149017/view.html

10 |1200 characters needed characters left characters exceeded

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

question