Help about database in network or server?

[rehpej]

hi, tanong lang po pano po magsimula ng database na connected sa certain network or server? yung pwede po makapag insert/view/update/delete ng mga records gamit ng ibat ibang device?

ang natry ko pa lang po is yung mismong database is naka save din sa laptop. so kung may iuupdate dun sa database, dapat sendan lahat ng gagamit.

 

[tuper]

hi, tanong lang po pano po magsimula ng database na connected sa certain network or server? yung pwede po makapag insert/view/update/delete ng mga records gamit ng ibat ibang device?

ang natry ko pa lang po is yung mismong database is naka save din sa laptop. so kung may iuupdate dun sa database, dapat sendan lahat ng gagamit.

https://technet.microsoft.com/en-us/library/ms345343(v=sql.110).aspx#Anchor_3

check mo yan. Baka magka idea ka. Given na connected sa isang network lahat ng devices.. Try mo google kung ano mang db yang ginagamit mo.

"Madaling sabihin, mahirap gawin. Push mo lang!"

 

[Enrique]

you can access it with the host device's ip address and the corresponding port.

E.G

you have an MYSQL database at localhost:3306 and you want it to be accessed remotely via your network, just familiarize yourself with the host's ip address (example its IP is 192.168.1.4) you can now use this ip address to any rdbms like Navicat to access the database just input 192.168.1.4 as your host. Same thing as to a VPS just put your VPS's IP Address and make sure you have a database server like MySQL running.

 

[rehpej]

woah. wait mga sir. check ko mga suggestion nyo. haha. dati kasi gamit ko access. pero lilipat ako ng sqlite. minimal lang po ba yung pagkakaiba?