Walter Sobcak's Q&A profile
SQL Server Complicated Inserts
Hello everyone, im looking for some advice or maybe examples. How is the best method of checking a table for a specific IP address located as an element value of a xml data type. For example xmlNode = Table in use myXmlData = Document being stored as XML datatype I would like to first check the table of existing XML entrys for an ip address that is within the current xmldata in the reader. If the ip address in the reader matches any of the ones in the database it will update that row. If the ip address can not be found in any existing row, a new row is created and myXmlData is stored. At the mome ...Show All
SQL Server Cannot Enable Remote Connections for AS 2005 on clustered instance
Hello SQL pros - I am having a problem with enabling the remote connections for Analysis Services 2005, Here's the gist.... --Error Information-- "To configure Analysis Services for Remote Connections, you must be an adminsitrator for Analysis Services Windows Service (SQLSAC). Additonal Info A connection cannot be made. Ensure that service is running (Microsoft.AnalysisServices) No connection could be made because the target machine actively refused it (System)." --Actions Taken-- 1) Analysis Services Windows Service was confirmed to be running. 2) Analysis Services Windows Service was stopped and restarted. 3) A ...Show All
SQL Server service broker error : Connection handshake failed
When I configure SSB in two machine to send message, I get a error message in target machine SQLProfiler: "Connection handshake failed. There is already an existing connection with the same peer and this connection lost the arbitration. State 80." Then I get another message "This message could not be delivered because it is a duplicate.", but I am sure the configuration of routes is right. How to solve the problem Thanks. I test it in Version 9.0.1399. Can you download the script from http://www.gotdotnet.com/codegallery/releases/checkForDownload.aspx id=9f ...Show All
Windows Forms MainMenu and MenuItem controls
I added a Tag property to the MenuItem control using inheritance: Public Class MenuItemPlus Inherits MenuItem Private _tag As Object Public Property Tag() As Object Get Return _tag End Get Set(ByVal Value As Object) & ...Show All
Visual Studio Team System VSTS Dual Server Performance problem
We have 2 environments of VSTS – one single server and the second dual server. We are encountering performance problem (During checkout, check-in operation) in the dual server configuration (the operation are performed from a client that is installed on the server (it eliminates a network problem) only. Is there is any additional server configurations that we should consider (and that is not mentioned in the installation guide). What kind of performance problem are you having What operation are you doing Using IDE or command-line On how many files How long does it take ...Show All
Windows Forms Nox invasion
Hi, I was just wondering what type of animal, and why the Nox 3.6 has totally invaded my ecosystem. Thanks Well I am not sure about this, what I would really like to see is an advanced terrarium and a beginner terrarium. but you know that is only a wish and I know it would take an act of some higher ups to aprove ...Show All
Windows Forms Localizaion problem of embedded Windows User Control in IE
Hallo, I have a small localization problem. My Application My.dll will be loaded in IE Here the html code: <html> <head> <link rel="Configuration" href=" http://myserver/mycontext/My.dll.config"/ > ... </head> <body> <object id="My" width="230" height="150" classid="http:My.dll#My.MainCtrl" VIEWASTEXT/> ... </body> </html> The application will be loaded and it's running without problems. But, while loading of dll the .NET Framework sends a lot of invalid get requests, here the log entries: "GET /mycontext/de-DE/msco ...Show All
Smart Device Development COM Component, UPnP & Web Services on Mobile Devices
I want to have your input on the following scenario that I am facing: Objective : Development of a “Service” for a mobile device which provides various communication & interfacing options to a user Planned Environment/Platform : Windows Mobile 5.0 devices (to make use of the new managed APIs) running .NET CF 2.0 (primarily because of COM Interop support) Invokers of the Service : Both Native and Managed Components/Applications Receivers of the Service : Service itself can invoke Web Service (managed), UPnP Service (either managed or native) and COM Component (native). I am thinking of 3 possible ...Show All
SQL Server using distinct on one column only
I have a table that contains 5 or 6 columns. (plantid, commonName, scientificName, planttype, etc) what I am wanting to do is create a table of all the plants with distinct scientificNames. but I am wanting to display the commonName, scientificName, and planttype. I figured using the distinct operator would work, but is seems as if it looks at the combination of all 3 rows instead of being distinct on only one row. Basically I am wanting to be distinct on one row, but view 3 different rows. Can anyone show me the sql statement to do this. Essentially you are doing 2 things. 1. Show distinct value ...Show All
Visual Studio Express Editions Visual Basic 2005 Express edition Installation Problem
Reference to undefined entity 'nbsp'. Error processing resource 'file:///C:/DOCUME~1/Carlos/LOCALS~1/Temp/IXP000.TMP/failed... <!-- div id="RPCreated" style="display:none"> -----------------------------^ I tried installing VB 2005 express, had problems running it when I loaded it. Tried running the uninstall tool before reinstalling and the above error is what transpired. I do not know how to fix this. Can someone please suggest a solution hi. im having a similar problem installing vb 2005 express ed. I downloaded the installation files and when I execu ...Show All
Visual FoxPro Obtaining a web page's title
I'd like to get the titles of web pages, and would prefer not to do this by loading all the web pages into a webbrowser, because that seems a bit heavy handed. In VB6 I used some APIs to achieve this, but I'm not having any luck in getting it to work in .net. Here's the code I'm trying: Module Module2 Private Const INTERNET_FLAG_RELOAD = &H80000000 Private Declare Auto Function InternetOpenUrl Lib "wininet" Alias "InternetOpenUrlA" ( ByVal hInternetSession As Integer , ByVal lpszUrl As String , ByVal lpszHeaders As String , ByVal dwHeadersLength As Integer , ByVal dwFlags As ...Show All
.NET Development SqlDataAdapter Update Method Returns an Error when a where clause is added to the Select query
I'm using .Net 2.0 and Visual Basic 2005 trying to update a SQL2005 Database. I have created a SqlDataAdapter with a Command builder object in my code. If I set the Select Command to a Select Statement that doesn't contain a where clause to filter the table I'm querying then after I've modified the table the DataAdapter.Update(myDataSet) method works correctly. But if I filter the table I'm querying by adding a where clause, when I call the update method, I get the message "Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information." Why does a " ...Show All
Visual Studio Express Editions Solution With both a c# project and a website?
Is it possible to load a solution that contains both a c# class library project (with business objects) and a web site project Thanks You'd need to use the web developer express edition for this, assuming that it will load both. You may have to go between C# EE and Web Dev EE, or buy Visual Studio. ...Show All
Visual Basic This must be simple? Displaying a picture from SQL into image box
I have managed (after some time on Experts Exchange) to save the contents from an image box to my dataset; however, I thought it would be relatively simple to reverse this process and display the contents of the column into a image box...however, after looking at numerous articles on the web, not one of them helps me. I have a dataset called dsPerson and the field is PersonImage. I don't want to bind the field to the database as I'm controlling the recordset with code. This is the code I have used to save the image: Dim TempImage As Image = Image.FromFile(dlgOpenImage.FileName) Dim mStream As New IO.MemoryStream() Dim ImageB ...Show All
Visual Studio Express Editions Bought VB2005 express, loaded CD, but only web developer shows. Where is VB5?
Bought VB2005 express, loaded CD, but only web developer shows on install. Where is VB5 Not on the other CD's either (the other two are the training video and images). The CD is labeled Visual Basic 2005 Express Edition, but VB is nowhere to be found. What gives Do I have a bad CD Thanks Sorry to hear of your problem. Please send your contact information to me at (ChrisT@microsoft.com) and we'll send replacement media to you. I apologize for your inconvenience. Chris Treadaway Business Manager - VS Express & Expression ...Show All