How to run exe in another system which is in same LAN

Salman N

Hi All,

I have developed a C# project and have created an exe.

Now the problem is I can install and run the exe in the my system(i.e this is the main system) .However when I install the same exe in another system available in my LAN network and run getting error as (EXE has stopped working) . I don't why.. Those systems have already installed with the respective Dot Net 3.5 versions.

I dont know what is stopping the exe to run .

My Data Connection class is as follows:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient ;

using System.Data ;

using System.IO;

using System.Xml;

namespace FiberGeneric

{

public class DataConnection

{

public SqlConnection funGetConnection()

{

string yourpath = Environment.CurrentDirectory + @"\FiberConfiguration.xml";

XmlReader reader = XmlReader.Create(yourpath);

reader.Read();

reader.ReadStartElement("connection");

reader.ReadStartElement("server");

//xmlDocument.GetElementsByTagName("server").Item;

string sServername = reader.ReadString();

reader.ReadEndElement();

reader.ReadStartElement("database");

string sDataBasename = reader.ReadString();

reader.ReadEndElement();

SqlConnection Con = new SqlConnection(@"Data Source=" + sServername + ";Database=" + sDataBasename + ";Integrated Security=True;Connect Timeout=300;");

return Con;

}

My XML Configuration file code is as follows:

WINSTAR-PC\SQLEXPRESS

Please let me know what am I doing wrong here.

Regards,

Salman

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Khaja Moizuddin8y ago
https://community.spiceworks.com/topic/170805-need-a-simple-script-to-remotely-run-an-exe-already-on-every-machine https://social.msdn.microsoft.com/Forums/vstudio/en-US/7a32c1f7-2453-468f-b9fd-3401cb25d2ad/how-to-run-an-exe-in-another-computer?forum=vcgeneral https://stackoverflow.com/questions/25782308/execute-exe-on-remote-machine https://stackoverflow.com/questions/13675826/how-to-run-a-c-sharp-exe-file-on-many-computers Please can you check these links for your requirement
Nitin Sontakke8y ago
Everybody does everything first time.

Have a look here:

https://stackoverflow.com/questions/13043530/what-is-app-config-in-c-net-how-to-use-it
Dharmraj Thakur8y ago
That's right I am agree with @Nitin sir. Remove connection string from XML file and move it to default app.config file and don't forget to add providerName in connection string...

providerName="System.Data.SqlClient"

Main Computers' SQL can access from all it's nodes of network by enabling TCT/IP configuration.
Salman N8y ago
@Nitin

Hi Sir,

If I understood your solution then I must make my DataConnection class to call the app.config file instead of calling the xml file, Please correct me if I am wrong. Also I am gonna look at the URL you have suggested.

I am new to this kind of stuffs please guide me till I achieve my requirement, Thank you so much in advance.

Regards,
Salman
Amit Gupta8y ago
@Salman

Your question to LAN connectivity and running an exe on another machine both are having seperate things.

Let's clear the following points
1. There is no need to install VS and SSMS on the production machine.

2. If you want every machine has its own seperate database then each machine should have Sqlserver express must be installed with appropriate .net framework.

3. If you want a single database is used by multiple PC's then you have to install db on a machine and pass that IP to others machines.

4. As you are using windows form then program must throw a JIT exception error window that contains the error details.

Hope you understood your actual problem and expresa it accordingly.
Nitin Sontakke8y ago
Okay. Got it.

1/ Do not use your custome config file, instead use built in app.config file. So no need to reinvent the wheel and write a code to parse the xml file. There is a built in support for reading configurations.

2/ One connection string will be .\SQLExpress and in another connection string would be [machine_name].\sqlexpress or [machine_ip].\SQLExpress. Using IP is recommended.

3/ As mentioned before, please implement some sort of exception handling. To begin with feel free to show exceptions in message box directly (not recommended). The best approach would be to write it to the text file.

4/ I don't personally believe that SQL Express natively support connections from other machines.See following link. Google for your version specific configurations.

https://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/
Dharmraj Thakur8y ago
Please use try catch or logging... what is the actual error message... then let me know
Salman N8y ago
Hi Nitin Sir,

I am not installing SQL server on each and every PC .

I have two systems Lets say System A and System B.

Now System is my main System i.e.,(System A) . I have installed visual studio and sql server in this system and have created a project for which I have also created an exe.

The exe is running fine in main system (System A), but when I run the exe in System B it is not running . As soon as I click on the exe after few seconds I m just getting a pop which says "Exe has stopped working" and cannot be opened.

Both the Systems are connected with each other. I have pinged the System A from System B and received the response.

All I want is to run the exe I have created in System A in System B. Hope I have cleared what I need now .

Regards,

Salman
Nitin Sontakke8y ago
Please be VERY VERY specific about what you are trying to achieve here. You are installing sql server express databases on each machine and also install front-end on each of the machine on the lan.

How such set-up helps in modern world is somehow not clear to me.

Will you NEVER want any consolidation of dbs in future? Why have so many identical databases in first place?

I know that it is none of my business, but still curious to understand the business case for such a set-up.
Dharmraj Thakur8y ago
Changing server name in XML is not necessary. Just check which is working or connecting from main and node pc both...
Salman N8y ago
Hi Amit,

thank you so much for the response. Yes installing the exe in each and every system. so I should be changing my XML file (instead of WINSTAR-PC\SQLEXPRESS) will be as (.\SQLEXPRESS) .

Please correct if am wrong.

Will change this and let you if it works out.

Also one clarification, why I should not use the IP ID of the main PC if I am installing the application in each system ?

regards,

Salman
Dharmraj Thakur8y ago
First add the providerName in your connection string item in web.config...

providerName="System.Data.SqlClient"

I am assuming there is two computer one is main pc and anothe is node pc.

Do this things on main pc...

1. Install sql server

2. Allow or open port for that sql instance from firewall

3. Enable TCP/IP and browser from SQL Server configuration manager.

4. Install your software

5. Share your drive where exe is installed with full edit access to everyone

6. Check everything is working fine in your software and database.

Do this things on node-pc...

1. Install your software again (just for provide ddl to windows do not use this exe)

2. Check whether network SQL instance is connecting from here or not

2. Map shared drive of main pc and run that exe...

Now you can get as expected...

Thank you
Nitin Sontakke8y ago
Also you just mention, it doesn't work, it stopped working, but do not give exact error reported, which is important.

May be you wish to implement some sort of exception handling, log an exception to a text file and have a look at exact error reported.
Amit Gupta8y ago
Hey

If database is centralized then you need to pass the IP address of that machine in your xml file.

If you are installing individual application with database then use
.\SQLEXPRESS

Instead of

WINSTAR-PC\SQLEXPRESS

Because Winstar-pc name might not be othere pc name. Dot specifues the current user.

Do let me know, if it works or requires any clarifications.