Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lalbatros
Yak Posting Veteran
69 Posts |
 Posted - 2007-11-19 : 05:40:54
|
| Currently I am downloading data from a database to a client application, running a number crunching code on these data and uploading the results back to the server. The client application is in VB.I would like to run the number-crunching code in a separate exe on the server because the download and upload are very time consuming.Is it possible to launch an exe on the server from a VB client?Would it eventually be possible to do that concurrently for several instances of the client?Are there possibilities to watch (from VB) what is going on, like if the exe has completed.Thanks for your suggestions |
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-19 : 15:21:56
|
| xp_cmdshell |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-19 : 15:33:58
|
| Although xp_cmdshell is the answer to your question, it is highly not recommended to implement something like this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
lalbatros
Yak Posting Veteran
69 Posts |
Posted - 2007-11-20 : 01:07:51
|
| Sorry, but I have no experience with these things.I created a stored procedure with this sample code from msdn: CREATE PROCEDURE test AS EXEC xp_cmdshell 'dir *.exe'; GORunning this from my .adp project lead to the following message: Could not find stored procedure 'xp_cmdshell'Would you know how I could get this test running?Further, how could I execute this from VB, using DAO, ADO, or something else?Finally, what are the other ways to get the same result? |
|
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-20 : 04:01:39
|
| exec master.dbo.xp_cmdshell ... |
|
|
|
lalbatros
Yak Posting Veteran
69 Posts |
Posted - 2007-11-20 : 07:28:48
|
| Thanks, this will make my day! |
|
|
|
uplate
Starting Member
10 Posts |
Posted - 2007-11-28 : 16:25:53
|
| I would use a com+ written in vb and called from a stored procedure. |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-11-28 : 16:44:41
|
| It's also worth mentioning that xp_cmdshell only works for applications that require no UI to work. If your application has a UI that is _needed_ for it to work, xp_cmdshell is not going to solve your propblem.Can you get the workings of the VB app and port it to the database server, or COM as was suggested? |
|
|
|
|
|
|
|
|
how to run an exe on the server from a VB client