question

DataJoe avatar image
DataJoe asked

Query sqllite int field via linked server

I am having the issue of 32bit vrs 64bit I believe. I am querying sqllite data via sql linked server. The source data represents amount of memory on a PC and results are always 2147483647. There are many blogs and threads on this but I have not found a solution. Is there one?
linked server
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
jason_clark03 avatar image
jason_clark03 answered
Theoretically, if you can install the ODBC driver, you can create a system DSN. If you can create a system DSN, you can add it as a linked server. Why do you not go through the third party [Sqlite Recovery Software][1]. [1]: http://www.sqliterecovery.com/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.