<div dir="ltr"><span class="gmail-tlid-translation gmail-translation" lang="en">Well, I've done some tests and I think I can confirm that the connection can not be established graphically if the database is in the project folder. Outside the project folder (or in a subfolder inside it) works perfectly.<br>Either way the subject does not make much sense. If you compile the connection path in the installation package, the program will only work on the computer where it was designed unless you use a system folder, which is not recommended, I think. If you could set the .host property at Application.path then it would only work as readonly what is useless.<br>What I do is create the "Application.Path/data" folder and locate the database in it. When creating the installation package, that database is compiled in the ejecutable and in the first execution is created normally in Desktop.datadir &/ Application.Name/ folder<br>In the following executions of the project, the .host of the connection to this path is established.<br></span><div><span class="gmail-tlid-translation gmail-translation" lang="en">A couple of days ago I uploaded a project to the Gambas Farm called gbcalendario (I did not have time to translate it, I'm sorry) that uses that technique.</span></div><div><span class="gmail-tlid-translation gmail-translation" lang="en"><br></span></div><div><span class="gmail-tlid-translation gmail-translation" lang="en">Hope it helps for you.</span></div><div><span class="gmail-tlid-translation gmail-translation" lang="en"><br></span></div><div><span class="gmail-tlid-translation gmail-translation" lang="en">Best Regards<br></span></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El mar., 16 jul. 2019 a las 19:23, Gianluigi (<<a href="mailto:bagonergi@gmail.com">bagonergi@gmail.com</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi Jorge,<br>I badly explained myself.<br>You mean that if the database is called MyDatabase, the program is called MyProject and is in the home folder you can't connect if MyDatabase is directly inside MyProject (home/<my user name>/MyProject/MyDatabase).<br>If you add a folder for example MyFolder then it works (home/<my user name>/MyProject/MyFolder/MyDatabase).<br><br>The same happens here.<br><br>I, on the other hand, would like to understand how to make the connection created with the graphic system of the gb.db.form component work, with MyFolder/MyDatabase located outside MyProject.<br>How can the connection work only if the database is in the project (even if in another folder)?<br>There must be a way to compile the project without compromising its operation.<br>What is it that my old brain can't understand?<br><br>Regards<br>Gianluigi</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mar 16 lug 2019 alle ore 18:28 Jorge Carrión <<a href="mailto:shordi@gmail.com" target="_blank">shordi@gmail.com</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>No, just the opposite: I can't connect in the application.path. Creating a new directory inside the application.path it'worked... but I didn't try further things... <br></div><div>I don't dare to isolate the bug (if its a bug).</div><div><br></div><div>Regards.<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El mar., 16 jul. 2019 a las 13:36, Gianluigi (<<a href="mailto:bagonergi@gmail.com" target="_blank">bagonergi@gmail.com</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi Jorge,<br>thank you very much for the reply.<br>So are you telling me that it is impossible to connect graphically to a database located outside the application?<br>The wiki on this topic is ambiguous...<br><br>Regards<br>Gianluigi</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mar 16 lug 2019 alle ore 12:19 Jorge Carrión <<a href="mailto:shordi@gmail.com" target="_blank">shordi@gmail.com</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>I had a similar issue a few days ago but in my case the .host of the connection was the /home/user/gambasprojects/project what is the application.path. I created a folder inside (/home/user/gambasprojects/project/Datos) and all works fine then. <br></div><div>I thought it was a exected behaviour...</div><div><br></div><div>Regards<br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El mar., 16 jul. 2019 a las 11:11, Gianluigi (<<a href="mailto:bagonergi@gmail.com" target="_blank">bagonergi@gmail.com</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi Hans,<br>thanks for the help but unfortunately I always get error:<br>See attached image.<br>I tried to connect to your test database, these are my passages.<br><br>FMain properties:<br>Arrangement = Vertical<br><br>DataSource1 properties:<br>Arrangement = Vertical<br>Connection = Connection1<br>Expand = True<br>Table = mausi<br><br>DataBrowser1 properties:<br>Columns id (table with one column)<br>Editable = True<br>Expand = True<br><br>FMain.class code:<br>Public Sub Form_Open()<br> Connections["Connection1"].Open<br>End<br><br>Public Sub Form_Close() <br> Connections["Connection1"].Close <br>End<br><br>Components:<br>gb<br>gb.db<br>gb.db.form<br>gb.form<br>gb.gui (or gb.gui.qt)<br>gb.image<br><div>I try also with adding gb.db.sqlite3 <br></div><div><br></div><div>Regards</div><div>Gianluigi<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno lun 15 lug 2019 alle ore 23:37 Gianluigi <<a href="mailto:bagonergi@gmail.com" target="_blank">bagonergi@gmail.com</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi,<br>I can't get the connection through only the graphic of the gb.db.form component.<br>See attached project.<br><br>In a Balloon on Debug Common.CheckDB.34 I get:<br>Unable to locate database 'test' in '~/database'<br><br>Am I wrong with the settings or is it a bug?<br><br>Regards<br>Gianluigi</div>
</blockquote></div>
<br>
----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
</blockquote></div>
<br>
----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
</blockquote></div>
<br>
----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
</blockquote></div>
<br>
----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
</blockquote></div>
<br>
----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
</blockquote></div>