Italian Accesso sqlite tramite ip

[Xfood]

Buongiorno a tutti
vorrei utilizzare un db sqlite residente su un pc in rete,
direttamente con un terminale android
ho provato questa stringa, ma va in errore

sql.Initialize("\\192.168.1.17\c-drive\SysPc\DbCasse\", dbname, False)

qualche idea per accedere ad un db in rete, senza rdc e vari...
Grazie a tutti per i suggerimenti

 

[LucaMs]

qualche idea per accedere ad un db in rete, senza rdc e vari...

Non esiste.

 

[Xfood]

Neanche tramite smb??
Stavo cercando di fare varie prove,
Riesco a copiare da e verso il terminale android , ma no ad aprire il file

 

[josejad]

b4a codes to connect sqlite remotely

my honorable members, pls i am very new in b4a and also new in data base configuration, remote connection, idea of server etc. i have written a program in b4a that open and read sqlite db that is stored in dirasset folder and it works perfectly, my problem is that i want to store same sqlite db...

www.b4x.com

 

[Xfood]

b4a codes to connect sqlite remotely

my honorable members, pls i am very new in b4a and also new in data base configuration, remote connection, idea of server etc. i have written a program in b4a that open and read sqlite db that is stored in dirasset folder and it works perfectly, my problem is that i want to store same sqlite db...

www.b4x.com

thanks, I was hoping there was a workaround

 

[Magma]

Before some years... tried to find a solution for that...

Google releases Samba client for Android, adds Windows file shares to the Downloads/Files app

www.androidpolice.com

...Ofcourse that is far away that you wanna do... is just copying the file (for you the sqlite db)... you editing... and then return it back... but also need Android studio (bliach).

 

[Xfood]

Visto che l'unica soluzione sembra utilizzare rdc2, mi serviva un chiarimento
Rdc2 tiene sempre aperto il db?
Oppure lo apre ad ogni richiesta, esegue la query e lo richiude?

 

[Magma]

@Xfood If it is only for lan use (and not for public) you can use direct sql connection (mariadb, mysql)

 

[Magma]

Before some years... tried to find a solution for that...

Google releases Samba client for Android, adds Windows file shares to the Downloads/Files app

www.androidpolice.com

...Ofcourse that is far away that you wanna do... is just copying the file (for you the sqlite db)... you editing... and then return it back... but also need Android studio (bliach).

If you wanna do something like that will be better using our perfect tools.. made at b4x for b4x..

jserver (to have it in desktop pc... and giving the possiblity to download the sqlite db to android)
httpsutils (from android to download the file from desktop-server... or upload it at the end)

All these just as an idea... but this means that will be only for one user per time (the db)

 

[Xfood]

@Xfood If it is only for lan use (and not for public) you can use direct sql connection (mariadb, mysql)

thanks @Magma the db is not mine, I just have to read some information from this db, which is populated by a management system

 

[Magma]

@Xfood so... if you need just to read... and not to write to it... post #9 ....i think is fitting to you (without the need to return it back)

(ofcourse the db must not updating the time you are copying it)

 

[Xfood]

unfortunately the db is updated continuously, i cannot copy it every 10 minutes, i think i will use rdc2