|
Thanks for your response. Well i do have a web server side and a SQL server side and the problem is that the SQL server can't reach the internet and i'm trying to figure out how to send a email out to me to alert me when a certain process occurs and i can map a drive and both sides work or i can try to view the directory of the alarm path and i supply a username and password and it works great. but when i log off the program can't reach the SQL server from the Web Server and i need to be able to access the SQL server. If you could give me any advice on how to go about this i would appreciate it.
Thanks
ccotton333
|
|
|
|
|
What you said didn't make ANY sense what-so-ever. Try focusing on one topic, it'll be much easier to understand you.
ccotton333 wrote:
Well i do have a web server side and a SQL server side and the problem is that the SQL server can't reach the internet
Are you saying that you have two machines, one IIS and one SQL? Are you saying that you can't see the SQL server from a machine on the Internet?
ccotton333 wrote:
and i'm trying to figure out how to send a email out to me to alert me when a certain process occurs
It's easy enough to send email. Check into the System.Web.Mail namespace. What process that occurs to trigger this depends, well, on what you're monitoring for.
ccotton333 wrote:
i can map a drive and both sides work
What? What sides? What do you mean by work?
ccotton333 wrote:
i can try to view the directory of the alarm path and i supply a username and password and it works great.
I have no idea what you're talking about here.
ccotton333 wrote:
when i log off the program can't reach the SQL server from the Web Server
I take it you have an IIS server on one machine and an SQL server on another machine. What program? Log off? What are you talking about?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
ok basically i have IIS on the webserver and then i have a private network between the SQL server and webserver. the LAN is also on another private lan an and all pcs on that lan can access the internet. so i have this SQL server that cannot reach the internet and i have written two programs one to run on the SQL server and one to run on the webserver that check on the SQL server for the alarm messages. when i am working on the webserver and have established a connection between it and the SQL server(i.e. connect using remote desktop or through the run dialog and enter in the username and password) i can run each program on the machines and they run great but when i set it up to run as a service. it seems to lose the connection between the two servers and doesn't run as it should. any ideas as to what i'm doin wrong?
Thanks,
ccotton333
|
|
|
|
|
That's better! It's perfectly understandable now! See what happens when you slow down, take a deep breath, and use puncuation?
The problem you have is the account that your service is running under on the IIS machine. By default, this is the LocalSystem account, which only has rights to, obviously, the local machine. It doesn't have any rights to network resources since the account is local to the IIS machine.
Now, what you have to do is run your service under an account, just like any other user account, that has the appropriate rights it needs to the IIS box AND, to make this easier, because these two machines are not in the same domain, this exact same account and password must also exist on the SQL box.
Right-click "My Computer", pick Manage, then open Services and Applications in the left pane, then click on Services. Find your service in the right pane, right-click it and pick Properties. Click on the LogOn tab and you'll find where you can change the account that the service runs under. Oh yeah...create the account first, on BOTH machines.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
WHERE (AccountsEntries.Posted = 'No') AND ([References].Date >= @Begin) AND ([References].Date <= @End) GROUP BY AccountsEntries.AccountNo
-----
From my SQLdataadapter wizard (i use wizard to conenct to database), i type part of sql statement above in query builder and i want to insert parameter value to @Begin and @End from VB.code.
How to do it?
|
|
|
|
|
Hi,
I have problem with datagridview - i want to do this: if i click in button, i have show a name selected with this dataview in messageBox , but i don't know how do it ;( I beginner in basic ;( Whose know how make it??
I want get selected name...
btw. sorry for my english 
|
|
|
|
|
can anyone help me correctly validate some textboxes?
Makniteasy
|
|
|
|
|
Hi! I am Vijay Anand. So you have a problem on validating
textboxes. I am a programmer in VB.
There is two type of validation in One type of checking is don't allow the user to type the false values and the another one is check the value while the user leaving the text box. For further info please send me a email at imagicvijay@gmail.com.
Vijay V Anand
|
|
|
|
|
Vijay V Anand wrote:
Hi! I am Vijay Anand.
hi, i'm toxcct
Vijay V Anand wrote:
So you have a problem on validatingtextboxes.
great, what a good reader !
Vijay V Anand wrote:
I am a programmer in VB.
hum, you know, we're all here on that forum supposed to be VB6 and/or VB.NET programmers...
Vijay V Anand wrote:
For further info please send me a email at imagicvijay@gmail.com.
definitely NO !!! 
the principle of the forum is to share ! e-mail a privates, so kill the sharing point. don't do this
ps: when you say so much things while not even answering the question (i say so because i don't see at all in how you help the guy), then, avoid posting...
one last thing... you got my 1
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
well I guess Vijay is looking for some family friends. I am really happy to know that vijay is a Programmer in VB other wise I thought that on this forum we used to discuss JAVA and Unix.
Thanks Vijay you made us clear that atleast we have one VB programmer with us..
|
|
|
|
|
What kind of validation are you performing? Are you working with VB6/VB.NET?
<italic>Work hard, Work effectively.
|
|
|
|
|
|
What kind of validation?
<italic>Work hard, Work effectively.
|
|
|
|
|
Hi! I have this dilema. I have to pull data from DB to Excel. But the deploy machine has Windows 98, so Visual Studio Tools for Office does not work on win 98... any suggestions?
Thanks!!!
Agustín
|
|
|
|
|
Hi,
Im trying to search through an XML file. When it finds the record it needs it then updates a specific field in that record. I have made it find the specified record but do not know how to update it and write it back to file. I am new to XML coding. Any help would be most appreciated.
Dim xpathDoc As XPathDocument
Dim xmlNav As XPathNavigator
Dim xmlNI As XPathNodeIterator
Dim filePath As New OpenFileDialog
filePath.ShowDialog()
xpathDoc = New XPathDocument(filePath.FileName)
xmlNav = xpathDoc.CreateNavigator()
xmlNI = xmlNav.Select("/Message/Pupils/PupilCode")
While (xmlNI.MoveNext())
System.Console.WriteLine(xmlNI.Current.Name + " : " + xmlNI.Current.Value)
If (xmlNI.Current.Value) = "A123981456002" Then
'ONCE ITS FOUND THE RECORD - DISPLAY A MESSAGE
'SELECT THE DIFFERENT FIELD WITHIN THE RECORD
MsgBox("Found")
xmlNav.Select("/Message/Pupils/PupilAge")
'THIS IS WHERE IT NEEDS TO UPDATE IT. NO IDEA HOW TO DO THIS BIT
End If
End While
This may be the wrong way to do it - I'm not sure. I just need it to search for a specific pupil ID and update their age with a specified value. After that it has to write the entire XML file to a new file.
Many thanks.
Chris
|
|
|
|
|
|
I developed a project that generates a xml file form a database and upload it to a webserver. I think it is possible to check the generated xml file having virus or any harmful threat. So i want to trigger the anti virus software to scan that xml file and if no threat was found then upload that file or inform that the file has a virus.
Please any of one help me to accomplish this task, the main thing is the source must be in VB 6.0 :(code.
Vijay V Anand
|
|
|
|
|
You don't have to. With most antivirus software, the file is scanned when written to the hard drive.
Besides, with all the different versions out there, and all the different API's they MIGHT expose, your idea will be a nightmare to implement. There is no generic interface to launch a scan of a file without having to know what anitivirus software is installed.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Virii in XML files? That's strange. XML is a text format, how would it be possible to write virii using it?
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
I am trying to make dialog box that will be popup from my addins in excel.
I want to have that dialog looks like the find and replace dialog. so that
user can select cells and type some character into a cell. Right now I
create
a kinda floating dialog using the following method. however i can only
select
cells but not able to right some characters into a cell.
mlHWnd = FindWindowA("XLMAIN", oHostApp.Caption)
'Enable the Window - makes the userform modeless
EnableWindow mlHWnd, 1
Any one has any idea how to create a similar to find and replace dialog in
the
excel?
Thanks in advance
Shin
|
|
|
|
|
Hi everyone!
I'm using this great code above (that I downloaded here) but it's returning the HTML code with one "?" for each "," "ç" "ã" "ô" etc... I think it's related with unicode, but I don't know what to change. 
Function GetHTML(ByVal strPage As String) As String
Dim oReq As System.Net.HttpWebRequest
Dim oResp As System.Net.HttpWebResponse
oReq = System.Net.HttpWebRequest.Create(strPage)
oResp = oReq.GetResponse
Dim sr As New IO.StreamReader(oResp.GetResponseStream)
Return sr.ReadToEnd()
end function
Thanks in advance! 
|
|
|
|
|
Ok! I solved it using UTF7 enconding in the streamreader!
|
|
|
|
|
 Hello,
I am 7 months young into the vb.net world so i am at that almost their, "but not really point"! Alot of sleepless nights going on over here.
Here is my 10 problem.
If i have a dataset in my vb behind file and in the html i am setting the object <%# databinder.Eval (Container.DataItem, "Customers" %#>,,, So here is the question; if the dataset has one table, and yes that would be Customers, how can i set the databinder.eval to only ONE field in that dateset table?
Please help as soon as possiable!!!
+++++++++++++++++++++++++Here is the html+++++++++++++++++++++++++++++
<asp:datalist id="dlProducts" runat="server" repeatcolumns="2" width="504px" repeatdirection="Horizontal">
<itemtemplate>
+++++++++++++++++++++++++Here is the vb file+++++++++++++++++++++++++++++=
Private Sub Page_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim strError As String
SessionCheck(Session, Request.Cookies("AFCC"), strError)
GetNotifications(lblNotification, Request)
' Set up the department data
cmdRetrieveDept.Parameters("@idDepartment").Value = _
Request("idDept")
Dim dsDept As New DataSet
Dim daDept As New SqlDataAdapter
daDept.SelectCommand = cmdRetrieveDept
daDept.Fill(dsDept, "Department")
dlDept.DataSource = dsDept
dlDept.DataMember = "Department"
' Set up the product data
cmdRetrieveDeptProducts.Parameters("@idDept").Value = _
Request("idDept")
Dim dsProducts As New DataSet
Dim daProducts As New SqlDataAdapter
daProducts.SelectCommand = cmdRetrieveDeptProducts
daProducts.Fill(dsProducts, "Products")
dlProducts.DataSource = dsProducts
dlProducts.DataMember = "Products"
' And bind it all to the user interface
DataBind()
' Store the department ID for later use in building links
Session("LastIDDept") = Request("idDept")
End Sub
Private Sub Page_Error(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Error
Dim strMessage As String = "" & _
"" & Request.Url.ToString() & "" & _
"
<font color='red'>" & Server.GetLastError().ToString() & _
""
Response.Write(strMessage)
End Sub
End Class
Erik
|
|
|
|
|
I usually set my DataSource to a DataTable in the DataSet (lst.DataSource = ds.Tables("MyTable")) or to a DataView. Then the binding code is:
<%# DataBinder.Eval(Container, "DataItem(""MyFieldName"")") %>
|
|
|
|
|
Hi!
I am having a trouble exporting my report to pdf. Everytime I'll click on the export button, the page runs to a blank page. Also, there are times when i click the export button, an error occurs saying "Logon Failed" Here's my code. Hope you can help me
Private Sub cmdExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExport.Click
oStream = New MemoryStream
oStream = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)
Response.Write(oStream)
Response.End()
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/pdf"
Response.BinaryWrite(oStream.ToArray())
Response.End()
End Sub
Thanks!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
