<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Johan - <br>
<br>
How did you actually try to open your sqlite file? In Qgis you
have 2 options for opening spatialite/sqlite: <br>
<ol>
<li>Open it using "Layer" --> "Add Spatialite layer" .. works
only for spatialite files (!)</li>
<li>Open it using "Layer" --> "Add Vector layer" and choosing
file type "sqlite [OGR]" file type <br>
</li>
</ol>
<p>Have you tried option no. 2 ?<br>
</p>
<p>Regards<br>
Bo Victor Thomsen<br>
Aestas-GIS<br>
Denmark<br>
<br>
</p>
<p><br>
</p>
Den 13-09-2013 01:03, Johan Nilsson skrev:<br>
</div>
<blockquote
cite="mid:CALnM-k8TJGKJaFcEM0+zPTB0NvADm0joQy3vuLbGo1KJg+7V6Q@mail.gmail.com"
type="cite">
<div dir="ltr">I have an app Oruxmaps that store tracks and
wapoint in a sqlite 3 db. When I try to open or connect it in
QgisI get an error that says:<br>
<br>
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<p style="margin:0px;text-indent:0px">no such table:
geometry_columns</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<p style="margin:0px;text-indent:0px">How do I create a
geometry_columns and/or convert it from sqlite to spatialite?</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<p style="margin:0px;text-indent:0px"><br>
</p>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>