how can i get the list of all sql servers on my machine i am trying this code i have vs 2010 and sqlexpress 2008 r2 i put breakpoints seems everything working fine but its not getting any server i don't know whats wrong with it here is the code on button click this suppose to work to get all servers and list them in the combobox cmbServer [Code]
View 5 RepliesI don't really know how to code but am pretty good at tweaking. I'm trying to set up a script that I can run to delete a single file, multiple files, a folder or multiple folders on a list of servers.I was thinking that the script could read the files to be deleted from a .txt file and apply the deletion to a list of servers in another .txt file.Example:
FilesToBeDeleted.txt:
\(insert_server_name_from_list)c$Program FilesBINexample_file.rpt
or
[code].....
show me how to use the WTSEnumerateServers API to get a list of servers?
Here is the MSDN page: [URL]
...but I can't figure out the last 2 parameters:
ppServerInfo - Points to an array of WTS_SERVER_INFO structures, which contains the returned results of the enumeration.
pCount - Pointer to a variable that receives the number of WTS_SERVER_INFO structures returned in the ppServerInfo buffer.
get a list of the servers avalible on the network, then check to see if those servers contain my database?
View 3 RepliesIIS7 running on Windows Server 2008 R2. Development environment is VWDE 2010.
I'm setting up a simple "machine status" page to monitor a server. I want to display the Drives on the machine, including mapped network drives and show their free space, etc.
I'm using System.IO.DriveInfo.GetDrives() to return a collection of DriveInfo objects. I then itterate that collection to display the relevant information.
The issue I'm having is that only local drives appear. (A:, C: and D:) No mapped drives "Network Locations" appear in the collection.
I'm thinking it has to do with the user account that's executing the code (if that makes any sense). So if the code is executing under the user "ASPNET" (or whatever it is) the drives would have to be mapped under that user. As it happens, I have the server set up like a workstation and it logs in automatically under the user with the mapped drives.
What I've done:
- I have set the Web Site's Anonymous Authentication user to that same user
- I have set the Identity of the Application Pool to which my web site is assigned to be that same user.
I'm using the 2.0 framework to get a list of queues from a remote machine. Sometimes the machine has a firewall and then the user has to wait 80 seconds or so before an exception is thrown stating that the machine is unavailable. Questions: Is there any way that I can set/change the timeout for GetPrivateQueues ByMachine? Is there any other method I can call before running GetPrivateQueuesByMachine to see whether the machine is responding? One that has configurable timeout, Any other solution?
View 1 RepliesI want to display in a listbox all the running processes on the local machine. Can anyone offer me some code to do this.
View 2 RepliesI've been searching about how to list and remove or create all list of the ports forwarded on the current machine. So I can allow my app to create a port to allow the "chat". Wondering how this is possible. I saw many samples on net, tested most of them and none worked properly. Is there a possible way to edit ports with visual basic 08 or 11?
View 3 RepliesI develop an application using vb.net.application will run on client server architecture.when we try to execute the program in client side then it will give me an error which is related to sqlclientexception.how can i handle this situation.i used vb.net 3.5 as front end and sql server 2000 as back end.i have done total coding with system.data.sqlclient namespace.
View 6 RepliesI've inherited a lot of custom made software for an office, and, while managing it, I've found it performs differently from machine to machine.I mean, some controls get painted in weird ways in some machines but well in another, or just work differently, like in some machines clicking something selects it, and in the next machine clicking the same thing makes it editable.I suspect, o course, of the myriad of DLL the software loads
View 2 RepliesI want to block a perticular machine from accessing my machine..Both the machines are in LAN..I dont want a perticular machine to access my computer How can i achieve this...I want to do this using VB.NetAny idea....
View 9 RepliesI'm using the details on connecting to a server from a client here: [URL]
It's quite out dated but I just need it for a quick project. I need the client to auto-connect. This program will be running on the LAN only, is there a way to find on what computer the server is running on (i.e. all computers hosting the specific server on port x). I've seen it on a couple of games that run on LAN. Without access to the internet, they manage to display all available games on the local LAN. I'm doing this with VB.net.
I am using the following code to get the Disk I/O on various servers. For now I am just retrieving the DiskReadsPerSec to get a feel for it. The return data gives a uint32 for each drive on the server and a total. My questions is what is the time frame that this represents? Is this at the second that my code polls the drive or is this over the last few seconds or do I need to do multiple runs to get an average.
My intention is to build a graph for each drive so I wonder how often I need to poll the drive to get a acurate value.
Public Shared Function GetDriveIO(ByVal strip As String) As Boolean
Dim oConn As New ConnectionOptions()
Dim lnglist As New List(Of Long)
[Code]....
i am trying to connect to 10 mysql servers and get aprox. 5000 rows. If i make the test from local network it works but if i take the test using mysql servers (same version) from different city it shows me the error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding".[code]
View 1 RepliesI designed an app that basically gets paths to servers I have admin rights to, I am doing such things such as checking available space on the servers etc., the problem I am having is my app only works if I manually login via something like (start, run, \server) and supply my admin username and password just to store that authentication.How do I code this so it prompts the user in my program ONE time for all 5 servers (they all use the same username and password)
View 5 RepliesCan ClickOnce software be ran on a terminal server?
View 3 RepliesA little background, the client that I am working with has an enterprise AD that is a mess. They have no containers for servers or any organization what-so-ever. They also shutdown servers and did not remove them properly from AD. So I needed to come up with a program that would find all the windows server, identify them by OS, and then check to see if they would actually respond to a ping. (I am aware that this is not a perfect method if they are refusing ICMP's but its good enough for my purposes). The completion of the program will display all the information and then allow the user to save the excel workbook in a location that they choose.
vb.net
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
[code]......
As the title describes I am looking for a way to query for the UTC time from NTP/SNTP Servers from 'VB.NET'The only libraries I have found for VB.NET to such tasks appear require a fairly large sum of different forms of currency.
View 1 RepliesHow I can send file from server to another server in network??
View 2 RepliesThe title of this thread perhaps does not explain my problem correctly.Actually i am developing a financial software for a company.The software is similar to a banking system. The software is being developed using VB 2008 and SQL Server 2008.The company has its branches located at different locations. They are having a centralized SQL Server at their Head Office.The branches are connected to Head Office using a VPN.Now what we are worried about is when the VPN gets disconnected.For that we will be having a SQL server installed at each of the branches.When VPN is connected the the details entered will be directly at the Head Office database,Meanwhile a program will be executed which will get details from the Head Office database at each of the branches in a XML file.When a branch gets disconnected from the VPN another program will get the XML details into the Sql Server installed at the branch. When the branch is connected again Another application will create a xml file from the local server and insert its details into the HO server.The sizes of the XML are reaching upto around 150 to 200 mb. I am using Dataset.WriteXML and Dataset.ReadXMl. I have tested this on my local machine it is taking upto 30-40 secs.I dont know how much it will take when the actual application is installed. How can i speed things up ? Does anyone have any idea on how i can do the whole process more smoothly and faster?
View 5 RepliesI have the following code which connects to my webservice online:
Dim c As New com.*********.checkLicense()
c.CookieContainer = New System.Net.CookieContainer()
c.setApplicationGuid("e3b59b3d-4150-4cb0-adda-f5db004f362f")
[code]....
Now what I need to know is, if a user has proxy settings configured in IE, will this code automatically use the proxy?Also what happens when said proxy needs authentication?Anyone know how this can be adapted. I know about the System.Net.WebProxy class, however I would really need this to pick up the settings from IE by default and then if required (and only if required) pop up for proxy authentication.
Im trying to check multiple services on different servers. The idea is that every time a client clicks on a checkbox for the specific server and press the "check service" button it will check the status on the service and if it's not running it will restart the service and so on for the rest of the servers.[code]
View 2 RepliesI was assigned a project to create a program of cloning two file servers. It will copy all folders (about 500, one day one folder, there are about 200 files in each day) from one file server (S1) to another file server (S2). If any error occurred while in processing, program will send an email to someone.
View 5 RepliesI am trying to find the way to create RDP session on remote computer using VB and net framework.
Because my company is using RDP(not a console session), some processes that have window that is to show logs and event must be executed on the screen.
However there is a lot of computers, I have to find some solution that is to execute remotely.
The problems that I encounter are as below.
1. if there is no session(in case of restarted) - I have to create session.
2. if there is session - I have to get appropriate sessionID
3. Remote execution - to execute remotely on the session.
I am trying to merge 2 datasets from 2 different servers, SQl 2005. I need to take 2 fields from one table and five from another to create one merged dataset and bind it to a datagrid, in an 2008 ASP.net application. The first table I will be saving to is empty just the table schema is there, The second table that the datagrid is populated by, has two columns containing dropdown box and a text field for user to edit these fields, these will be saved into the first table along with the user information, and a time stamp, but when a user pulls this information again the changes in the datagrid will reflect these changes.
View 2 RepliesI've never tried accessing a database on a remote computer, across the internet. A few questions though.
1) Do I just change the connection string address from a local path to a web address?
2) Do I still need to install the local driver? In my case I believe I'll be using Connector/Net to connect to my MySQL database url...
I have a DotNet 3.5 Winforms app. Mature app working well. It is a desktop client side application. One of the forms I've recently modified to include a picturebox which shows a standard gif animation.Running the application(and displaying the form with the picture box) works as expected on on Win XP + Win 7. i.e. the gif animation plays.
However running the same application on Windows 2003 or Windows 2008, I get the form loading but not animation in the picturebox, just static image.At first I thought it was because I was accessing the server via Remote Desktop but I did the same with XP, yet that still had the gif animating. Oh and I can play a gif using Internet Explorer on the servers.
I am trying to remotely connect to servers on a network. However, an exception occurs and I can never connect. The code I am using to connect to the servers does work because I have had someone else test it. The exception is shown below. Is this a setting with VB or with my computer?
System.Runtime.InteropServices.COMException was caught
ErrorCode=-2147220308
HelpLink="C:Program FilesPIPCPISDK..Helppisdk.chm"
Message="The specified time is invalid "
[code]....
I am trying to reset IIS on a set of servers all at one time instead of looping through and resetting each one individually, but I can't seem to figure out how to do it.[code]...
View 4 RepliesMy system is connected Trhough LAN..
totally four systems connected. and all systems having MS SQl server installed in it.
now i need to retreive that - which all server's i can connect to..?