Post reply

Call Exe from Stored Procedure

  • February 1, 2008 at 8:37 am

    #93887

    Hi Guys,

    We are using MSSQL Server 2000 and Sybase PowerBuilder. I need to know if it is possible to call a Powerbuilder exe through a SQL Server Stored procedure.

    I would appreciate your help.

    Thanks

  • February 1, 2008 at 8:40 am

    #774254

    provided the app doesn't need any user intervention and message boxes etc can be suppressed then you can call an executable from SQL stored proc by using xp_cmdshell to shell out to the OS. It's crude but it works.

    HTH

    thanks

    SQL_EXPAT

  • February 1, 2008 at 8:46 am

    #774257

    Is it possible to get an example.

    Thanks

  • February 1, 2008 at 9:30 am

    #774292

    exec xp_cmdshell 'dir c:\'

  • February 3, 2008 at 12:48 pm

    #774599

    Yasir, why do you want to call power builder from a stored proc?if you dont mind you can tell us your problem and then we can try to suggest a better (if any) soln.

    Everything you can imagine is real.

  • February 3, 2008 at 4:13 pm

    #774608

    You could also (shudder) create a COM object for your powerbuilder code and use the sp_OAxxx procedures in MS SQL to call your code. It depends if you want to pass parameters around the place or if you're happy building a command line (with any parameters appropriately escaped) and then parsing the recordset from xp_cmdshell...

  • February 3, 2008 at 7:05 pm

    #774620

    We are a PowerBuilder & SQL Server shop. We have a sister company that develops for handhelds.

    I have to develop this procedure for them. They will call this procedure and then I will call a PB exe already in use.

    Hope this helps.

Viewing 7 posts - 1 through 6 (of 6 total)

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