Remote Server Configuration and Setup on Windows 10

[JC0133]

Looking to see if anyone can give me some guidance (tutorials, YouTube help videos, website for beginners) for configuring a remote server/setup for a database I need to create in android studio. I need to connect to the server via this database. Also looking for some guidance in how to connect a database to a remote server.

So, I need to set up a Remote Server. Where I am also creating a database in a mobile app where I need to connect to the server.


I have created a database in a mobile app before, using SQLite but I don’t know if I can user SQLite to connect to a remote server. Is that possible? If not which database software/language should I use?


Does anybody have any documents or detailed instructions, or a good website for beginners for configuring and setting up a remote server and how to connect a database to it. Or maybe some good YouTube videos?

 

[JC0133]

A little more information.

I plan to connect the DB to the server and run queries.

 

[DaveSimmons]

I plan to connect the DB to the server and run queries.

Do you mean the server will connect to your mobile device, ask the device to run an SQL type query (for security this should not be actual SQL, more like a function call), the device will query its local database and return records as a response?

Or do you mean there is a database on the remote server, the mobile device does a query of it, takes the response and then stores it in a local database?

A few more details would help.

 

[mxnerd]

You probably want to look at database with REST(FUL) API which can transmit data through http protocol, so you can query/update the database across internet.

 

[KIAman]

Your question is very confusing. From the way I read it, you want to connect your database from your device to a server somewhere out in the internet?

What are you trying to accomplish? I think your solution needs to be reconsidered if this is the direction you actually want to go.

 

[JC0133]

So I am setting up a VPN like this.

https://www.youtube.com/watch?v=5GWIHv94KPMthe

And I wanted to store an excel table on the server. And on the client I wanted to MS SQL Server to connect to that server and get the excel file and convert it to a table in my database in SQL server.

Then in android studio I wanted to query that table and add to it.