Use The DHCP Server Management API To Query Scopes And Reservations On A DHCP Server?
Sep 28, 2009I'm looking to use the DHCP Server Management API to query scopes and reservations on a DHCP server.
View 8 Replies
ADVERTISEMENT
Contacting The DHCP Server?
Oct 13, 2009Hello,does anybody know if it at all possible to contact the DHCP server from a VB.NET project with the aim of passing a computer name and it returning the MAC address (and last known IP address). The purpose is that the machine may be switched off which is why we need to go to DHCP Server.Basically need to know the Libraries to imports and get started.
View 4 RepliesTCP Client/Sever With DHCP?
Feb 8, 2010I have a simple TCP Client/Server application that ties two pcs on a lan together. This has worked great for many job sites but the most recent has an IT manager that will not allow me to set a static ip address on the server pc.Basically, I was wondering if there was a nifty way to have the client find the server.
View 25 RepliesCommunications :: IP Address Static Or DHCP?
Apr 12, 2010I am trying to write a quick utility that will find out if a Windows XP computer is set to Static or DHCP and write a log file c:computername_static.log or c:computername_dhcp.log.
View 2 RepliesVS 2010 Get DNS IP / DHCP IP And Defaul Gateway IP
Jun 10, 2011I am developing a windows application for my guys on helpdesk to use with our clients. It is going to be installed on the clients' pc's. One of it's purposes is to display all IP info of a computer. Such as the client's IP address, DNS IP address, DHCP IP address, and Default Gateway IP address, but I can only get it to give me the IP address of the host and no addresses of the DNS, DHCP, or Default Gateway. I know that I could run an ipconfig /all and pull the results into the application, but I would like to have it laid out more simply for it to be easier to read for the clients in case we are walking them through some troubleshooting over the phone and we need their IP information. I do not require and am not requesting any source code.
View 6 RepliesVS 2008 : Use The DHCP API To Retrieve A Computer's MAC Address When Given The IP Address?
Nov 27, 2009I'm trying to use the DHCP API (using the references on pinvoke.net) to retrieve a computer's MAC address when given the IP address but I can't get the code to work. I've run all the C# code on pinvoke.net through the C#-to-VB converter but I'm stuck now.
Here's what I have so far. The value of res is always 5 (should be 0). Thing is, I can't find any documentation on what the return codes mean
vb
Private Sub GetMACDim client As String = "1.1.1.1" Dim server As String = "0.0.0.0" Dim si As New NativeMethods.DHCP_SEARCH_INFO si.SearchType = NativeMethods.DHCP_SEARCH_INFO_TYPE.DhcpClientIpAddress si.ClientIpAddress = Convert.ToUInt32(StringIPAddressToUint32(client)) Dim res As UInteger Dim oInfo As IntPtr
[code]....
Developing With SMO (SQL Server Management Objects)?
Oct 16, 2009Below I have the create script for a table. It works great but for some reason it doesn't include the Keys, Constrains, Triggers or Indexes. I am having little luck finding documentation on how to do this. Most of the example I can find is in C# as well.
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
Imports System.Collections.Specialized
[code]....
Connect .net 2010 To Sql Server Management Exp 2005?
Jan 22, 2012heres my connection module
Imports System
Imports System.Data
Imports System.Data.SqlClient
[Code]...
Install SQL SQL Server Management Studio Express Silently?
Sep 28, 2009where that i find the commands for make an silent install of SQL Server Management Studio Express.The same thing i did with sql express 2005:
infoSQLExpress.FileName = DirectoryGet + "appsSQLEX05.EXE"
infoSQLExpress.Arguments = "/qb INSTANCENAME=" + txtInstanzname.Text _
+ " ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity" _[code]......
Irc Server - Computers - Able To Control Them Remotely Without Using External Dekstop Management ?
Jan 6, 2009At my house we got 6 computers and 5 laptops. Not I want to be able to control them remotely without using external dekstop management or something else. So i can control when my kids can use the computer or not
So I came up with the idea of creating an irc server that listens to commands that I type from my main computer. The commands are no problem for me to program but the irc server itself looks pretty hard. I've been looking on google but cant find a good source to learn it. some other ideas than using irc protocol?
Data From Excel 2007 To Microsoft SQL Server Management Studio Express?
Jun 22, 2009How do I transfer data from Excel 2007 into Microsoft SQL Server Management Studio Express as shown below? I try copy and list of data in excel as shown in the screenshot.. But when I paste in Microsoft SQL Server Management Studio Express.. Only the first result is past inside..
View 2 RepliesDeployed And Installed Application / Want To Attach Database Within SQL Server Management Studio
Mar 9, 2009I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.
View 3 RepliesGet The Stored Procedure Have Created At SQL Server Management Studio Using Code Behind The Files?
Aug 3, 2011How can I get the output data of sql procedure from SQL Server to my asp.net[vb.net] page dropdown list?<asp:DropDownList ID="DdLocation"></asp:DropDownList>
View 1 RepliesUpdating A Data User 2008 And Sql Server Management Studio Express
Apr 19, 2011I'm trying to update a data user using vb.net2008 and sql server management studio express for my backend. the error says "must declare the scalar variable "@username"
Here's the code .
Private Sub btnupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles btnupdate.Click
Dim connstring = New SqlClient.SqlConnection("Data Source=MISD-
[CODE]...
Data Management - Changing Current Database System, MS Access 2007 Front End And MS SQL Server 2005 Backend
May 8, 2012We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
View 12 RepliesAsp.net - Sql Server Query DropDownList Selected Value
Apr 30, 2012I have a DropDownList that pulls values from a table in sql server. I want the dropdownlist to populate the list of values based on a selection by the user but also display the contents of the rest of my table in case they need to change something. For ex:
ddl1 has values of: 1, 2, 3, 4, 5 user selects 5, so the value displayed in ddl2 is five, but if you exand the ddl2 you will also see the values of one, two, three, four...
This is the code in my load event...
If Not IsPostBack Then
result = dal.dbConnect(DAL.dbType.SqlServer, ConfigurationManager.AppSetting("SQLServerConnection"))
[Code]....
Display Query Results From SQL Server In VB?
Apr 8, 2012I am trying to display query results from SQL server in VB. I wrote following code, but not getting how to "Just display the results";
[Code]...
Sql Server - .Net Incorrect Syntax With SQL Query?
Jan 10, 2012Command = New OleDbCommand("SELECT dbo.tbl_staff.staff_id, dbo.tbl_staff.username, dbo.tbl_staff.password, dbo.tbl_useraccount.position_id " & _
"FROM dbo.tbl_position INNER JOIN " & _
[code]....
It says incorrect syntax.
Sql Server - Pagenation On A Blog SQL Query?
Oct 13, 2011I have a blog (non wordpress or anything) written in vb.net. At the moment I pull my data back just by bringing in the last 10 results: SELECT TOP (@bAmount) bCategory, bID, bImageURL, bInactive, bLargeImage, bPost, bPostDate, bPostTitle, bPoster, bStyle FROM Blog ORDER BY bID DESC
I'm just going to have back and forward buttons to go through the posts, but how do I do the SQL for say post 10-20 last posts rather than the IDs between the posts. (The IDs are incrimental, but can jump significantly).
So basically when I click back it gives me 10 posts that are 10 older than the first page results?
Sql Server - Sql Query And Double Var Values?
Aug 18, 2011Im having an issue with a certain query,Dim nwLat As Double Dim Ssql As String
nwLat = nwLatHidden.Value
Ssql = " select * from customer where latitude < " & nwLat
TFRcount.SelectCommand = Ssql
TFRcount.SelectParameters.Clear()
TFRcount.DataBind()
All it does is refresh the page and does nothing; it should populate a chart. However when I replace nwLat with a value (eg where latitude = 56) it works perfectly and populates the chart. Any ideas what's wrong with nwLat?
EDIT: I switched nwLat to long and it works; however it only takes the number up to the decimal and ignores the rest. Any way to fix? (eg as double 56.764746 and long 56)
Sql Server - Store / Query Data In .NET?
Nov 23, 2011At the moment I am using Access & an OleDb connection to store data. I went down this route originally because I though that this was the best way for applications that I am distributing to my clients.
I would prefer to use something like SQL Server but is this a good idea for software I am distributing? Does the average Joe's PC have SQL Server pre-installed? If not, I suppose I can provide them with a link to download it for free?
Is there any better alternatives to Access / SQL Server?
Sql Server Query To Group Records?
May 9, 2011i would like to select from the following table:
PostTable
feed dateinserted count
box1 2011-05-28 11:00 1000[code].....
the total number of records for the previous day where the feed is, 1, 3 and 5 i.e.the feeds I need to retrieve totals for will just be selected based on what I need for instance it could be box4 and box 5...not specifically odd and even...I hope this makes it more clearer..what I have for all records:
select sum(count) as [total] from PostTable where Cast(dateinserted as DATE) =
CAST(getdate()-1 as DATE)
VS 2005 WMI Query - SQL Server Startup
Jan 5, 2011I'm writing a program that will be able to start a window service (SQL Server) on demand. Some of our servers have both SQL 2000 and SQL 2005 installed. I'd like to run a WMI query on the server (either local or remote) to determine how many instances of SQL are installed, and then start the latest version of SQL server. Install paths to SQL instances / configs can be different due to SAN configuration, so I need to use a WMI query to get the services.
I was using the following query- "SELECT * FROM Win32_Service WHERE Name LIKE '%MSSQL$%' OR Caption = 'MSSQLSERVER' OR Name = 'SQLSERVERAGENT' OR Name LIKE '%SQLAgent$%'" This returns a bunch of SQL services, so I decided to cut it down- "SELECT * FROM Win32_Service WHERE Name LIKE '%MSSQLSERVER%' OR Caption = 'MSSQLSERVER'" But that query still returns other services (i.e. FullText, Active Directory Helper, etc.) that I don't want. Is it possible to create a WMI query to only look for MSSQLSERVER and SQL Server Agent services? Am I missing something?
Asp.net - Use VB To Query Remote Server Event Logs?
Aug 27, 2009I am working on creating a web app that will query event logs on internal servers for events using a specific ID. Since most of the servers are running Windows Server 2003, I cannot use the preferred System.Diagnostics.Eventing.Reader method that I was hoping to use.
I've seen the mention of using WMI, but would like to avoid this if possible. I have dabbled with the System.Diagnostics class but cannot seem to get it working when running on a server. It is able, when testing locally, to query my event log, but displays nothing when put on the final server. There is no error that is displayed after the program is ran.
Query A Game Server And Parse The Results?
Apr 10, 2009Has anyone ever done this? Is there a tutorial somewhere?
View 1 RepliesQuery SQL Server Table Results Into A List?
Apr 13, 2012I am trying to create a CLR SQL Stored procedure that uses a query and adds the results to a list in VB.NET. Through debugging I determined that my add statement for the reader into the List is somehow converting my data types and throwing an error when I attempt to execute the compiled Stored Procedure.The columns I am querying are Integers
Code:
Imports System
Imports System.Data
[code].....
Row In Datagridview Not Come All When Query From Database (sql Server 2008)?
Dec 21, 2011row in datagridview not come all when query from database (sql server 2008)?
View 4 RepliesRun Query On In - Memory DataTable & Server Data
Jun 14, 2009I wrote a procedure that builds a DataTable in memory using data stored on our DB2 database. The function builds a Multi-Level Bill of Materials (BoM), meaning that the data cannot simply be queried. The function works great and returns a nicely arranged DataTable object. However, I then need to query the in-memory DataTable against other tables on our server. What would be the best way to approach this problem? Should I make a DataTableAdapter for the Server tables and then build a DataView? I don't have too much experience yet with Data objects. (By the way, I looked into LINQ to DB2 and even installed IBM's addin's, but our server doesn't seem to support it at this time.)
View 6 RepliesSQL Query Works In SQL Server But Not When Called From Checkbox
Nov 21, 2010I've got a datagrid with checkboxes which calls a routine called checkbox_CheckedChanged. So far, so good. I've managed to get it to work out the value of another column in the dataview, which allows me to ascertain the id of the row I'm dealing with. I'm trying to get it to change the value of the column which defines the initial value of the checkboxes, but the SQL I've written doesn't work when called by vb.net - it does work when entered manually into SQL server, however. Here's my code behind:
[Code]...
C# :: Aggregate Or Join Strings In Linq To Sql Query (SQL Server)?
Aug 6, 2010Given a table like
ID | Name | City
1 | X | Y
2 | Z | Y
[code].....