Zero_'s Q&A profile

• SQL Server Assistance on implementing Data Mining

  Hi, I'm new to SQL Server and data mining, so please forgive my ignorance... I'm working on a project which requires me to use the datamining provided by SQL Server 2005. I've a table for which i want to predict the values in a table (Encyclopedia) The table contains the following fields: Component Major Attribute Minor Attributes(which is basically a list of CSV for attributes in no particular order) I want to predict the component if i enter the attributes ..... my questions: 1. Should i change the table structure in any way to assist in data mining 2. What model would be preferrable 3. If i'm using the model ...Show All

• Visual Studio Team System Work Item Query Question - State Field Value dropdown list

  While creating some new work item queries and using the State Field as part of the criteria, I have noticed that the Value list for State contains values in the dropdown list that I do not want. I have looked through all of the Work Item Type xml definitions for State and Transition and cannot find where the incorrect values showing up in the work item query are being pulled from. Can anyone point me to where the values located in the work item query State Field dropdown list are defined Thanks. Allowed values in the query builder aren't scoped to a work item type - they combine together all ...Show All

• Visual Basic GDI+ Question - Copy drawn image

  I've spent the last hour googling, searching this forum, and MSDN2 for what, I assumed, would be a simple process.  I have a picturebox that I've drawn in (via the Paint event).  I want to copy the information I've drawn on the picturebox (not the box's .Image property, which is nothing)  to the windows clipboard. Short of resorting to the API and BitBlt how can I get what's drawn on the picturebox into the clipboard I want to notice that Ken's sample will draw whole control, including any non-client area elements. It may be ok with picture box, but if you use other controls with borde ...Show All

• Visual Studio registration of COM dlls fails in dynamic clearcase views

    Hi all, we have a problem, since we migrated from VS2003 to VS2005. Our project contains several COM DLLs, but the registration of these DLLs fail with the error message: error PRJ0019: A tool returned an error code from "Performing registration"   Registration on the command line also doesn't work. Our build runs in a dynamic clearcase view. When I copy the build output to local harddisk, then registration succeeds. It also works, if I use a snapshot view, but our build process requires a dynamic view. When I build the DLLs using VS2003, there's no problem registering them in a dynamic view. The a ...Show All

• SQL Server Merge join with empty inputs

  Hi all, Does anyone have suggestions for ways to deal with the chance that a merge join might receive empty inputs I've noticed that when this happens the transformation seems to hang. I changed the MaxBuffersPerInput to zero and this seems to cure the problem but I'm not sure it's the best way to deal with it. Would it be a good idea to test the row counts with a conditional split before such a join Cheers, Andrew Are you certain that both inputs are generating EORs when they are complete. If so, then this is likely a bug. If not, then there is no way for the MergeJoin to know that it won't ...Show All

• Smart Device Development Removing junk characters

  Hi, I am reading from a text file into a textbox and then separating items which are separated by a vbCrLf, and adding them to a list box. When I do this, at the end of each item, a box character appears, which then affects my database search as the string has a box in it. Can anyone suggest a way to overcome this Thanks, James Why not use StreamReader.ReadLine to read each line instead and then add each line you read to the listbox. See more examples on reading text from files here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconReadingTextFromFile. ...Show All

• SQL Server SERVER 2003 Standard x64 will not run ASP connecting to SQL

  I have a asp page running set dbConn = server.createobject("adodb.connection") dbConn.open "Provider=SQLOLEDB.1;Password=cyclone;Persist Security Info=True;User ID=sa;Initial Catalog=DataWarehouse;Data Source=TVI_XXX" And testing DSN file............with ODBC myConnFile = Server.mapPath("/") & "/" & "TESTFILE.dsn" connectstr = "Provider=SQLOLEDB.1;Password=cyclone;Persist Security Info=True;User ID=sa;Initial Catalog=DataWarehouseTEST;Data Source=TVI_XXX" connectstr = "FILEDSN=C:\Inetpub\wwwroot\TVI\TESTFILE.dsn" Set oConn = ...Show All

