|
I have a query regarding remote SQL Server Connection in VB.Net . Let me exlain you the scenario. A company has two branches in two different cities. Let it be CityA and CityB. CityA holds the Server Machine on which a SQL Server is installed and running. CityB wants to connect to SQL Server running at CityA. But make sure that both of these use only internet to communicate. Moreover, SQL Server is not running on a web server or intranet scenario. Please help !!!
|
|
|
|
|
This has nothing to do with VB.NET, but everything to do with your companies network infrastructure. You never, Never, NEVER expose an SQL Server directly to the Internet. You'll have a smoking heap of a server in about a day when every little script-kiddie recognizes what it is.
You always put these servers behind as much security as possible. If you can't get your own T1 line between sites, you'll have to use the Internet and setup virtual private networking between sites. This will keep the data going between sites, including SQL Server traffic, secured and hidden from the prying eyes of the Internet.
Setting up the hardware and software for a VPN connection is way beyond the scope of these forums.
|
|
|
|
|
1. Disable firewall
2. Publish login detail
3. Everybody here will help you
|
|
|
|
|
Hi,
I am working on ASP application and I want to send a scheduled email by daily. Can any body help me to sort out the issue.
Thank
S.ABC
|
|
|
|
|
You have posted into the wrong forum, but to answer your question, you can't. You could add a task to your windows scheduler the executes daily that launches an asp page which in turn sets the email to you, or write a windows service and install in on your server.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
I often see postings in this forum, where it is stated "I am developing in VB6". Why are they still developing in VB6?
It seems to me that any new developments should now be done in VB2005/8 and if it is a new or replacement module/class for a legacy VB6 program, then still write it in VB.NET and make it COM visible and reference it from the VB6 app.
Am I missing something? Are my assumption wrong?
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Steven J Jowett wrote: "I am developing in VB6". Why are they still developing in VB6?
Possibly they have no choice. I see often job postings where companies are asking for VB6 skills (I even got one yesterday). So until companies give it up people will still need to ask questions on forums.
|
|
|
|
|
Colin Angus Mackay wrote: companies are asking for VB6 skills
So the employers need to be educated in the benefits of ceasing development in vb6 and migrating to .NET
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Companies have large code-bases written in VB6. They see the short-term expense of rewriting that code in VB.NET and don't migrate because of it. Though, they also ignore the ever increasing costs of maintain legacy code too.
|
|
|
|
|
Dave Kreskowiak wrote: They see the short-term expense of rewriting that code in VB.NET and don't migrate because of it. Though, they also ignore the ever increasing costs of maintain legacy code too.
You would think the "drunken lemurs" ( errr, managers ) would look at the short term cost of porting to VB.NET be more cost effective than maintaining the VB6...
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Steven J Jowett wrote: So the employers need to be educated in the benefits of ceasing development in vb6 and migrating to .NET
Wish it is that simple. 
Cost, risk, re-training, disruption to business, to name a few....
|
|
|
|
|
For how long should you flog a dead horse?
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Until the shareholders revolt and lynch the CEO.
|
|
|
|
|
Until the guys who's paying for the system are convinced and willing to redo the system...
Look, we have a system, written in Delphi 5, each sub module is one exe, and there are hundreds of them, from A01 to G99, that are used by a few branches in different country, each having different business logic, and as such each branches are having the similar but not the same A01.exe-G99.exe, same for the database, enhancement is done by copy the exe and change from there, every queries are embedded in the form, and you must look at each form to look at the SQL statement, the way of passing variable is to make in-memory temp tables, then call SQL to retrieve the values from the temp tables, the database field are all user defined type for no apparent reason and benefit, date is stored as integer, money is stored as integer after mutiplied by 10000, rates are stored as integer after multiplied by 100, 10000 or 1000000 depends on the mood of the programmer, language support on a platform that doesn't support multi-languages, functions are duplicated all over the places...
Simply put, the style of the system was done in the fashion in the dBase era.
I would make a new system in a heartbeat, if I have the say. But until the people who's paying for the system are ready to remake that pile of doo-doo, the system needs to be maintained as it is.
Good thing I am not the one who's maintaining it....
|
|
|
|
|
darkelv wrote: Good thing I am not the one who's maintaining it....
If I was the one, I'd quit.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Even if you quit, someone else would be hired to maintain it.
Systems are usually replaced when it can no longer support the business, or the cost of maintaining it is way too high. Rarely it's due to "it's written in horrible language".
|
|
|
|
|
Only the businesses can estimate that. I was maintaining a 16-bit VC++ 1.5 app. only 4 years ago. How long ago was that a dead product?
Kevin
|
|
|
|
|
It is not always easy to rewrite an application in such a fashion as to behave identically to an old one. If end users have grown accustomed to all sorts of little nuances in an old application, it may be difficult to ensure that all such nuances come through in a rewrite, especially if the earlier inclusion of such nuances was not done systematically but rather on an ad-hoc basis.
When doing such a rewrite, it can be hard to avoid a sort of 'limbo', where customers whose system works are reluctant to switch to a comparatively untested new system. Without customer assistance in testing the new system, it may be difficult to get it to the point that customers are happy switching to it.
|
|
|
|
|
I used the crystal report wizard to connect a Ms SQL Server. During the procedure the wizard requested for the username and password to the database.
However, when i run the application and want to pull up a report the page request for the database password.
What am i doing wrong?
JESA
|
|
|
|
|
How did you connect to the database when you developed the code?? If you used Trusted Connection or Windows Authentication, then that connection was made using your windows ID. If this is an ASP.NET app, the code is no longer running under your ID, but is using the ASPNET account. Since the ASPNET account isn't trusted by SQL Server, you get the credentials box asking for a valid login.
It could be other things too, but this is a common problem with new people using SQL Server.
|
|
|
|
|
hello,
how do i indent XML using DOM...
i have a XML but it is not properly Indented. what should i do to indent it....
thankx in advance
koolprasad2003 
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
There is no formatting in the DOM. You only format the XML when it's written to a stream using the XmlTextWriter class. A quick'n'dirty sample:
Public Shared Function GetXmlDocumentAsString(ByVal document As XmlDocument) As String
Using ms As New MemoryStream()
Dim xtw As New XmlTextWriter(mw, Encoding.UTF8)
With xtw
.Formatting = Formatting.Indented
.Indentation = 4
.IndentChar = " "c
End With
document.WriteContentTo(xtw)
xtw.Flush()
Dim textBytes() As Byte = ms.ToArray()
Return Encoding.UTF8.GetString(textBytes)
End Using
End Function
|
|
|
|
|
I have a calculator program and I would like to be able to use the key pad to enter the numbers and perform the calculations, such as adding, and having the enter key be the equals key. Would some point me in the direction of how to accomplish this? This is my current code:
Public Class calcFRM
Dim num, ans As Double
Dim oper1, oper2 As Integer
Dim oper3 As String
Private Sub num0_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num0.Click
num = num & 0
display.Text = num
End Sub
Private Sub num1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num1.Click
num = num & 1
display.Text = num
End Sub
Private Sub num2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num2.Click
num = num & 2
display.Text = num
End Sub
Private Sub num3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num3.Click
num = num & 3
display.Text = num
End Sub
Private Sub num4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num4.Click
num = num & 4
display.Text = num
End Sub
Private Sub num5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num5.Click
num = num & 5
display.Text = num
End Sub
Private Sub num6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num6.Click
num = num & 6
display.Text = num
End Sub
Private Sub num7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num7.Click
num = num & 7
display.Text = num
End Sub
Private Sub num8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num8.Click
num = num & 8
display.Text = num
End Sub
Private Sub num9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles num9.Click
num = num & 9
display.Text = num
End Sub
Private Sub dot_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dot.Click
MsgBox(" not coded")
End Sub
Private Sub eql_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles eql.Click
If oper3 = "+" Then
oper2 = Val(display.Text)
display.Text = oper1 + oper2
ElseIf oper3 = "-" Then
oper2 = Val(display.Text)
display.Text = oper1 - oper2
ElseIf oper3 = "*" Then
oper2 = Val(display.Text)
display.Text = oper1 * oper2
ElseIf oper3 = "/" Then
oper2 = Val(display.Text)
display.Text = oper1 / oper2
End If
End Sub
Private Sub div_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles div.Click
oper3 = "/"
oper1 = Val(display.Text)
display.Clear()
display.Text = ans
num = 0
End Sub
Private Sub multi_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles multi.Click
oper3 = "*"
oper1 = Val(display.Text)
display.Clear()
display.Text = ans
num = 0
End Sub
Private Sub subt_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles subt.Click
oper3 = "-"
oper1 = Val(display.Text)
display.Clear()
display.Text = ans
num = 0
End Sub
Private Sub add_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles add.Click
oper3 = "+"
oper1 = Val(display.Text)
display.Clear()
display.Text = ans
num = 0
End Sub
Private Sub del_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles del.Click
display.Clear()
ans = 0
num = 0
End Sub
Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click
MsgBox("This button currently has no function")
End Sub
Private Sub Button10_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button10.Click
MsgBox("This button currently has no function")
End Sub
End Class
Thank you
|
|
|
|
|
Handle the keypress event on the form and check the value of the key pressed, then call your events for the different buttons based on the key pressed.
Christian Graus - Microsoft MVP - C++
"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 to all,
I want to show the contents of a cell of datagridview when i click on
that cell to text box
How i can able to achive it????????
Please Help.
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
