Can someone who knows a lot more about this than me please tell why, when
the following code executes, I get a pop-up window telling me the usage of
isqlw.exe?

<code>

strQueryCommandPath = "C:\\Program Files\\Microsoft SQL
Server\\80\\Tools\\Binn\\";

strArguments = "-S(local)\\SQLEXPRESS ";

strArguments += "-Usa ";

strArguments += "-Padminmlc ";

strArguments += "-i" + strCurrentDir + strFileName + " ";

myProcess.StartInfo.WorkingDirectory = strQueryCommandPath;

myProcess.StartInfo.FileName = "ISQLW.EXE";

myProcess.StartInfo.Arguments = strArguments;

myProcess.StartInfo.UseShellExecute = false;

return myProcess.Start();

</code>



I've also tried it with a space in between the - switch and also with quotes
around the switch arguments.  I've put the entire path in just the
StartInfo.FileName instead of switching the working directory as well.  I
can't for the life of me get it to actually fire off this command for some
reason.

p.s. I've also tried using "/"s instead of "-"s as well.

Jayyde (a***@hotmail.com) writes:
Show quoteHide quoteThis is my prime suspect. Change this to:

Show quoteHide quote

you can using /o argment, out put file save execute sql script info.
for exmple.
sql = 'isql -S '+server +' -d '+dbname+' -U '+us+' -P '+pwd+' -i
"'+path+'" -o "'+path+'.log'+'"'



??????:Xns981C8213D31BYazorman@127.0.0.1...
Show quoteHide quote

random select a row based a weight column.
Timeout expire
Optimize this query
How can I insert a new field between existing field?
store results over network