Italian Accesso sqlite tramite ip

Xfood

Expert
Licensed User
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
B4X: 
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
 

Xfood

Expert
Licensed User
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

Expert
Licensed User
Longtime User

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
 

Magma

Expert
Licensed User
Longtime User

Xfood

Expert
Licensed User
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

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

Magma

Expert
Licensed User
Longtime User
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)
 

Magma

Expert
Licensed User
Longtime User
@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

Expert
Licensed User
unfortunately the db is updated continuously, i cannot copy it every 10 minutes, i think i will use rdc2
 
You must log in or register to reply here.

Similar Threads

Italian [B4A] db sqlite
Replies
14
Views
910
Star-Dust
Italian [B4A] tasferire file da android a pc Tcp/ip
2
Replies
32
Views
4K
Xfood
Italian B4J - Chat TCP/IP ...
Replies
4
Views
2K
Spinter
A
Italian collegarsi ad un db Sqlite/MySql su pc locale tramite internet
Replies
9
Views
3K
sirjo66
R
Italian Rete sensori
Replies
3
Views
2K
robybart
R
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…