DevilDog74's Q&A profile

• SQL Server Need help with string manipulation - splitting 1 string into multiple columns

  Hello All, I'm a non-programmer and an SQL newbie. I'm trying to create a printer usage report using LogParser and SQL database. I managed to export data from the print server's event log into a table in an SQL2005 database. There are 3 main columns in the table (PrintJob) - Server (the print server name), TimeWritten (timestamp of each print job), String (eventlog message containing all the info I need). My problem is I need to split the String column which is a varchar(255) delimited by | (pipe). Example: 2|Microsoft Word - .doc|Sukanlaya|HMb1_SD_LJ2420|IP_192.10.1.53|82720|1 The first value is the job number, which I don't need. The second value is the printed document name. The third value is the owner of the printed d ...Show All

• Visual Studio Team System Error 28925.TFServerStatusValidator: Calling the Team Foundation Server ServerStatus Service failed.

  Greetings! I'm installing TFS on Windows 2003 Enterprise edition SP 1, using domain accounts. Accounts meet requirements, stated in installation guide. I keep getting an error stated in subject. That's what log files say: 08/23/06 18:57:00 DDSet_Status: Hiding command line parameters 08/23/06 18:57:00 DDSet_Status: Commandline: "C:\DOCUME~1\EAGAFO~1\LOCALS~1\Temp\TFServerStatusValidator.exe" ... 08/23/06 18:57:00 DDSet_Status: IgnoreExitCode: 0 08/23/06 18:57:00 DDSet_Status: Silent: 0 08/23/06 18:57:00 DDSet_Status: ActionStart: 0 08/23/06 18:57:00 DDSet_Status: Cost: 0 08/23/06 18:57:00 DDSet_Status: WorkingDirectory: 08/23/06 18:57:00 DDSet_Status: HideCmdLine: 1 TFServerStatusValidator - Team Foundation Server Status V ...Show All

• .NET Development Possible Problem With Sockets 2.0 Implementation in .NET 2 with McAfee Software?

  McAfee (Privacy Filter and Personal Firewall) installs it's own TCP/IP driver layer. This new driver does not seem to support sockets correctly. When attempting to connect to a remote server IPv4 TCP/IP using the Async BeginConnect you get "not supported on this object type" (unistall the Mcafee driver and it all works fine). If you do a sync connect using Connect the connection is established . However, if you then try to do an async send after connecting you don't just get an exception you get a full blown unmanaged general protection fault. This seems to be a pretty big problem has anyone else out there experienced it or maybe got a work around Interestingly,I have just come off a conference ...Show All

• Smart Device Development mdb to cdb error

  I have a MS Access database that I want to copy to my pocket pc. The problem is that the Active Sync conversion fails. I have the following error: Database: C:\contas.mdb option: 1 - Overwrite existing tables option: 1 - Keep this database synchronized General access denied error I have an application that is able to read the cdb files (including existing forms) but I can't copy the database to my device Any help What do you mean for "locked on the device" The permissions on the desktop seem correct. And I can't copy the file to the device so it can't be locked there... Unless you're talking about some database file that I'm not aware... I've already saw a Directory on the device name Databases witch co ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Any new info on MDX for 64-bit?

  I am in desperate need of MDX 9 for 64-bit development. Any word on the progress Someone mentioned that they were looking into it a while back. I asked at the MVP summit about 64 bit... since MDX 1.1 is not changing you won't see anything there. For XNA and any 'other' MDx type things - "nothing is yet announced but tis always considered as a potential feature - put your request in connect.microsoft.com for XNA" (take that as you will - it means nothing of course!) ...Show All

• SQL Server Cannot connect to AS2005 remotely using SSMS or BIDS

  I really need help to understand why I can't connect to SSAS from a remote machine running SSMS or BIDS. Following is my setup: SQLServer 2005 on a development server Server Name: SQLWIN-1 Named Instance: SQLWIN1 If I am running management studio locally from the server machine I can connect to SSAS fine. However, when running from a remote machine the connection fails with the following errors: TITLE: Connect to Server ------------------------------ Cannot connect to SQLWIN-1\SQLWIN1. ------------------------------ ADDITIONAL INFORMATION: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient) ------------------------------ No connection could be made becaus ...Show All

• Visual Studio Team System Is it possible to set recursion to false?

  Currently when automation script is run, an item is duplicated and incremented in subsequent runs. Is it possible to set recursion to false Thanks Test consultant If you are using a webtest, then there is not a property on the test which is doing this. Is it possible that each time you run the test that some information is being captured on your server in something like a shopping cart and each time you submit another instance is created. ...Show All

