Find SQL Server Instance On Other Computer On LAN?
Aug 8, 2011
I have the following function to find a SQL Server instance. It works fine on local computer. Would you please tell me how to use this function to check an instance on other computer on a Local Area Network? I am using VS 2008 (.NET Framework 3.5) and SQL Server Express 2005.
Private Function MyInstanceFound(ByVal MyInstanceName As String) As Boolean
Dim InstanceFound As Boolean = False
Dim MC As ManagedComputer = New ManagedComputer()
[code].....
View 1 Replies
ADVERTISEMENT
Jun 22, 2010
How to findout computer / server name with vb.net codes. I want to use it in connection string
[Code]...
View 1 Replies
Dec 29, 2009
How to findout computer / server name with vb.net codes.I want to use it in connection string
con = New Data.SqlClient.SqlConnection("Data Source=noor;" & _
"Initial Catalog=accounts;Integrated Security=True")
View 3 Replies
Dec 12, 2011
I have an application that allows the user to conduct database backups and restores. The users had been using Windows XP, with network security that allowed users to read the registry. For restores, the installation path to the SQL Server named instance was easily found by looking up the instance name in the registry using
restoreDir = My.Computer.Registry.GetValue("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\" & m_DatabaseInstanceName & "\Setup", "SQLPath", Nothing).ToString
They have recently upgraded to Windows 7, and locked down the registry so that users can not read values from it. Is there a way (via code) to find the path to a named instance of SQL Server, so that the app can automatically place the database files (mdb & ldb) in the correct folder?
View 2 Replies
Jul 29, 2010
A while ago, I wrote a web-based guestbook application that wrote it's own database.
My code was very amateurish, but, as it was my very first publication, I was very happy with it. Only about a month after I'd published it did I realize I'd made a huge mistake in the code.
I've only ever connected to a specific named instance of SQL Server, and it occurred to me that, if the SQL Server instance has a different name than the one I specified, it wouldn't work.
So, since my users will probably not know what the name of the instance of SQL Server that's running is, I thought adding a field where the user can specify it would help if they do, but what if they don't? My answer was to get the local instance, regardless of name.
I tried Data Source=.local;, Data Source=.; and other variants, but nothing worked.
View 2 Replies
Oct 20, 2009
Are there any good tutorials/links I can work through. I want to make my pc a file server or an ftp server through vb.net. How would I go about doing it?
View 5 Replies
Jan 23, 2009
I am using the IndexOf function of the string class to find a specific instance of a string. And based on that I have a logic to do something. Below is the example of what I am doing. The code is in production and is working fine. But for some instance I am getting an "Object reference not set error". Yeah its intermittent.The requestXML is a string of xml data passed in as a paramter to a subroutine. I am fetching the xml string as a form post in a request object. The only thing I could think of getting this kind of error is when the requestXML string varia
requestXml = Request("requestXML")
SubmitRequest(requestXml)
Private
Sub SubmitRequest(ByVal requestXml
[code]....
View 5 Replies
Jul 24, 2011
How would you work out the amount of ram that is in the computer
View 1 Replies
Mar 29, 2012
To get the computer name I wrote something like below:[code]This code works on the server machine but on the client machine its not working.Is there any another way to find the computer name.
View 3 Replies
Sep 14, 2009
Basically I have a datagridview that holds data. All I want to do is have the user type in a string to an inputbox then search the datagridview for what the user typed in.This is what I have so far really I think the only thing I need is the piece after if dgbcollectionitem.(i need what goes here). after that I'll use an else statement for error checking.[code]
View 4 Replies
Feb 2, 2009
i'm currently trying to test a program at home that i've written for an assignment at university. At the university they have a dedicated SQL server that i can connect to fine enough but to test and debug at home i have installed MySQL 5.1.
I now have trouble connectioning to MySQL the error message i get points towards that my program is acutally looking for an instace of MS SQL server and i don't know where to change this.
I have downloaded and installed "MySQL ODBC Driver-MyODBC 3.51" which some people have suggested corrects the problem, unfortunatly this doesn't work.
The current code i have is:
Dim strConnBuild As New SqlConnectionStringBuilder
With strConnBuild
.DataSource = "localhost"
.InitialCatalog = "northwind"
[code]....
I can't find any properties of the SqlConnectionStringBuilder that indicate what instance and protocalls it should use.
View 1 Replies
Nov 19, 2010
Basically, I've got this plugin-based application I've used all the time in VS2008 flawlessly. In my current project (VS2010 by the way) I wrote a plugin for the application and whenever I try to use an instance of a particular class (in an external dll) from my plugin, I get an error.
I tried watching the instance and I got the message:
"Cannot find the method on the object instance."
in the watch window. This has never happened before! I also found that some of the extension methods in the plugin does not work.
View 2 Replies
May 26, 2010
ok i got a hard question I have diferent computers, lets say 200 cps with all known mac address. i got 3 switches with 24 ports each. i want to know if i can be able to know the port No. and switch of a given computer given the mac address... some computer arent in the domain. how could i start puttin this into code
View 1 Replies
Aug 1, 2008
I am trying to get the next available computer name based on a pre/sub fix e.g. "PC0001", atm I have a working solution from sql asset database.Anyone got an idea on how to convert the following from sql query to directorysearcher.filter?"Select TOP 1 Computername from computers where Computername LIKE '" & computerNamePrefix & "%' AND ISNUMERIC(right(ComputerName,4)) = 1 ORDER BY Computername DESC"At the moment I got the following
mySearcher.Filter = "(cn=*pc*)" mySearcher.Sort = New SortOption("Name", SortDirection.Descending)
View 2 Replies
Jun 22, 2010
I have different computers, lets say 200 cps with all known mac address. i got 3 switches with 24 ports each. i want to know if i can be able to know the port No. and switch of a given computer given the mac address. some computer aren't in the domain. how could i start putting this into code.
View 1 Replies
Sep 28, 2010
How can I find the file that keeps my computer passwords such browsers IE? I want to reformat and have a lot of saved passwords sites
View 3 Replies
Jan 26, 2012
I am building a simple network browser that pings a specified range of IP addresses, and if a response is discovered, it gets the host name and MAC address of the device it pinged.My first question is how can I find the operating system of the device (if it's a computer)?My second question is, for devices that aren't computers e.g. a wireless printer or router, is there a way I can find out what type of device it is?
View 1 Replies
Apr 30, 2010
I created a hangman game and It works well when I debug, but when I publish and place it on my son computer, when you guess a letter wrong it shows an error and says it can't find the images. I just it is something that I'm doing wrong but I don't know what. Some of the thing that I have tried is including the images in resources. I believe that it has something to do with the startup path, the path that the images are looking for does not exist. The installer installs the program in the programs file
Private Sub ShowPicture()
Dim strImagePath As String
strImagePath = Application.StartupPath & "imagesfig" & intNumWrongTries + 1 & ".gif"
[Code]....
View 1 Replies
Aug 28, 2009
I am writing a quick program to display the network information of a computer without having to run ipconfig or enter the TCP/IP settings on the network adapaters.I have managed to pull the computer name, local IP address and the external IP address, but I now need to get the default gateway, the subnet mask and the DNS resolvers.I have tried using the registry, but the key differs from computer to computer, so that method has been ruled out.
View 8 Replies
Jun 2, 2012
using vb 2010 to find the fingerprint or digital ID of individual parts of a computer, specifically the motherboard? I have no idea where to begin and everything I can find on the net is written for C#.
View 2 Replies
May 25, 2010
ok i got a hard question I have diferent computers, lets say 200 cps with all known mac address.
i got 3 switches with 24 ports each. i want to know if i can be able to know the port No. and switch of a given computer given the mac address.some computer arent in the domain.
how could i start puttin this into code
View 9 Replies
Oct 18, 2010
I am adding a datasource to a form.I have add the database to my SQL Server instance.
From the wizard i have succed to connect to the database
The test is OK
But at the last step to save the connexion this is the error message i am receiving an unexpected error has occured :
[Code]....
I thought because i did not yet build the solution. I did it but the same error message remains.
View 3 Replies
Feb 20, 2012
Is there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?
View 6 Replies
Feb 20, 2012
Is there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?
View 1 Replies
Aug 26, 2011
I am trying to Get the SQL Server 2005's Server Name or Instance Name in Combobox but unsuccessful.
Tried to access by Registry, tat produced error
OSQL -L did not list any servers
View 2 Replies
Feb 2, 2012
[code]....
View 5 Replies
Jun 5, 2011
I have a webbased proj. What i need is to connect the vb.net app to an sql server via internet. My projects run fine in a standalone pc.
View 3 Replies
Jun 5, 2011
I always get error to connect my project in vb.net to sql server on remote computer?
View 7 Replies
Jul 3, 2009
How do I know where the other end of the NetworkStream from the 'server' computer? I have been looking at the following code that comes from a post out here, and am wondering where I can tell where I am going to send back to(URL/port)?
Private Sub DoListen()
Dim incomingClient As System.Net.Sockets.TcpClient
Do
[code]....
View 5 Replies
Jun 5, 2012
I've created a Http Server in VB.net.I've used the same "template", I guess you could say, for every project requiring an Http Server (quite a few recently).The problem is, this one I'm working with now requires that the computers on the LAN be able to connect to it. I can access the server directly from my computer though using: [code]Now I get an error every time when it tries to apply the prefixes: I've checked all the ports that are listening and 8002 is still open...
View 2 Replies
