|
I have an app that connects to a MySQL DB on a site that doesn't have SSL. Is there a way to create a secure connection so query strings and passwords aren't vulnerable?
Maybe encrypt on the user side and descrypt on the server side, but how should I set up the relay?
Any help is appreciated!
RABB17
"Even in my dreams I see the flashing of my cursor."
|
|
|
|
|
I have created a report in SRS 2000 that prompts for a value before running the report. It requires the 'full name' for the report to produce data.
Is there a way to allow use of a wildcard in this prompt? I have tried several methods with no results.
Thank you,
Karen
Karen Turner
|
|
|
|
|
I am trying to fill a DataTable with data from sql databae by using Background worker but it throws an exeption (calling it from the main thread works fine). I have read that BackgroundWorker can be used for database operations but can't find any examples. Here is the code:
Dim conn As SqlConnection = _
New SqlConnection(connectionString)
Dim command As New SqlCommand(cmd, conn)
Dim adapter As SqlDataAdapter = New SqlDataAdapter()
adapter.SelectCommand = command
Dim table As New System.Data.DataTable
table.Locale = System.Globalization.CultureInfo.InvariantCulture
adapter.Fill(table) ' the exeption is thrown here
What should I do? Please help.
--Nikola--
modified 7-Dec-20 21:01pm.
|
|
|
|
|
Please post the type and message of the thrown exception.
|
|
|
|
|
System.Data.SqlClient.SqlException was unhandled by user code
Class=16
ErrorCode=-2146232060
LineNumber=1
Message="Could not locate entry in sysdatabases for database 'System'. No entry found with that name. Make sure that the name is entered correctly."
And I'm sure that there is no problem with the SQL because it works fine when I call it from the main thread (but in that case my application is frozen untill it reads data and I'm trying to avoid that).
The same thing happens when I use SqlDataReader. command.ExecuteReader() throws the same exeption.
--Nikola--
-- modified at 6:22 Friday 19th May, 2006
modified 7-Dec-20 21:01pm.
|
|
|
|
|
If the exception is something like "Cross thread UI operations are not allowed", it means that you are trying to update the UI (directly or indirectly) from the background worker thread. If that's the exception you're getting, use Invoke or BeginInvoke[^] to do the update from the UI thread.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
I am not updating UI. All I'm doing is creating SqlConnection, SqlCommand and DataTable and filling DataTable with adapter.Fill(table)
The same thing happens when I use SqlDataReader. command.ExecuteReader() throws the same exeption.
modified 7-Dec-20 21:01pm.
|
|
|
|
|
In VC 6.0 you can create/ generate MakeFile of your project, but it seems
this option is not there in VSIDE .NET 2003. Anybody know how to create the
makefile of your project or solution ?
|
|
|
|
|
|
I am using a Windows TextBox control, and I need to be able to programmatically scroll the contents. There doesn't seem to be any public methods in the TextBox class for doing this. I need to be able to tell the TextBox to scroll its contents up or down without relying on the user clicking the scrollbar. Is this possible?
TIA
|
|
|
|
|
You could try to use SelectionStart in conjunction with ScrollToCaret but you would have to calculate yourself what index to use.
|
|
|
|
|
Well, I was hoping for some secret trick that might be a little less kludgy. Also, I'm using TextBox, not RichTextBox, and I don't believe TextBox has a ScrollToCaret method. But thank you for your reply. Any other ideas?
|
|
|
|
|
NicHeuser wrote: I don't believe TextBox has a ScrollToCaret method
MSDN[^] says there is one.
|
|
|
|
|
Sorry, you're right--I missed it the first time. I tried this, and it does work, but the big challenge, as you suggested, is calculating where to put the caret to get the desired behavior. Thanks for the help.
|
|
|
|
|
how can i put my project folder in repository on server to access the project by all team member. i wanna use cvs for it...but how ?
I dont know that where should i put my folder in server
Dinesh Sharma
|
|
|
|
|
By asking the appropriate forum.
You know you're a Land Rover owner when the best route from point A to point B is through the mud.
Ed
|
|
|
|
|
I have created an application using asynchronous sockets that starts a local server, allows clients to connect to it. When the server starts, it creates an inherited version of my client class to create a connection to a unix server. There is no real difference in the connection, only the way data is handled when it comes back. When the server starts, the unix client creates a connection through to the remote point, sends a message and receives a response. This works fine. When my windows based client connects to the server, it sends a message on connect as well, the server receives this and then forwards a message to the unix client to tell it to forward a wakeup to the unix system. On receipt of the message back from unix acknowledging this, the server crashes with the following message.
System.InvalidOperationException was unhandled
Message="The Undo operation encountered a context that is different from what was applied in the corresponding Set operation. The possible cause is that a context was Set on the thread and not reverted(undone)."
Source="mscorlib"
StackTrace:
at System.Threading.SynchronizationContextSwitcher.Undo()
at System.Threading.ExecutionContextSwitcher.Undo()
at System.Threading.ExecutionContext.runFinallyCode(Object userData, Boolean exceptionThrown)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteBackoutCodeHelper(Object backoutCode, Object userData, Boolean exceptionThrown)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Net.ContextAwareResult.Complete(IntPtr userToken)
at System.Net.LazyAsyncResult.ProtectedInvokeCallback(Object result, IntPtr userToken)
at System.Net.Sockets.BaseOverlappedAsyncResult.CompletionPortCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)
at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)
There is no indication of whereabouts in the program this happens, and the only other references to this problem I can find (forums.microsoft.com/msdn) have either no solution, or the solution makes no sense within my application.
In my send method, I set a waiting state, and within that loop I have an event in which I have Application.DoEvents( ) (I found it hangs otherwise and won't output anything until things have finished) removing that doesn't fix things. And any interaction I am having with the GUI at all I have wrapped in invoke (i only output log data to a richtext box). I'm at a loss as to how to proceed with this problem, and I don't know what I can change to fix it!
Any help appreciated.
|
|
|
|
|
For the reference of anybody who is interested the solution lay in the following;
public void ConnectionServer_OnWaitEvent(object sender, EventArgs args)
{
Application.DoEvents( );
}
became;
public delegate void ApplicationWaitEvent( );
public void ConnectionServer_OnWaitEvent(object sender, EventArgs args)
{
this.Invoke( new ApplicationWaitEvent( ApplicationWait));
}
public void ApplicationWait( )
{
Application.DoEvents( );
}
Basically, I have a wait event in my send function that needs Application.DoEvents( ) to give it the chance to display replies properly. I had tried removing it but this didn't fix my problem, unless I compiled wrong and thought my fix had been applied. Anyway, the answer was to use a delegate and invoke it from within my form. Application now runs ok.
|
|
|
|
|
Hi Guys,
I had an idea to help my asp.net development. The idea was to write a windows form which emulated the "watch" window in Visual Studio so that i may look at the current state (or past state if they have been disposed of) of the object i created in the code behind... All without using the debugger, which i loathe..
I have written the object viewer, just need the app :s
Is this possible? If so where should i start looking? Remoting is my first guess but im unsure..
Many Thanks,
matt
|
|
|
|
|
hi guys, i m recently facing questions in interview about differences b/w the .net series releases that is how or where can i find comparison b/w the improvements and changes from .NET 1.0 to 1.1 to 2.0
|
|
|
|
|
The size of the answer to that question is proportional to the size of the .NET framework...HUGE! 
There are many improvements to most aspects of the .NET framework between v1.1 and v2.0. What you should do is pick a sub-system (such as ASP.NET, or ADO.NET) and go check out on Microsoft's web site what they have to say about how 2.0 improves that sub-system. They have plenty of info about why you should upgrade to the latest and greatest, etc.
Josh
|
|
|
|
|
Hi there.
I read on MSDN that one can use a certificate associated with a party to encrypt messages to that party. But in the Certificate tab in the Party Properties dialog it says "Signature certificate" (indicating that the specified certificate will be used to sign messages, not to encrypt them). It would have been nice if this certificate overrides the one specified on the port. Am I missing something here?
*Is there a way to dynamically set an encryption certificate on a Send Port (not by programming to Biztalk Explorer OM) through an orchestration by passing parameters to a shape of some sort?
*Or do i have to create a new port for each Party, and on that port specify the encryption certificate for that specific Party?
The results should be like a dynamic send port that has a dynamic "address" AND replaceble/dynamic certificates. Is this possible?
|
|
|
|
|
Hi! Can someone with a good understanding of .NET security explain to me why assemblies on a network share gets the "Zone - Internet" classification? I thought network shares were supposed to be "LocalIntranet". Used to work before we reorganized our Windows domain.
This is the output I get from "caspol -resolvegroups test.exe":
Microsoft (R) .NET Framework CasPol 1.1.4322.573
Copyright (C) Microsoft Corporation 1998-2002. All rights reserved.
Level = Enterprise
Code Groups:
1. All code: FullTrust
Level = Machine
Code Groups:
1. All code: Nothing
1.3. Zone - Internet: Internet
Level = User
Code Groups:
1. All code: FullTrust
Success
Thanks.
/Per Erik Stendahl
|
|
|
|
|
Dear Experts
I have an Act.X in my source code,showing a map and without any routine for print it context.I guess I can print its context using Draw method and passing a printer device context to it.But I can't find any way to take a printer device context else using win32 API.Is there any way in .NET framework and managed code to do it?
Any help will be highly appreciated
Regards
Reza
|
|
|
|
|
Hello
I have created a solution wherein i hv used control components and added my code to it. The dll of these components were prepared and hv already been used in my solution and forms hv been created. But now i hv changed one of the components properties (the font) and thereby the dll has been changed.But now i want to update all the controls in all the forms. How can i solve this problem?
Please let me know....
Thanking You
Nithya
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