• Smart Device Development Eventhandler, in static method

  using System; using System.Collections.Generic; using System.Text; using System.Windows.Forms; namespace Pelle { class MenuHelper { public static MainMenu CreateMyMainMenu() { MenuItem menuItem1 = new MenuItem(); MenuItem menuItem2 = new MenuItem(); MenuItem menuItemUnderStartOrders = new MenuItem(); MenuItem menuItemUnderStartCustomers = new MenuItem(); MenuItem menuItemUnderStartStock = new MenuItem(); MenuItem menuItemUnderOrdersNewOrder = new MenuItem(); MenuItem menuItemUnderOrdersExitingOrder = new MenuItem(); //Creats a mainmenu MainMenu mainMenu1 = new MainMenu(); menuItem1.Text = "&Start"; menuItemUnderStartOrders.Text = "Order"; ...Show All

• Visual Studio 2008 (Pre-release) versioning in WCF?

  Is versioning, according to this article: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnservice/html/service10152002.asp the recommmended (up to date) practice for versioning service contracts for web services headed to WCF I have a chance to create a versioning strategy, right now, for our WSE2 (later, WSE3 & WCF) web services. I appreciate any help. Thanks. As of the November CTP, VersionAdded is gone, but I have written an article on contracts here: http://www.dasblonde.net/PermaLink,guid,91973b53-b5a2-4bf8-ad20-ec504db2da99.aspx and have posted a short commentary on versioning here: http://www.dasblonde.net/PermaLink,guid,a0b48932-4b7d-4d7b-9886-e7d0764d8908.as ...Show All

• Visual Studio Express Editions Are PrivateFontCollections not usable as regular fonts?

  I thought I had a private font working in a textbox. Turns out that the font was installed on my PC, thats why it worked. Have not been able to get any other private fonts to work in a textbox. They only seem to work in 'paint/drawstring' situations. Is this their limit Imports System.Drawing.Text.FontCollection Imports System.Runtime.InteropServices Public Class Form1 Public privateFontCollection As New Drawing.Text.PrivateFontCollection Public FamilyName As String Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Me .Load ' ton of free TTFs at http://www.webpagepublicity.com/free-fonts.html ' Name embedded resource font file Circu ...Show All

• SQL Server When To Use A Function And When To Use A Stored Procedure.

  Hi, I thought that procedures do not return a value: well they only return a 1 or 0 depending on whether the procedure executed correctly. Functions are what you're supposed to use when you want to get a result set of some sort: ie a table or a scalar value. Apparently that is not the case becuase you can return values from procedures. I've attempted to find out what the differences are between the two and when it is appropriate to use a procedure and when it is appropriate to use a function but I'm still unsure. Can someone please tell me the difference. Thanks. Przemek Actually, it can be a performance issue too. If you use scalar UDFs for trivial expressions and use it in SELECT statements/ ...Show All

• Windows Forms String Publishing Error

  I'm attempting to deploy my first project using ClickOnce. This project is being deployed with a setup project, but that is not nearly as convenient as ClickOnce appears. When I try to publish the project I get an error that I am unable to locate any solution for, and I don't even have any idea where to look to begin fixing it. The error sounds very cryptic to me so I'm hoping someone can point me in the proper direction. The project I'm trying to deploy is written in C#, although I don't think that matters much. I did create an empty project and it deploys fine. I've pasted there error below and I would appreciate anyone who can even give me a place to begin looking for an answer. Error 36 "Properties\app.manifest; ...Show All

• Visual Studio Team System Tracability of a "RENAME" in ChangeSets with the API

  Hi, I would like to know if the APIs can help me to find the previous name of a file marked as "Rename" in a ChangeSet. When I loop on the "Change" objects in a ChangeSet marked as "Rename" in ChangeType, I can only get the new filename with the "ServerItem" property, but not way to get the filename before the rename. When I query the history with the renamed filename, the history is empty.(only the last/renamed version can be found) So, the only solution I found is to iterate through all previous changeset and to stop when I found a ChangeSet with a change having an item with the same ItemId... I hope there is a better solution... any idea Sincerely, Daniel ...Show All

• Visual Studio 2008 (Pre-release) Is Linq May CTP comaptible with .net framework 3.0 RC1?

  as addressed in the title, thanks. ...Show All

• Software Development for Windows Vista Update ?

  Hi! Windows SDK is now like 1GB so if there is any update in documentation or something new version... I need to donwload 1GB again to update a few MB's even if it's 100MBs it's still a lot of overweight. So can you do some update feature Jarod Sure, you can launch the web setup from http://www.microsoft.com/downloads/details.aspx FamilyId=C2B1E300-F358-4523-B479-F53D234CDCCF&displaylang=en ...Show All