Make one database on SQL and connect with C# application which install in different computer at different places

0.00/5 (No votes)

See more:

Hi every one.
I have a question from all experts of c#.
I make Database using sql server 2012 and also make an window form application using visual studio 2017. Now I want to take this database as online so different computer are attach with this database and use c# application for work on the this database in same time.
Is it possibal or not if it is posibal then tell me the solution of how can I do this.
Thanks in advance

What I have tried:

I have no idea how can i do this.

Posted 9-Aug-18 9:50am

Fahid Zahoor

Updated 9-Aug-18 10:55am

RedDk

Add a Solution

Comments

j snooze 9-Aug-18 17:34pm

It is very possible, however the database should probably be on a server running 24 hours a day 7 days a week. The server would need the port (usually 1433) open for receiving and listening for requests to the server. So if your server has a firewall on, you'll have to make sure its not blocking that. Then just modify your current connection string to point at the new server. If you are not sure about modifying the connection string go to connectionstrings.com for an idea. Hope that helps a little.

Fahid Zahoor 9-Aug-18 17:41pm

but if i use internet and then do the same tash is it possibal becuse as you said my all computers are connect with server using wires but i can do this without wires beacuse may be one is my computer application that use the same database and other is my andriod app that also used with same database.

Richard MacCutchan 10-Aug-18 4:45am

As already explained, install the SQL Server software and the database, on a server that the other computers can connect to. Whether they are wired in on a local network, on a wifi link, or via the internet, it works just the same.

Mike V Baker 10-Aug-18 9:29am

Have you already written the Android app that's going to use this database? How are you connecting now?
If you're connecting your android to the database through your local network in your office then you should be able to do so through a network connection regardless of physical location. You would need VPN software on the android to make the network available to your app.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Rick York	80
Richard MacCutchan	40
Richard Deeming	40
Graeme_Grant	40
Dave Kreskowiak	40

Pete O'Hanlon	1,830
OriginalGriff	1,365
Graeme_Grant	895
Richard Deeming	798
Dave Kreskowiak	684

Make one database on SQL and connect with C# application which install in different computer at different places

Add your solution here

Preview 0

Make one database on SQL and connect with C# application which install in different computer at different places

Add your solution here

Preview 0

Existing Members

...or Join us