• Visual Studio Blue Screen when installing VS.NET 2005 Pro

  Hi all, I downloaded the VS.NET2005 Pro and SQL 2005 Dev Editions from the MSDN site and have been trying to install it on my IBM Think Pad for the last week. When installing at the point when the install says "Installing .Net Framework 2.0" I get a blue screen of death. This happens both for SQL 2005 and VS2005. I then tried to install just the .net 2.0 framework and get the BSOD. below are the dumps in my Event log (I have the actual .dmp files to) I have tried switching off my Windows Firewall etc as I found ONE post about someone having a similar problem but the issue was Zone alarm. But this did not even help. EVENTLOGS: (Please ...Show All

• Visual Studio TextTemplatingFileGenerator now fails to compile T4 templates on a machine where VS SDK (2006.02) is not installed

  1. I have ported my DSLs without any problems on the new version of the DSL Tools which is now included in the VS SDK February 2006. 2. Everything works fine on a machine running the VS SDK 3. But I get a problem after deploying the DSLs (which have a PLK and which designers work fine, by the way) on a machine containing only the new version of Microsoft DSL Tools Redistributable Technology Preview ( and not the VS SDK ): When I run the TextTemplatingFileGenerator custom tools on any T4 template of any of my DSLs on these machines, I get 2 errors in the Task list : Custom tool error: Compiling transformation: The type or namespace ...Show All

• Visual Basic (newb) Writing to a new file

  Why is this Throwing a 'not supported' exception (VBe '05 beta 2) System.IO.File.WriteAllText(fname, txtexp)   Where Fname and txtexp are both dim'd and have values.  The file in the path Fname does not exist, but the definition syas it will create it, but that doesn't seem to be the problem. ...Show All

• Visual C# foreach loop stays in infinite loop when an exception occurs.

  My code reads a list of files from one directory and moves them to another directory. The problem here is that if an exception occurs, then the code get's stuck in an infinite loop. Meaning the value stored in fileName stays the same, and is not updated(incremented) with the next string value in the fileList. The exception will be caused if someone has the file open, or locked by another application. What I need to do is to gracefully skip over the fileName that is locked up, or in use by another application. I suppose this can be done by somehow forcing fileName to point to the next value in the fileList Array. Does anyone know ...Show All

• Software Development for Windows Vista Virtual Folders Default List

  Do you have a default list of Virtual Folders that will ship with the OS.  Also within these Virtual Folders is their a way to find out their search criteria For example, I see you have "Albums" which I am assuming will list all music according to "Albums".  Is their technical information on what "all music" encompasses etc. Thanks. Virtual Folders are persisted in XML form. You can always open up a .vfolder file using notepad, you can see what the persisted form of a virtual folder is. In those files we specify: * The view information (under viewInfo). This includes info such as viewMode (detail ...Show All

• .NET Development c# Problem : CLR20R3, please help me.

  hey guys! im currently working on a nice application that works with Microsoft access database (.MDB) when im in the "Microsoft vidual C# 2005 express edition beta" program, my app runs FINE! when as soon as i publish it....i cant run a part of code :( here is the code :     string sPath = Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + "/";     Access.ApplicationClass accessApp = new Access.ApplicationClass();     accessApp.DBEngine.CompactDatabase(sPath + "MyDB.mdb", sPath + "myCompact.mdb", null, null, null);      //copy myCompact.mdb to myDB. ...Show All

• SQL Server SQL Server CE 2.0 to SQL Server 2005 Express

  Hi All, I was wondering if it is physically possible to have an SQL Server CE 2.0 [or 3.0] connect to SQL Server 2005 Express Edition via RDA. And if it is, is this an officially supported scenario by Microsoft I haven't been able to find any official info on this issue. Is this documented somewhere on some MS pages Regarding synchronization I could only find out that Merge Replication works with SQL Server 2005 Express Edition with it being only a subscriber but I found nothing about Remote Data Access synchronization with a SQL Server CE 2.0 or 3.0 Thanks, Marius   Hi, I noticed that a ...Show All

• SQL Server Latest information acquisition place

  Where can I obtain the latest information on a Data Mining function Books on line has a lot of information.  You can also find a lot of information at www.sqlserverdatamining.com .  Later this month (9/26) the book "Data Mining with SQL Server 2005" by Zhaohui Tang and me will be released as well. Thanks -Jamie MacLennan SQL Server Data Mining SQL Server Analysis Services ...Show All