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 |
|
jmangione
Starting Member
7 Posts |
 Posted - 2004-10-20 : 16:27:18
|
| I have a SQL 2000 server on a raid 5 config. (C$-G$) I am trying to execute the following T-SQL:master..xp_cmdshell 'wzunzip -o G:\AZipFile.zip G:\'I have also tried:master..xp_cmdshell ' "C:\Program Files\WinZip\wzunzip.exe" -o G:\AZipFile.zip G:\'But I just get hung; nothing happens. When I try to run this from my machine:D:>"C:\Program Files\WinZip\wzunzip.exe" -o X:\AZipFile.zip X:(I have the G$ of the Server mapped on my machine as X$ but both the server and my machine have Winzip in the same spot) from the command prompt, it works fine; the program executes with no problem. And help would be greatly appreciated!Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-20 : 16:30:58
|
| Does C:\Program Files\WinZip\wzunzip.exe exist on the database server? If not, then that's your problem. Otherwise, it's because the executable is launching in another session and possibly asking you questions that you can't answer since you aren't in that session.Tara |
 |
|
|
jmangione
Starting Member
7 Posts |
Posted - 2004-10-20 : 16:33:12
|
| Yes, C:\Program Files\WinZip\wzunzip.exe does exist on the server and the -o is "supposed" to answer "yes" to all of my questions, so that it executes silently...but you may be right (I also tried ybc as reccomended by winzip). Do you know of any other switches that may be useful here? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-21 : 01:15:11
|
| Perhaps the copy on your machine is Registered, but the one on the server is not - so the server is saying "Demo copy ... Press ENTER to continue" or somesuch ...Try running it manually on the server and see what messages you get ....Kristen |
|
|
|
|
|
|
Help with WZUNZIP