Android Example SQLite, remote connection

Hello.
I have the following problem: I can not find an example of code written to run a remote connection to a SQLite DB.
I used the DRC to connect to a DB MS-SQL.
I do not understand if the DRC is also useful for SQLite DB.
If the DRC is also used to connect to SQLite DB, I do not understand what code to use to do this.
The procedure works with three tablet. A tablet is the owner of DB others must connect and work on that DB.

Thank you all for your cooperation.
 

biggiu

Member
Licensed User
Longtime User
Hi Erel,
sorry but I could not make anything work.
I followed all the examples but I really can not solve the problem.
I have attached my configuration of the server and the client to try to figure out where the problem lies.
On my PC I created the folder c: / tmp. I copied the DB codedb.sqlite.
The config file I have tried before with codedb.sqlite and then with codedb but I got nothing.
The IP address 192.168.1.100 refers to my work PC, which also resides B4A.
It 'strange that I was able to connect to a MS-SQL DB and I can not do it with SQLITE.

You can try to help me?
 

Attachments

  • RDC.zip
    58.3 KB · Views: 557

biggiu

Member
Licensed User
Longtime User
Sorry but don't work.
I tried two different examples, mine and that of Luca Messina.
Neither one works.
I attach the DB test.
I attach the config of LM.
The driver used is: sqlite-jdbc-3.7.2
 

Attachments

  • tmp.zip
    20.1 KB · Views: 419
  • CONFIG.zip
    1.2 KB · Views: 431

biggiu

Member
Licensed User
Longtime User
I think I have solved.
There were two problems:
Spaces too, and the name of the DB that was not nome.db but nome.sqlite
Now I can connect.
I do other tests and hope not to have other problems.
Thanks for your kind cooperation.
Good Job.
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…