Peter Evans's Q&A profile

• SQL Server Problems with Create Endpoint

  I'm on XP running SQL 2005 (9.0.1314) trying to create and endpoint on my local machine. I'm trying to run the Adventureworks sample code: CREATE PROCEDURE [dbo] . [uspGetPersonInfo] @ID [int] AS BEGIN SET NOCOUNT ON ; SELECT [FirstName] , [MiddleName] , [LastName] FROM [AdventureWorks] . [Person] . [Contact] WHERE ContactID = @ID END ;   CREATE ENDPOINT SQLEP_AWPersons STATE = STARTED AS HTTP ( PATH = '/AWpersons' , AUTHENTICATION = ( INTEGRATED ), PORTS = ( CLEAR ), SITE = '*' ) FOR SOAP ( WEBMETHOD 'PersonInfo' ( NAME = 'AdventureWorks.dbo.uspGetPe ...Show All

• .NET Development Calling a stored SQL Proceedure from VB

  K, got some canned proceedures on SQL Server 2005 Express, now any thoughts on accessing them The project is pretty simplistic, but its a learning tool for me. dim IP = ...... 'got this working ok Call dbo.HitTable.Update(IP) ' speculative idea Call dbo.Hitable.Hits() 'more speculation Sorry, never tried SQL from VB before, let along any other tool. http://www.vbdotnetheaven.com/Code/Jun2003/2102.asp I provided this link yesterday, did you read the page It definately explains how to call a stored proc from VB. ...Show All

• Visual Studio Express Editions insert filename into SQL Table

  Hi I'm just not getting this but how can you insert the filename into a table. I managed to upload a file from website to my hard drive but now what to save the filename to a field in the database. Can someone please help Here's the code for aspx file and following the code for aspx.vb file: <% @ Page Language ="VB" MasterPageFile ="~/MasterPage.master" AutoEventWireup ="false" CodeFile ="AddFoundImage.aspx.vb" Inherits ="MemberPages_AddFoundImage" title ="Untitled Page" %> < asp : Content ID ="Content1" ContentPlaceHolderI ...Show All

• Visual C# looking for library components to query a remote host

  I am wondering if someone could point me to library components that would let me query a remote host (WindowsServer2003) programmatically in C# for information including: IP address Hostname Uptime Load OS version IIS version and similar data. Thank you. I would recommend that you use WMI through the System.Management.ManagementObjectSearcher class and its related types. This will give you complete access to the information you need on any machine running WMI (which everything from W2K+ does). ManagementScope scope = new ManagementScope( @ \\MICHAEL1\root\cimv2 ); scope.Con ...Show All

• Software Development for Windows Vista Installing vs 2003 onto vista 5270

  I cannot install VS 2003 onto Vista 5270, any ideas copy it to the hard drive and try again.  You might also need to run the msxlm6 first, if i remember correctly   Josh http://windowsconnected.com   ...Show All

• Visual Studio Team System Web Test Connection Model and IP switching

  Can anyone provide more information or links which explain in more detail: 1: Connection Pool and Connection per user. Whats the advantages/ disadvantages of using either of these Also what's the optimum setting for WebTest Connection Pool size or what does this depend on 2: IP switching, with this enabled, which I think it is by default how does this work / is there any additional config required. What range of IP's does it use thanks in Advance, Phil How is a load test of a webserver cluster possible without such a feature ...... I don't understand Microsoft. :-( And why they have written about that this feature is included ...Show All

• .NET Development Client IP Address

  Client IP Address Hi I am using VB.net to run a Server Client application through TCP/IP I managed to connect and transmit data. One probel I am finding is that I need to get the IP address of the client while accepting and compare it to a list in the database. If the IP address is not in the database, the connection will be terminated. Can someone pls show me how to red the Client's IP address. Thank you all hi, i'm searching for the same thing and i found this in other thread http://www.developerfusion.co.uk/show/3918/ best regards ...Show All

• SQL Server How can I tell which version is installed?

  One of the server admins recently installed SQL Server 2005 on a new Itamium server. I am trying to set the parameter on the services to indicate they are running on a 64 bit machine, however the changes are not taking...yes I'm stopping and restarting the services. I'm wondering if did not install the right version. Does anyone know how I can tell if the IA 64 version was installed Duh! It never occurred to me that it might list the processor. Thanks! Oh...I wish I had a brain! ...Show All

• .NET Development selecting string from file

  Please can any body write a code for selecting a specific string from file and printing in list box Please tell the code in vb.net for eg file is <items>     <header>         <eventdate>             <month>5</month>             <day>9</day>             <year>2005</year>         </eventdate>     </header>  & ...Show All

• Visual C# How to link assemblies without recompile - Multilanguage Application

  Hello, I have got the following problem: I developed an Multilanguage Application with a flexible menu, where the supported languages will be displayed. Now I wanted a translator to localize a resx file into French, then I created a resources-file with the resgen command: resgen E:\VS2005_Projects\LanguageExamp\LanguageExamp\bin\Debug\zh-cht\Form1.zh-cht.resx , and from this file I created a resources.dll-file with the assembly linker: al /t:lib /culture:zh-cht /embed:form1.zh-cht.resources /out:LanguageExamp.resources.dll Then I copiede the file into a directory "fr-Fr" and started my application. The result is that my application ...Show All

• Windows Forms about SelectedIndexChanged event in listview

  Hi i am very newbie in this vb.net world but i am developing a windows forms . I am using this code: Private Sub lvwLocales_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lvwLocales.SelectedIndexChanged         ObtenerLocal(Trim(lvwLocales.SelectedItems(0).Text))         MapearVariables()         BloquearControles(TipoBloqueo.tbNo ...Show All

• Architecture Doing what Microsoft does, not what they say to do… DNA, SOA, Software Architecture, VB.NET, CMMI, Agile Development

  Trying to weed through all the marketing driven releases from MS is not an easy task, but in the end it is something that always needs to be done. In this blog I discuss DNA, SOA, Software Architecture, VB.NET, CMMI, Agile Development - Doing what Microsoft does, not what they say to do… I would like to know if you are going through the same problems I gave up trying to weed through Microsoft's patterns and tools a long time ago. Bear in mind that MS is extremely popular in the novice and unproffessional developer community and this reflects on the patterns they provide. As for 'Doing what Microso ...Show All

• Visual Studio Tools for Office Deploying UDFs

  From an ISV standpoint, is there an automated way to deploy UDF's to a client's server short of scripting the compilation and creation of the assemblies Is there a possibility of chicken/egg situation when attaching a DB with reference to assembly prior to creation Donnie, Are you looking for answer's around deploying SQL UDF's in that case you might want to post this question to the SQL Server forums. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=86&SiteID=1 If you are looking to develop some Excel UDFs here's more information: http://forums.microsoft.com/MSDN/ShowPost.aspx Pos ...Show All

• Visual Studio Source Control in VB Express

  Hi, I'm currently using Source Safe 6 and would like to connect it with my installation of VB Express 2005 beta2, is it possible And how do I make it If not, what are my options TIA /Kejpa   Hi Kejpa, Source control integration is not available for VisualStudio Express SKUs. Only Standard SKUs and above (Professional, Enterprise, etc) will allow source control integration. You can however use your SourceSafe 6.0 as an external application. You'll have to use SourceSafe Explorer standalone to create a VSS project, set the working folder to your VB local project folder and add your files to Sou ...Show All

• .NET Development Best database choice?

  I am wondering what the consensus is on choosing a database solution for a windows forms application when developing for the following criteria: 1. For applications that need to be deployed with their database on target computers (nothing complicated like oracle or ms SQL). 2. small amounts of data...( say...less than 500 mb of data [basically only need to persist small amounts of data between application executions ]) What kinds of storage media are easiest to develop and deploy   Is it best to use something like access, dbase, an xml file, or something else Thanks Thanks for the repl ...Show All