ICOTech
asked on
I want to run a remote application exe from a web browser
How I can run a remote application exe from a web browser.
My application is not on the local network and is linked with a Microsoft Sql Server database.
My application is not on the local network and is linked with a Microsoft Sql Server database.
abel
You can start an application with Process.Start, i.e. Process.Start("Notepad"). However, you must be aware that starting processes in that way from the web is potentially dangerous. And even if it were not, you should check somehow the output or result of the application, but that of course depends on what you want to do with it.
ASKER
The application I want to start is not on the client computer. The client would be using a web-browser, but the application is located on another computer (on another network).
I want the client to remote control the server application form a web-browser. Why?
My application must connect to a remote SQL Server and that client can't have the SQL port open to access it. So im looking for a solution to run the application form a web-browser directly (the server that will host the application will have access to the SQL Server).
Hope this is more clear, and sorry for my english.
I want the client to remote control the server application form a web-browser. Why?
My application must connect to a remote SQL Server and that client can't have the SQL port open to access it. So im looking for a solution to run the application form a web-browser directly (the server that will host the application will have access to the SQL Server).
Hope this is more clear, and sorry for my english.
The code I showed you, well, the line "Process.Start("something.
However, if you want to connect to an SQL server, the preferred method would be not through an extra application, but to write a web page (ASP.NET or PHP or whatever language you prefer) to do the connection to the SQL Server and to perform the task. It is quite trivial to give a user access to it with a textbox where he/she could write an SQL query. Tools that do this (connection MS SQL Server through a web page) are freely available from many vendors or open source projects.
But that might not be what you are after. If you already have an application that does what you want and the user cannot use that locally because of firewall restrictions, I think the simplest to do is creating a web page with a button on it "Start app" and execute the Process.Start command in the code of that web page.
However, if you want to connect to an SQL server, the preferred method would be not through an extra application, but to write a web page (ASP.NET or PHP or whatever language you prefer) to do the connection to the SQL Server and to perform the task. It is quite trivial to give a user access to it with a textbox where he/she could write an SQL query. Tools that do this (connection MS SQL Server through a web page) are freely available from many vendors or open source projects.
But that might not be what you are after. If you already have an application that does what you want and the user cannot use that locally because of firewall restrictions, I think the simplest to do is creating a web page with a button on it "Start app" and execute the Process.Start command in the code of that web page.
ASKER
If I use the process.start the application will start on the server and the user will not see the interface? If I start it on client pc then the user wont be able to connect to the sql server (it will be like if the user start it directly from a desktop icon?). I don't see how a Process.Start could help me, did I miss something?
My application is already completed and have alot of screen. The application connect to a SQL Server, but in 1 case, the customer can't reach SQL Server because of firewall and can't open port to access SQL Server.
My objective is to be able to use the existing application and connect to the remote SQL Server. If there a way to remote control the application so that the application is not directly running on the client PC it be nice.
TY
My application is already completed and have alot of screen. The application connect to a SQL Server, but in 1 case, the customer can't reach SQL Server because of firewall and can't open port to access SQL Server.
My objective is to be able to use the existing application and connect to the remote SQL Server. If there a way to remote control the application so that the application is not directly running on the client PC it be nice.
TY
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The short answer would've been: your client is out of luck if (s)he can't change the firewall settings... :-(
ASKER
OK, ty for your time. im currently evaluating XenApp from Citrix that may do the job I want.
That's in the same league as VNC (but then commercial ware, of course). If you're ok with that approach, XenApp is an excellent choice.