Execute Stored Procedure from Desktop and return errors

Question

Execute Stored Procedure from Desktop and return errors

peter.draper

SSC Journeyman

Points: 89
More actions
June 3, 2011 at 5:39 am

#73802

Hi,
I wonder if anyone can help me. I have a stored procedure which handles and manipulates some data.
Firstly I would like an operator to be able to double clcik an icon on his/her desktop, which then runs this stored procedure on the server. Is this possible?
Secondly I have some error checking in case values are entered wrong and if they are, i would like to be able to return a message to that workstation saying 'Incorrect partnumber may have been entered for FGL'+@sn for example. Any ideas?
Thanks,
Peter

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

can you put the code on a web page, wether an intra- or internet?

that'd be simplest...single source, accessible from each desktop, web page could provide results and error messages if returned.

i'd hate to deploy a desktop app, and then have to upgrade it later as you add enhancmeents....

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

peter.draper SSC Journeyman Points: 89 More actions · Answer 2

Due to how the network is set up, that isn't really an option.

I was thinking some kind of batch file which calls the stored procedure, therefore meaning any chanegs to the stored procedure would be refelcted in any desktop buttons?

Peter

Alan H Valued Member Points: 52 More actions · Answer 3

Google says:

http://www.cruto.com/resources/vbscript/vbscript-examples/misc/database/Connect-to-a-SQL-Server-Database.asp

That'll get you connected, and shows how to display output to the user. Next thing to find is how to get feedback from the stored procedure so you can show it. Sounds like another job for Google, or just search on MSDN.