|
How can I use the CreateProcessAsUser or LogonUser when staring the process:
Dim ps As New System.Diagnostics.Process
ps.StartInfo.UseShellExecute = False
ps.StartInfo.Domain = Domain
ps.StartInfo.UserName = UserName
Dim pword As New System.Security.SecureString()
For Each c As Char In Password
pword.AppendChar(c)
Next
ps.StartInfo.Password = pword
ps.StartInfo.LoadUserProfile = False
ps.StartInfo.WorkingDirectory = ApplicationWorkingDir
ps.StartInfo.FileName = "cmd.exe"
ps.StartInfo.Verb = "runas"
If BatchSize = String.Empty Then
ps.StartInfo.Arguments = "/c bcp " + DbTable + " in " + SourceFile + " -m " + MaxErrors + " -f " & FMTFile & " -e " & ErrorFile & " -o " & LogFile & " -S " & ServerName & " -T "
Else
ps.StartInfo.Arguments = "/c bcp " + DbTable + " in " + SourceFile + " -m " + MaxErrors + " -f " & FMTFile & " -b" & BatchSize & " -e " & ErrorFile & " -o " & LogFile & " -S " & ServerName & " -T"
End If
ps.StartInfo.WindowStyle = ProcessWindowStyle.Hidden
ps.Start()
ps.WaitForExit()
|
|
|
|
|
What kind of app are you writing and where is this process being started?
Is this a Windows Forms app, console app, WPF, Windows Service, ASP.NET, ... ??
Is the process being created locally, meaning on the same machine as the code you've shown or is it being created on a remote machine?
....and you STILL do not have to run CMD and do not need the "RunAs" verb line. It's nice to see you don't listen to the answers you've been given.
|
|
|
|
|
|
it's a console application running on a server from a scheduler.
I need to start a process as specific user with access to cmd.exe and pass userID in my process
|
|
|
|
|
byka wrote: it's a console application running on a server from a scheduler. The default task scheduler[^] contains options to run your app under another account. So, I assume you are not using that task-scheduler?
byka wrote: I need to start a process as specific user with access to cmd.exe and pass
userID in my process You mean that it should display a console-window where the user can execute additional commands?
You don't need to start CMD just to execute an application that you would normally start using the CMD-prompt.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Maybe this explanation will help :
scheduler running under user account with no permission to C: drive.
Application account should have some permission to C:drive in order to access cmd.exe
I need to add code ( CreateProcessAsUser or LogonUser) for application user in order to call cmd.exe
|
|
|
|
|
OK, this is a bit better but there's still lots of detail missing.
You're writing the scheduler app? Is this written as a standard console or Windows Forms application or is it a service?
Does the application this scheduler is launching have to show up as a window that the user can type in?
Why must you call CMD instead of just launching BCP directly?
|
|
|
|
|
You're writing the scheduler app? - Yes
Is this written as a standard console or Windows Forms application or is it a service? - Consolse application
Does the application this scheduler is launching have to show up as a window that the user can type in? - No
Why must you call CMD instead of just launching BCP directly?- you mean call bcp.exe instead of cmd?
|
|
|
|
|
byka wrote: you mean call bcp.exe instead of cmd?
Yes
|
|
|
|
|
|
That's not an answer to the question.
WHY do you think you must call CMD instead of just launching BCP directly?
|
|
|
|
|
byka wrote: Maybe this explanation will help An answer to the question would have helped too. Are you or are you not using the default task scheduler? If yes, simply define the account you want to run under in the settings.
byka wrote: scheduler running under user account with no permission to C: drive.
Application account should have some permission to C:drive in order to access
cmd.exe ..sounds safer to give the user the permissions he/she actually needs. The user you are impersonating prolly has some more priviliges than just "cmd.exe".
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
If you're using the default task scheduler, supply credentials that have appropriate permissions.
If you've baked your own task scheduler, run it as a service, using credentials that have appropriate permissions.
Either way, the wheel, axle, transmission, and engine have already been invented. You just need to paint the car.
|
|
|
|
|
Hello! I'm using vb.net in SharpDevelop 4.4. I tryed import AvalonEdit(WPF Text Editor) in my project. But i can not do.
Error Message is :"The assembly ISHarpCode.AvalonEdit, Verison=4.4.42.9749 Culture=neutral, Publickey Token=9cc39be672370310 does not contain any components."
Thank you for help.
|
|
|
|
|
That suggests that the file is corrupt. Try downloading it again, or check the AvalonEdit website.
|
|
|
|
|
I am running batch apps on Windows 2012 server and getting the following error:
MESSAGE: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
My connection string:
<value> Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\File.xls; Extended Properties="Excel 12.0 Xml;HDR=YES";
Excel 2010 installed on a server
what am I missing?
modified 2-Feb-16 11:29am.
|
|
|
|
|
|
On a server I have Excel 10 installed. what do I need to change in my connection in order to use it?
|
|
|
|
|
|
Microsoft Office Professional Plus 2010
|
|
|
|
|
Then you need to install the ACE driver as suggested earlier.
|
|
|
|
|
|
For Example :
From Date : 01.01.2016 to Date : 29.02.2016.This is two month date value. my problem is how to lock one month Dates between value only.
I need value is
From Date : 01.01.2016 to Date : 31.01.2016. Jan Only.So, how to lock the dates in text box?
|
|
|
|
|
Set the ReadOnly property of the TextBoxes to True?
You're question is really vague so we really don't know what you're talking about.
|
|
|
|
|
If you're looking to clamp the date range to be single month values, a simple extension method will return the last date of a month from the start date:
public static DateTime ToLastDayInMonth(this DateTime date)
{
return new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month));
}
This space for rent
|
|
|
|