DB/Reporting :: MS SQL Cannot Pass Port Forwarding Function On Router
Oct 2, 2008
I have setup a MS SQL server in my computer and enable the sql server to listen to the TCP/IP port 1500. I can use my vb.net program to access to the sql server from another pc within the same LAN by using the following connection string "Data Source=192.168.1.101,1500;Database=ABC;UID=SA;PWD=123;
But if I changed the "192.168.1.101" in the connection string to the IP address that provided by the ISP (i.e.: "Data Source=<IP from ISP>,1500;Database=ABC;UID=SA;PWD=123 the connection string do not work. I have set the port forwarding function in the router as forward all TCP from 1500 port to IP 192.168.1.101. But it don't work neither......
Then I checked the port 1500 with the webpage below: [URL]
It show that the port 1500 is closed! But if I use DMZ function on the router to explose my computer the internet.... the above webpage can checked the port 1500 is opened! And I can successfully connect the sql server with this connection string
"Data Source=<IP from ISP>,1500;Database=ABC;UID=SA;PWD=123;"
Is that the mssql cannot pass the port forwarding function on the router? I have set the port 8080, 21 forward to another IP on the router and it work fine......
I am looking to write a VB.NET windows app or service to do simple HTTP port forwarding. This is normally done within my router, but I have more forwards to do than the router can support (10) so I would like to do it programatically.
Quite simply, an HTTP request would come in on a port where the application/service is running, and it would automatically forward the conversation to another IP address and port. That way, my router could forward a range of ports to one machine (where the application/service would be running) and the application/service would dole the requests out to the various IP/Port combinations it was listening for.
I am trying to write a program that launches a game server, the only problem is that I do not know how to port forward with vb.net or if it is even possible? It is for a game
I am testing out packet sending with some friends and I've made a chat program which seems good and all...(not really, its really bad actually), But anyway... The users cant receive incoming messages unless they portforward port 1337 to their computer... How can I get users to receive messages without portforwarding?
I'm working on a type of p2p program, and I found the need to forward ports. That can get complicated for the average user, so I'm including the option to use UPNP to forward the ports for them. I'm using code I found HERE, and it worked too! then randomly it stopped working. I don't remember changing anything in the codeThis is the entire code. I have the Exception Highlighted in Red. The project includes a Listview (6 columns), three buttons (4, 5, 6), a progress bar, and a background worker.
Imports System.Net.Sockets Public Class Form1 Dim upnpnat As New NATUPNPLib.UPnPNATClass()
Our company has setup several remote devices that link to a switch Whenever there are problems on the device, some technicans will replace it using a new one We have a vb program that can automatically update the device setup in our server when technicans replace devices. So we do not need to login and update the setting manually However, our program cannot handle the case that there are more than 1 device that need replacement Therefore, our idea is to retrieve the ip and port of the router/switch that links to remote device using VB.net.
I want to make an numerical integration method with takes in an analytic function and integrate it over a specific interval. For the numerical integration procedure I want to use some procedures in nr.com. The problem is that these are programmed in C++ and they uses functors to pass a function to the integration method. How can I do this in VB 2010?
I want to initialize the function (i.e. set a=1,b=0 for function y(x)=a*x+b) and then pass the function to the integration method. Then when the integration method call the function it only calls the function with one parameter (i.e. x since a,b is already set)
What is the best way to do this in VB2010?I want to make a general integration method where I can pass any single valued function and integration limits.
I have just started using VB, and from what I have found so far it seems like the tools you have is
- to us a delegate for the function - to use a lambda expression for the function - send a pointer/adressOf - to create a function class/structure and submit this to the function
As for now I am most inclined to create a function-class. But I am not really sure how.F.ex. I make different classes for each "uniqe function" I want to integrate, but how can I pass them to the integration function when I need to specify the argument type in the integration-function-call?This seems like a basic problem which applies to many Math operations, so I think it would be very useful to clarify this.
I am not sure which method that I should use for my project. I would like to get bypass the port forward to avoid the 3rd party software such as packet sniffer to pick up the connection details.
I want to make a GetAllContacts method which takes a sort parameter of type Func(Of Contact, TKey) which is the same type that the OrderBy method for an IEnumerable(Of Contact) takes.[code]"Too many arguments to extension method 'Public Function ElementAtOrDefault(index As Integer) As Contact' defined in 'System.Linq.Enumerable'." on the second parameter.
Im a student doing an assignment, how do i pass the value from a sub procedure to a function procedure....i want to pass the value from decSubtotal to a function procedure named CalculateDiscount; check out my code--
I am confused as to why you have to pass the name of the table in the .Fill() method? As an example, see the following code:[code]I have already specified "NameTable" in the query string, so why do I have to put "NameTable" again in the Fill() command?
I want to ask how to i , passed the value i get from my previous form using this"Login.user.Text" to a Query Builder to filter the result based on the value of Login.user.Text" .
SELECT LecturerID, Lecturer_P FROM Lecturer WHERE (LecturerID = ??? )
I use Visual Studio 8 and Sql server for my database. I have a form with a DataGridView where my records are display on from the database and some text boxes. I want to pass the data from a specific record from the DataGridView to the text boxes whithin the RowHeaderMouseDoubleClick function.
I have developed a program in exe format & sell it on WWW.?Is there a way to ensure that the buyer does not e-mail the exe file to a third person?In other words, Is there a way to prevent the recipient of your exe file from forwarding it to a third person?EXE file is installer of VB2008-created exe & other compiled files.
I have a statement: dat.XoaNhanVien(Me.dtgcapnhatthongtin.CurrentRow.Cells(1).Value, message) That is a function for deleting info. Now I want to create other function and get above function to parameter. I mean: Public Function func(Byval func as " What type can be ?")
I'm trying to pass 2 bitarrays to a function that ANDs the bitarrays and returns the count of bits that are set to TRUE. However, something strange happens when I reference the bitarray from within the function and the results are non-sensical.
So I have output the bitarray contents before it is passed to the functionand they match the source data, then I output the contects of the bitarray from within the functiona and they are completely different.
I'm working on a VB.NET DLL right now, and one of the functions I'm writing is supposed to take a file, and clip out an array of bytes (the method I've got works, and can be abstracted away here). What's the best way to pass a file to this function? Would passing a filename to it be best, or what would be the best way to accomplish this?
I'm trying to give a default value to the register property method. This required a function, but passed as an object(delegate?).[code]....
I want to call that registerproperty method, but I don't know how I can do that in VB.net. I just need to pass along a new Person object and I thought this was the way to go[code]....
I just want to ask if it is possible to create a function that accepts an expression into its arguments. Just like what IIF do. Ex: Dim strResponse as String = IIF(Msgbox("Select Yes or No", vbYesNo) = vbYes, "Yes", "No") I forgot the code, but its the thought that counts.
The is a calculate function for example Function Calculate (Byval v1 as integer, Byval v2 as integer, byval op as ????????) as double return v1 op v2
End Function Anybody tried this?
I don't want to use functions for every operation (multiply,divide, etc.). I wanna pass a operator same as I pass the values. How come nobody ever had this need in VB? Using enums could work but still...
I have an array of integers and I want to pass the array to a function that will add up the elements of the array and return the cumulative total of the elements of the array. So, if the array contains the values {1,2,3,4,5} the return value from the function would be 15.
I should use the Timer_Tick function, to loop a data read from a COM port. The object i call uses a method that closes the thread after a fixed timeout.
obj.Read(N byte) //--> if no data come within 500ms close the thread
My question is: considering that the Timer_Tick function will be called every (for example) 100ms, How long does the total execution last? Timer_tick time + Thread Timeout (100ms + 500 ms = 600ms) or just the Timer_Tick time (100ms) causing the anticipated thread closure/crash?
The code below is used in a Linq to SQL solution, and is in the Load event of a form. It works fine to display an ordered list of people's names, and set the value member to that person's ID. However, I'm going to be using these 'people' comboboxes a lot, so I'd like to put a sub into my Utility code there is only one line in the form's Load event.
I want to call something like: Call ComboboBoxPeople(cbo, tblTurnbackMain, ReportedByID)
The sub would begin like: Public Sub ComboboxPeople(cbo as Combobox, tbl as 'sometype', fld as 'someothertype')
What can I use as the parameter types for tbl and fld?
if this is a dumb question. I don't ever have to write anything in VB.NET.But I am passing variables named "name" to a function and sometimes it may be 1 name or 2 names, etc. I want to check in the function if its only 1 name don't add a comma, if it's 2 names add a comma. Is there a way to get how many "names" there are?
EDIT: Added my ode to make my question a little more clear. sorry for not doing it before.
My Code:Public Function GenerateCSV(byval str as string, byval str1 as string, byval str2 as string, byval GrpName as string)
I have Listview which databound to Dataset with about 20 items per row. I have a function which executes on each ItemTemplate appearance and gets about 10 params from Eval("something"). So basically one function builds and image from 10 parameters.Instead of passing 10 Eval("something") to the function is it possible to pass it whole row and how to use this row inside of function because it is not simple DataRow or ListView row which i can access as array of items (datacolumns).Reason i do that because function looks ugly and each time i need to change it i need to deal with dozens of items.
Im having a very difficult time trying to pass an vba array ive built from ms- access vba to a .net function.I don't have a com problem I can reference the library just fine from vba but and i can call a simple function from vba. however my problem exist when i attempt to try to pass an array to the vb.net function. vb.net code
