|
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
|
|
|
|
|
- Use a Spinner with a Minimum and Maximimum
- Use a Slider with a Minumum and Maximum
- Use a DatePicker with a Start and End date
- Use a Calendar control with a Start and End date
- ditch the textbox in this case
|
|
|
|
|
i am trying to get an sqlite project c# wpf application working with entity framework so that when i start my application and the sqlite file is missing it would create it. and the schema would come from the context just like entity framework codefirst
this is what i got so far:
my app.config
="1.0"="utf-8"
<configuration>
<configSections>
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>
<system.data>
<DbProviderFactories>
<remove invariant="System.Data.SQLite.EF6" />
<add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
<remove invariant="System.Data.SQLite" />
<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
</DbProviderFactories>
</system.data>
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
<provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
<provider invariantName="System.Data.SQLite" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
</providers>
</entityFramework>
</configuration>
the following is my code for the entity and context. and how i initiate them:(i got them from reading tutorials)
class ChinookContext : DbContext
{
public DbSet Artists { get; set; }
public DbSet Albums { get; set; }
public ChinookContext(string filename)
: base(new SQLiteConnection()
{
ConnectionString =
new SQLiteConnectionStringBuilder() { DataSource = filename, ForeignKeys = true }
.ConnectionString
}, true)
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Conventions
.Remove();
}
}
public class Artist
{
public Artist()
{
Albums = new List();
}
public long ArtistId { get; set; }
public string Name { get; set; }
public virtual ICollection Albums { get; set; }
}
public class Album
{
public long AlbumId { get; set; }
public string Title { get; set; }
public long ArtistId { get; set; }
public virtual Artist Artist { get; set; }
}
the problem with this code is that it keep having the error:
{"SQL logic error or missing database\r\nno such table: Artist"}
and the sqlite file is not being created as well.
does anyone know why and be so kind as to show me how to resolve this?
|
|
|
|
|
I only have very little experience with EF but I think it should look like this in ChinookContext:
public DbSet<Artist> Artists { get; set; }
public DbSet<Album> Albums { get; set; }
Otherwise those properties would have nothing to do with Artist and Album except the plural form of the names 
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
In your ChinookContext class, remove the line you have in the OnModelCreating method. You don't need it.
Also, your DbSet lines are bad. They should be:
public DbSet<Artist> Artists { get; set; }
public DbSet<Albums> Albums { get; set; }
I HIGHLY suggest you don't take all of your information on EF from "some tutorial on the web" because you're missing a SH*T TON of information that these tutorials are not tell you. Pick up this book[^]. It's an older book, covering EF4, but it's better than the newer books out there that were released last year.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
