Re: xp_cmdshell and vb programs and SQL Server 2000
From: Alex (anonymous_at_discussions.microsoft.com)
Date: 03/02/04
- Next message: Veronica D'souza: "RE: Error converting a text field to a datetime datatype, who can figure this anyone????"
- Previous message: Tony Lorentzen: "Searching index server from SQL Server"
- Next in thread: Tibor Karaszi: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Reply: Tibor Karaszi: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Reply: Alex: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 2 Mar 2004 14:31:58 -0800
VB can be launched from batch and terminates without user
interaction. Executed from the desktop. Only hangs if
executed from xp_cmdshell even using a batch or without a
batch. Even putting CMD /C in the batch to force it to
terminate after executing. This has been working on a
Windows NT with SQL 7. Not working on SQL2000 and Windows
2000 Server. Tested on SQL2000 and Windows NT. Does not
work in that combination either. One more combination to
try. SQL7 and Windows 2000 Server.
>-----Original Message-----
>Can you launch your VB within a batch file and it
successfully terminates
>without user-interaction.
>
>--
>-oj
>http://www.rac4sql.net
>
>
>"Alex" <anonymous@discussions.microsoft.com> wrote in
message
>news:2dc101c3fcc7$3cb915c0$a301280a@phx.gbl...
>> The VB does open a form, but does not need user
>> interaction to terminate. The MSSQLSERVER service
account
>> is not set to LocalSystem. Is this the service account
you
>> are referring to?
>>
>>
>>
>> >-----Original Message-----
>> >This is generally if the program tries to open some
>> window... Perhaps the
>> >service account on your SQL2 is LocalSystem and it is
>> configured to
>> >"interact with Desktop"?
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >Archive at:
>> >http://groups.google.com/groups?
>> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >
>> >
>> >"Alex" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:0f7d01c3fb4b$03790e50$a301280a@phx.gbl...
>> >> Does anyone have any issues with xp_cmdshell with SQL
>> >> Server 2000 on Windows 2000 Server? The vb program
runs
>> >> but does not end properly. In other words, the task
>> >> manager shows the vb program hanging there. The same
>> >> program that shells out of SQL Server 7 on Windows NT
>> has
>> >> no problem. It's not a permissions issue either.
dir.exe
>> >> works. xp_sqlagent_proxy_account is set. Program is
>> >> running but does not terminate. Program does run and
>> >> terminate if run from the DOS prompt. Any clues?? I
am
>> in
>> >> the process of installing a SQL Server 7 on a Windows
>> 2000
>> >> Server to see if the shell works with the program
there.
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Veronica D'souza: "RE: Error converting a text field to a datetime datatype, who can figure this anyone????"
- Previous message: Tony Lorentzen: "Searching index server from SQL Server"
- Next in thread: Tibor Karaszi: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Reply: Tibor Karaszi: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Reply: Alex: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
