MSSQL 2000 xp_cmdshell
David Rawheiser
I would guess (and its only a guess) - that the stored procedure is
returning early (before the call to the xp has completed). Or something
else in the client is trying to use the database connection before the first
call is complete.
I have had a simular problem before with MS SQL 7 and PB via DBLIB calling
long running procedures; and 'solved' it by :
1. creating a new and seperate TransactionObject,
2. Connecting ,
3. Executing the Procedure ,
4. disconnecting
5. and then destroying the transobject.
<Caroline_Luey> wrote in message
news:D6E5D749F11AB8BF0078A50985256A29.0078A51885256A29@webforums...
> I'm currently running PowerBuilder 7.0.2 (build 8046) connected to
> MSSQL2000 using db_lib (ie. same way when connecting to SQL 6.5 via native
> driver). The problem I have is executing xp_cmdshell thru stored
procedure.
> When I run the stored procedure in SQL Query Analyser, it runs fine but if
> I run the stored procedure in PowerBuilder/PowerScript, it does not work.
> Does anyone run into this problem?
>
> Any assistance would be greatly appreciated.
> Caroline Luey
