|
|
Hi all,
I have deploy a window application and install in admistrator account which can access by all user. I am successful install it and run in limited account. But the exception occure when need to delete data in database (ms access using oledb connection). Note that, it is no any exception if this application run under adminstrator account. Below is the exception details:
************** Exception Text **************
System.Data.OleDb.OleDbException: Could not delete from specified tables.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at TimewayGeneratorRev2.SQLConnection.DeleteSQL()
at TimewayGeneratorRev2.FrmNew.CreateNewProgram()
at TimewayGeneratorRev2.FrmNew.btnsave_new_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
TimewayGeneratorRev2
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
ChartUserControl
Assembly Version: 1.0.3056.42194
Win32 Version: 1.0.0.0
CodeBase: file:----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:----------------------------------------
any idea or any solutions are welcome
regards
cocoonwls
|
|
|
|
|
Obviously, your limited account does not have permission to do this. Are you logging into the DB using a username/password, or windows integrated security ? If the latter, then changing your user could well change what the DB allows.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Christian Graus
Christian Graus wrote: Are you logging into the DB using a username/password
I don't think so, below is my connection string
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Userprogram.mdb"
Christian Graus wrote: or windows integrated security
I have no idea whether i am using any windows integrated security or not.By the way,how can i to ensure it?
Christian Graus wrote: changing your user could well change what the DB allows
How can i do that?Please guide me thought it. Thanks 
modified on Saturday, May 17, 2008 9:50 PM
|
|
|
|
|
The error originates in the Access (JET) database, when it tries to modify (delete) data. Assuming your database doesn't use the strange security mechanisms available in Access (using SYSTEM.MDB and so on for user names and passwords), I would guess that either:
a) The regular user doesn't have modify permissions on the MDB file.
b) The regular user doesn't have modify permissions on the LDB file, or sufficient permissions to create one when it doesn't exist.
This would make the database readonly for non-administrators, meaning that all attempts to modify data will throw exceptions.
If possible, you should look at using SQL Server 2005 Express Edition instead (sqlexpress for short). The Access JET database engine has been living under threat of extinction for a decade or so by now and has a number of drawbacks (one of them being that no user can modify any data in the database unless they have sufficient permissions to actually delete the entire database file if they feel like it). The learning curve for shipping it with your app (making it install silently and getting your initial database installed) is kind of steep but the job is simple once you get a hang of it (and there are a lot of good articles on it).
--
Peter
|
|
|
|
|
Hi PeterTheSwede,
Thanks for your suggestion.I am agree with your point.
PeterTheSwede wrote: using SQL Server 2005 Express Edition instead (sqlexpress for short)
Currently,i can't shift to SQLExpress now.But i will make it for my next version of application.
PeterTheSwede wrote: The learning curve for shipping it with your app (making it install silently and getting your initial database installed) is kind of steep but the job is simple once you get a hang of it (and there are a lot of good articles on it).
Can you please guide me to solve this out or the related articles?
Thanks in advance
cocoonwls
modified on Saturday, May 17, 2008 9:49 PM
|
|
|
|
|
Hi,
I suggest you start here:
http://www.microsoft.com/sql/editions/express/default.mspx[^]
And... I was writing too fast. The old version (MSDE, based on SQL Server 2000) was a bit bitchy (command-line installer with a lot of options, tricky to invoke during your own install - especially tricky to detect failures). Entirely new scenario with the 2005 version (SQL Server Express). And to be honest, I've never integrated that into a setup (as I develop mainly custom apps, I usually install the software myself) - the SQL Server Express setup can be run interactively and is self-explanatory.
Also, you need to register to redistribute and I haven't gotten around to that... 
--
Peter
|
|
|
|
|
If you have a strong named assembly and it is hacked using ILDASM and ILASM the application will fail strong name checking, but you can flag the assembly for skipping strong name validation. My question can you in the application code force the Dotnet framework to do a validation check and then take the necessary acton based on the result.
Thank you in advance
williamt
|
|
|
|
|
I want to capture keyboard input and display it in a textbox the same way that, in Excel when you type into a cell, your text appears in the box at the top. I've tried the following code with weird results. The problem is that the input string variable accumulates KeyChar input in odd ways. The correct input is parsed; it's just not displaying properly in textBox1. As you can see, I've tried everything I can think of to clear out both 'input' and textBox1 with no luck.
public partial class Form1 : Form<br />
{<br />
string input;<br />
public Form1()<br />
{<br />
InitializeComponent();<br />
}<br />
void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)<br />
{<br />
dataGridView1.EditingControl.KeyPress += new KeyPressEventHandler(EditingControl_KeyPress);<br />
dataGridView1.EditingControl.KeyDown += new KeyEventHandler(EditingControl_KeyDown);<br />
e.Control.KeyPress += new KeyPressEventHandler(dataGridView1_KeyPress);<br />
}<br />
void EditingControl_KeyPress(object sender, KeyPressEventArgs e)<br />
{<br />
input += e.KeyChar.ToString();<br />
textBox1.Text = input;<br />
}<br />
private void dataGridView1_CellParsing(object sender, DataGridViewCellParsingEventArgs e)<br />
{<br />
input = String.Empty;<br />
textBox1.Text = input;<br />
textBox1.Text = e.Value.ToString();<br />
}<br />
}
|
|
|
|
|
Not sure what you actually do there.
What would be the need of the first assignment, when you have the second one?
textBox1.Text = input;
textBox1.Text = e.Value.ToString();
Further comment: in case you want to consume a key, see here[^].
SkyWalker
|
|
|
|
|
You're right, those two lines are redundant. I was just trying various things and that's a relic. The purpose of all of this is simply to replicate keystrokes in textBox1 so that the keystrokes appear in the dataGridView1 cell simultaneously with textBox1. That is happening -- sort of -- but there's an unwanted accumulation of keystrokes appearing in textBox1. Try it and you'll see what I mean. I appreciate your comments.
|
|
|
|
|
hello
i have to read content of a fild in a record in datagrid , but i can not. 
bizhan mp
|
|
|
|
|
Why not ? How about myGrid.Rows[index][colIndex] ???
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Can anyone here recommend a quality free, easy-to-use CHM editor???
|
|
|
|
|
I don't believe that you can edit with the application, but to create CHM files you can use HTML Workshop from Microsoft.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
Yeah - I've tried that one. It's not very easy to use.
There must be another free CHM editor that is easier to use.
|
|
|
|
|
It is from Microsoft. What do you expect?
I am not aware of any other free CHM editors. You would have to google the subject.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
Hey everyone,
I've got a short question whichs answer hopefully is as short too
I'd like to "concatenate" two integer values without casting them to strings. Let me illustrate what I want to do by showing you a code snippet:
int x = 1, y = 2;
string xyStr = x.ToString() + y.ToString();
int xy = int.Parse(xyStr);
And now the question:
Does someone know a possibilty to do this without casting the values to a string first?
Thank you in advance,
mik
|
|
|
|
|
Yep
xy = (x * 10 ^ z) + y
You need to find out how many to-the-power (z) you will need from y.
Edit: not x ^ z but x * 10 ^ z
modified on Friday, May 16, 2008 1:34 PM
|
|
|
|
|
And that can be done by counting the number of significant digits (places) after or before the decimal (depending on which way you're going).
"Every time Lotus Notes starts up, somewhere a puppy, a kitten, a lamb, and a baby seal are killed. Lotus Notes is a conspiracy by the forces of Satan to drive us over the brink into madness. The CRC-32 for each file in the installation includes the numbers 666." Gary Wheeler
"You're an idiot." John Simmons, THE Outlaw programmer
"I realised that all of my best anecdotes started with "So there we were, pissed". Pete O'Hanlon
|
|
|
|
|
I think it should be possible with some bitshifting, but this is a simple solution:
public int ConcatInts(int x, int y)
{
return (x * ((int)Math.Pow(10, NumDecs(y)))) + y;
}
public int NumDecs(int x)
{
int result = 1;
while (x >= 10)
{
x /= 10;
result++;
}
return result;
}
or, by using the logarithm with base 10:
public int ConcatInts(int x, int y)
{
return x * (int)(Math.Pow(10, (int)Math.Log10(y)+1)) + y;
}
Some time comparisons, with the string method being the slowest (100%, but might be optimized a bit using a StringBuilder):
Log: 31,62%
Loop: 30,57%
for 100000000 runs each.
regards
modified on Friday, May 16, 2008 2:15 PM
modified 12-Sep-18 21:01pm.
|
|
|
|
|
That's pretty easy, actually even easier than I first though:
int x = 1, y = 2;
int m = 10;
while (m <= y) m *= 10;
int xy = x * m + y;
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Should have been a Friday programming quiz.
|
|
|
|
|
hy everyone!
does anyone of you know which encoding has to be used to handle files in windows-1252 correctly via streaming, so no characters are lost or replaced by non printable signs?
thanks!
stephan.
|
|
|
|
|
Stephan,
You can get the 1252 encoder like this.
Encoding coder = Encoding.GetEncoding(1252);
AlanN
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
