<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">-----Original Message-----<br>
From: grass-user <grass-user-bounces@lists.osgeo.org> On Behalf Of Helmut Kudrnovsky<br>
Sent: Friday, August 07, 2020 8:32 AM<br>
To: grass-user@lists.osgeo.org<br>
Subject: Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS</p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>I am getting this error:<o:p></o:p></p>
<p class="MsoPlainText">><o:p> </o:p></p>
<p class="MsoPlainText">>Process ended with non-zero return code 3221225785. See errors in the<o:p></o:p></p>
<p class="MsoPlainText">(error)<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>it's a dll mixing/mismatch due to more of the same dll in your %PATH%.<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black">I went through as suggested and excluded the sqlite dlls found and that did not help.<o:p></o:p></span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>which library errored the message above? (sqlite? gdal?)<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">The library that errored is sqlite.<o:p></o:p></span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>g.run_command(r'C:\OSGeo4W64\apps\grass\grass78\bin\g.proj.exe',<o:p></o:p></p>
<p class="MsoPlainText">georef=geotiff, location = >locationGeonet)<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>really an unusual way to invoke g.proj. never saw this working.<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black">I am trying to get a model that I did NOT write to work this is how they do it. Perhaps there is a better way.<o:p></o:p></span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>I think this is a conflict with the sqlite3.dll as is suggested the
<o:p></o:p></p>
<p class="MsoPlainText">>below<o:p></o:p></p>
<p class="MsoPlainText">wiki but the solutions there have >not worked for me.<o:p></o:p></p>
<p class="MsoPlainText">><o:p> </o:p></p>
<p class="MsoPlainText">><a href="https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgrass"><span style="color:windowtext;text-decoration:none">https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgrass</span></a><o:p></o:p></p>
<p class="MsoPlainText">>wiki.osgeo.org%2Fwiki%2FWinGRASS_errors&data=02%7C01%7CDAmico.Ellen<o:p></o:p></p>
<p class="MsoPlainText">>%40epa.gov%7Ce28ddeb63b4e45dced4d08d83acde1bd%7C88b378b367484867acf976a<o:p></o:p></p>
<p class="MsoPlainText">>acbeca6a7%7C0%7C0%7C637324003812775461&sdata=s8uZGsVa%2Fif7EKaoiBhz<o:p></o:p></p>
<p class="MsoPlainText">>pBx8Wy5OpIZRlWcQ8F1mjpQ%3D&reserved=0<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">which solutions did you try?<o:p></o:p></p>
<p class="MsoPlainText">I tried everything suggested in the link for #1 and #16 which are both about sqlite conflicts.<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText">>>just open a normal windows console and type:<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>C:\Users\yourusername>where "$path:sqlite3*"<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>it's checking sqlite3 in your %PATH%<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>report back in your case.<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText">I checked out the dll's previously following the original link I sent with my question. I tried to do the one by one exclusion and none helped.<o:p></o:p></p>
<p class="MsoPlainText">When I run the where from the windows console I get this:<o:p></o:p></p>
<p class="MsoPlainText"><img border="0" width="647" height="105" style="width:6.7395in;height:1.0937in" id="Picture_x0020_1" src="cid:image001.png@01D66C98.D8A81050"><o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">When I do it from the OSGGeo4W Shell. I get this:<o:p></o:p></p>
<p class="MsoPlainText"><img border="0" width="398" height="187" style="width:4.1458in;height:1.9479in" id="Picture_x0020_2" src="cid:image002.png@01D66C98.D8A81050"><o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>when I open the OSGeo4W shell, I get<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>C:\>where "$path:sqlite3*"<o:p></o:p></p>
<p class="MsoPlainText">>>C:\Program Files\QGIS 3.4\bin\sqlite3.dll C:\Program Files\QGIS 3.4\bin\sqlite3.exe<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>is there a windows console availabe in the Spyder/ Anaconda framework? if yes, then type where "$path:sqlite3*" and report back.<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black">There is not.<o:p></o:p></span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>have you seen:<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>><a href="https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FOSGeo%2Fgrass%2Fissues%2F679&data=02%7C01%7CDAmico.Ellen%40epa.gov%7Ce28ddeb63b4e45dced4d08d83acde1bd%25%3e%3e7C88b378b367484867acf976aacbeca6a7%7C0%7C0%7C637324003812775461&sdata=r%2B3UD8sQn8t%2BgcXZXTR50FGRoV29QvnODiD77A1vFqY%3D&reserved=0">https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FOSGeo%2Fgrass%2Fissues%2F679&data=02%7C01%7CDAmico.Ellen%40epa.gov%7Ce28ddeb63b4e45dced4d08d83acde1bd%>>7C88b378b367484867acf976aacbeca6a7%7C0%7C0%7C637324003812775461&sdata=r%2B3UD8sQn8t%2BgcXZXTR50FGRoV29QvnODiD77A1vFqY%3D&reserved=0</a><o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>?<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span style="color:black">I have not. But that does seem to be my exact error. I wonder if I switch to miniconda instead of Anaconda that will help. Thanks for sending it.<o:p></o:p></span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>>and the mentioned thread:<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">>><a href="https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F53682315%2Ferror-on-libcurl-dll-when-using-gdal-of-osgeo4w-in-django&data=02%7C01%7CDAmico.Ellen%40epa.gov%25%3e%3e7Ce28ddeb63b4e45dced4d08d83acde1bd%7C88b378b367484867acf976aacbeca6a7%7C0%7C0%7C637324003812785429&sdata=AnOizoWcJzI6cY3WqhLQ42Pxx%2BSiYg2Y0PC%2FdFZgMDA%3D&reserved=0">https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F53682315%2Ferror-on-libcurl-dll-when-using-gdal-of-osgeo4w-in-django&data=02%7C01%7CDAmico.Ellen%40epa.gov%>>7Ce28ddeb63b4e45dced4d08d83acde1bd%7C88b378b367484867acf976aacbeca6a7%7C0%7C0%7C637324003812785429&sdata=AnOizoWcJzI6cY3WqhLQ42Pxx%2BSiYg2Y0PC%2FdFZgMDA%3D&reserved=0</a><o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Thank you.<o:p></o:p></p>
<p class="MsoPlainText"><span style="color:black">Ellen<o:p></o:p></span></p>
</div>
</body>
</html>