[MS4W-Users] Spatiallite support

[TC Haddad]

Hi Mark,

There is also a Firefox add-on called SQLite manager that you can use to
inspect the database - very handy to have if you just need to take a look
and see if the database looks valid...

Tanya

On Thu, Mar 9, 2017 at 1:56 PM, Jeff McKenna via MS4W-Users <
ms4w-users at lists.ms4w.com> wrote:

> Hi Mark,
>
> MS4W includes the sqlite3.exe utility, which you can use to view the
> contents of the database (after you execute setenv.bat), try "sqlite3
> select_6481489087910.db"  (and once connected, view its tables with a
> ".tables" command).
>
> Note that I have noticed that not all Spatialite databases can be loaded
> by GDAL.  Definitely give a thorough read to the GDAL driver page:
> http://gdal.org/drv_sqlite.html
>
> -jeff
>
>
> --
> Jeff McKenna
> MapServer Consulting and Training Services
> http://www.gatewaygeomatics.com/
>
>
>
> On 2017-03-09 5:01 PM, Mark Volz via MS4W-Users wrote:
>
>> Jukka,
>>
>>
>>
>> I am unable to open up the database.  I noticed that SQLite was listed
>> as a potential driver for ogrinfo.
>>
>>
>>
>> C:\ms4w\tmp\ms_tmp>ogrinfo select_6481489087910.db
>>
>> FAILURE:
>>
>> Unable to open datasource `select_6481489087910.db' with the following
>> drivers.
>>
>>   -> PCIDSK
>>
>> ….
>>
>>         SQLite
>>>
>>
>> ….
>>
>>
>>
>> Thank You!
>>
>>
>>
>> Sincerely,
>>
>> *Mark Volz, GISP***
>>
>>
>>
>> *From:* Rahkonen Jukka (MML) [mailto:jukka.rahkonen at maanmittauslaitos.fi]
>> *Sent:* Thursday, March 09, 2017 2:52 PM
>> *To:* ms4w-users at lists.ms4w.com
>> *Cc:* Mark Volz <MarkVolz at co.lyon.mn.us>
>> *Subject:* Re: [MS4W-Users] Spatiallite support
>>
>>
>>
>> Hi,
>>
>> What does ogrinfo report about your database file?
>>
>> -Jukka Rahkonen-
>>
>> ------------------------------------------------------------------------
>>
>> *Lähettäjä: *Mark Volz via MS4W-Users <mailto:ms4w-users at lists.ms4w.com>
>> *Lähetetty: *‎9.‎3.‎2017 21:22
>> *Vastaanottaja: *ms4w-users at lists.ms4w.com
>> <mailto:ms4w-users at lists.ms4w.com>
>> *Kopio: *Mark Volz <mailto:MarkVolz at co.lyon.mn.us>
>> *Aihe: *[MS4W-Users] Spatiallite support
>>
>> Hello,
>>
>>
>>
>> How can I verify and or enable support for spatiallite in ms4w 3.2.1?  I
>> am getting an error:
>>
>>
>>
>> Native SQL not available, no Spatialite support and/or not a Spatialite
>> enabled db
>>
>>
>>
>>
>>
>>
>>
>>                                 CONNECTIONTYPE OGR
>>
>>                                 CONNECTION
>> '/ms4w/tmp/ms_tmp/select_81841489080737.db'
>>
>>                                 DATA 'features'
>>
>>
>>
>> Thank You!
>>
>>
>>
>> Sincerely,
>>
>> *Mark Volz, GISP*
>>
>>
>>
>>
>>
>
>
> _______________________________________________
> MS4W-Users mailing list
> MS4W-Users at lists.ms4w.com
> https://lists.ms4w.com/mailman/listinfo/ms4w-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ms4w.com/mailman/private/ms4w-users/attachments/20170309/2b589ae9/attachment.html>