I'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 2 servers that produce xml files and store them locally on their hard drives.Im not to sure what would be the best way to make these details viewable from any machine on the same network?I have created a asp.net web page which reads and displays the xml files. It does it fine locally, but would i have to host it on a dedicated web facing server so that it could display information from the 2 different servers on the network?
View 1 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].....
I installed Visual Studio 2008 and Office Enterprise 2007 in my new computer.I made some codes for a data reader to get data from an Access dabase. On the step where it will open the connection an exception appeared which says "Microsoft.Jet.Oledb.4.0 provider is not registered on the local machine".
View 7 Replieshow would I go about making the user access different local SQL databases. As in they use a GUI program to access / read / write data in a database but can also use that same GUI program to do the same to multiple database files.Is that sort of setup easy to integrate into a VB program? or does a VB program by nature only try to access one database? To integrate the open and close dialogs into a VB GUI in terms of different database files, is there much involved?
View 10 RepliesI am working on an app that searches my network and retrieves ips and host names, but when using this.[code]
View 2 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]......
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 RepliesAs 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 Repliesshow 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.
I 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 Repliesget a list of the servers avalible on the network, then check to see if those servers contain my database?
View 3 RepliesI 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..?
I've got a small utility I use to communicate with Yahoo's APIs. Their servers return all the responses in JSON. Is there an easy way to parse this into its base form when you don't necessarily know what will be in the response?
[Code]...
I want to display a dialog that has 2 dropdown combo's. The first combo display a list of the available SqlServer servers. The second combo displays the list of available database once the user has selected a server. how to populate the combo's?
View 2 Repliesi need to send e-mail's from the iis 6 via smtp server that are 2 diferent machines
i have this exampel but is not working
Public Sub SendMail(ByVal from As String, ByVal [to] As String, ByVal subject As String, ByVal body As String)
Dim mailClient As New SmtpClient(test.MailServer)
[Code]....