|
Thayhor wrote: Table C suppose to have list of book not borrowed per day.
Why would you put that data in a table? You are only causing redundancy in the database.
Thayhor wrote: where BookID) Not in (
You can't have one operand (BookID) inside the parenthesis and the operator (Not in) and the other operand (Select...) outside the parenthesis.
Thayhor wrote: between ' " & TextBox1.Text & "' and ' " & TextBox2.Text & "'
You should use parameterised queries. Your query is wide open for SQL injection attacks.
|
|
|
|
|
I got this old application that needs to be deployed locally.
I am converting it to a network-enabled version.
I finished the SQL Server conversion part.
Now I am going to do the network-enabling part.
I mostly worked with web apps.
So, I'll really appreciate if anyone can point me to the right direction for this.
Thanks.
|
|
|
|
|
Noone can help you at all unless you explain what you mean by "network enabled"?? This is such a generic term that it can mean anything...
|
|
|
|
|
Sorry about the confusion.
I basically meant the application will run on the server only, and will be available on the network. Therefore others will be able to use it from their computers, while its running in the server.
Thanks.
|
|
|
|
|
OK, so how are the clients going to use the app if it's "running on the server"?? Obviously, the app has to expose some kind of interface, either UI-based through an existing technology, like a web browser, or through an API that another application uses, such as a Windows Forms app.
Or, did you mean that the .EXE files are going to sit on the server and the clients are going to launch them from the shared location?? In which case, you're going to need to read up on Code Access Security because code running from any remote source, including authenticated file shares, is not trusted by the .NET CLR by default and will run in a heavily restricted sandbox.
|
|
|
|
|
Hi Dave,
Yes..we want to use the the exe files deployed on the server, because otherwise it will have to be completely rebuild.
Could you please show me the way how to set up the code access security?
I have my assembly set up for AllowPartiallyTrustedCallers, but its not helping.
Thanks.
Ekjon
|
|
|
|
|
|
Thanks so much Dave.
I started reading Mike Downen's and Shawn Farka's articles. Now I got a handful from you. Please pray for me so I don't die from over-eating.
Me
|
|
|
|
|
I am writing an interface to a Panasonic KX-TDA telephone system using Winsock.
I can connect to the PBX and it accepts my connection properly using TCP, then I can send the initial connect string as follows:
Mtosend = Chr$(&H0) & Chr$(&H25) & Chr$(&H60) & Chr$(&H23) & Chr$(&H80) & Chr$(&H2) & Chr$(&H7) & Chr$(&H80) & Chr$(&HA1) & Chr$(&H7) & Chr$(&H6) & Chr$(&H5) & Chr$(&H2B) & Chr$(&HC) & Chr$(&H0) & Chr$(&H81) & Chr$(&H5A) & Chr$(&HBE) & Chr$(&H14) & Chr$(&H28) & Chr$(&H12) & Chr$(&H6) & Chr$(&H7) & Chr$(&H2B) & Chr$(&HC) & Chr$(&H0) & Chr$(&H82) & Chr$(&H1D) & Chr$(&H81) & Chr$(&H48) & Chr$(&HA0) & Chr$(&H7) & Chr$(&HA0) & Chr$(&H5) & Chr$(&H3) & Chr$(&H3) & Chr$(&H0) & Chr$(&H8) & Chr$(&H0)
Winsock1.SendData Mtosend
When I monitor the connection using WireShark it appears that the PBX accepts the string properly and sends a reply back, I get 51 bytes of data back, but if I read it as a string it simply shows as a "NULL" string. If I read it into a byte array, using the following code I only get zero's:
Private Sub Winsock1_DataArrival(ByVal bytesTotal As Long)
Dim DL As String
Dim DTS As String
Dim byteData(256) As Byte
Dim i As Integer
DL = CStr(bytesTotal)
DTS = ""
Winsock1.GetData byteData(), vbArray + vbByte, Val(Trim(DL))
For i = 0 To bytesTotal - 1
DTS = DTS & " " & Right$(("00" & Hex$(byteData(i))), 2)
Next
MsgBox "TCP Rx: " & DTS & " (bytes=" & DL & ")"
Exit Sub
But when I look at the trace in WireShark, the PBX did not send only zero's it sent a valid reply, The PBX returned string started the data with a null, but the rest was valid data. What am I doing wrong?
Please help.
|
|
|
|
|
Hi all,
when I try to send a mil from my application an exception is thrown...
" Transaction failed. The server response was: sorry, the sender name and auth login doesn't coinside (#5.7.1) "
What could be the reason for this?
Thanking you in advance...
Sebastian T Xavier
|
|
|
|
|
Sebastian T Xavier wrote: the sender name and auth login doesn't coinside
Its telling you something here. I suspect you are not authenticated properly for the mail server.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks for the quick reply, actually this code segment was working for a long time. today only i got this exception.
I believe i haven't done any changes in settings
Thanks
Sebastian T Xavier
|
|
|
|
|
It's not your code that changed, it's the mail server you're using.
To increase security and prevent people from sending mail, such as spam, impersonating someone else, the server, apparently, now checks the outgoing sender name against the registered account. If they don't match, the server stops you from sending the email.
The bottom line is you are going to have to get with the people managing the mail server and find out what the requirements are. Then you're going to have to modify your code to fulfill those requirements.
|
|
|
|
|
Thanks for the help, I will investigate on it.
Thanks once again
|
|
|
|
|
Hii
I am working on SOAP Web service. when i try to call web service method then .NET throw the following error...
"Run-time exception thrown : System.Web.Services.Protocols.SoapHeaderException - The Soap request you send was invalid or malformed!"
Please suggest. How can i solve this problem.
Please suggest.
Thanks
~Khatri Mitesh
~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA
|
|
|
|
|
~Khatri Mitesh~ wrote: The Soap request you send was invalid or malformed
Says it all really. Have you stepped into the code and looked at the actual values you are generating?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi all
i use following statement for import drawing related classes
imports System.Drawing
i want to use 2D class but when i type .(after typing imports System.Drawing), then no intelligence is appeared related to 2D. Even when i Forcely type imports System.Drawing.2D, then it give error
how can i resolve this error ? Please suggest
|
|
|
|
|
|
Hi everyone,
I´m programming an application win forms and in some parts of my application I have a strong processing module, and I´ve decided do make a loading screen.
So, i´ve done it:
Private Sub ShowLoading()
Dim frmBlank As New frmBlank
frmBlank.Cursor = Cursors.WaitCursor
frmBlank.Show()
Dim frmLoading As New frmLoading
frmLoading.ShowDialog()
End Sub
Private Sub StartLoadingThread()
thread = New Threading.Thread(AddressOf ShowLoading)
thread.Start()
End Sub
Private Sub StopLoadingThread()
thread.Abort()
End Sub
But, the problems appear, when i abort the thread, the loading form closes, as it have to close, but the whole application minimizes.
I´m using the form in a Class Library, and it start maximized. THe whole think works as it have to work perfectly, but the problem is the application minimize.
Thanks everyone!
-----
LeandroAB
|
|
|
|
|
Why are you show the loading form on a seperate thread? From what you're describing, you wouldn't need any threading at all. Also, why is the "Loading..." form being shown as a dialog?? and I have no idea what frmBlank is for.
From your description, it should be a simple matter of creating and showing a "Loading..." form, doing your work, then destroying the "Loading..." form. Creating forms and show ing in anything other than the UI thread is not a good idea, as you've found out from your weird side-effects.
|
|
|
|
|
Let me try to explain more detailed my problem.
I have a very long process, and I don´t want to lock the screen without a message. So I did a loading form, that has only one label: "Loading..."
When i start the process, the form was displayed, and when the process ends, i have to close the form. Thats the reason that i habve to use a thread, because i have to continue with my process in background.
The frmBlank is only used to stay between the application and the loading form, without its the problem continues ocurring.
When i kill the thread, the forms closes automaticaly, but i´ve tried to close mannualy the form in the thread, and the problems continues ocurring.
I show the form as a dialog, to block the user access to the system during the process.
Thanks for your time.
-----
LeandroAB
|
|
|
|
|
LeandroABorges wrote: When i start the process, the form was displayed, and when the process ends, i have to close the form. Thats the reason that i habve to use a thread, because i have to continue with my process in background.
OK. It's the long-running process that goes on the background thread, not the "Loading..." form.
|
|
|
|
|
But how can i show the loading form, in many different process types without making a form for each process thread?
If i show the form in the thread, the process will stop, because it´s a dialog.
If i show the form where i call the thread, the problema is the same.
How i can tell the form that the process has finished and it can close?
-----
LeandroAB
|
|
|
|
|
LeandroABorges wrote: But how can i show the loading form, in many different process types without making a form for each process thread?
How about a Shared Sub? Call it whenever you launch a thread.
LeandroABorges wrote: If i show the form in the thread, the process will stop, because it´s a dialog.
No, it won't. The long-running process should be in its own thread. That will NOT hang the UI thread, so it's free to redraw itself whenever needed.
LeandroABorges wrote: If i show the form where i call the thread, the problema is the same.
No, it's not.
LeandroABorges wrote: How i can tell the form that the process has finished and it can close?
The "Loading..." form doesn't know anything about the thread process, so it'll have to be destroyed by the form that created it when you code determines that the process is complete. You might want to look into the BackgroundWorker component to help you with this.
|
|
|
|
|
Dave,
Thanks for your help, i´ve decided to do somethink more simple, i´m almost out of time.
I´ve disabled all the form (frm.enabled = false) and make some "Loading" label visible.
Thanks for your time.
-----
LeandroAB
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
