Tito Jermaine's Q&A profile

• SQL Server About Data algorithms

  I just want to know what are the data algorithms available for sql server 2005 and can i use data mining as a web service                       A list of algorithms with descriptions can be found at this location: http://msdn2.microsoft.com/en-us/library/ms175595.aspx SQL Server Data Mining can be used as a web service (by sending XML/A requests inside SOAP payloads). A (live) sample for this can be found here: http://www.sqlserverdatamining.com/XMLAThinMiner/ Our client APIs (OLE DB Provider for Analysis Services, Adomd.Net, AMO) can also be used to conect to an Analysis Services HTTP end point. In this context, the web service ...Show All

• Visual C++ C++ in .NET environment

  Hi, How can I know if my C++ project is manneged (i.e. requiers the .NET framework ) or unmanneged (i.e. pure C++ ). Is there a way to set it On and Off I looked for it in the project properties and couldnet find it ... doe any body have a clue Best regards. So how do I actually go about creating a simply console application that is NOT managed I checked the setting you pointed at (Configuration Properties > General > Project Defaults > Common Language Runtime Support. It is set to 'No Common Language runtime support'. Yet, when I try to compile the following (very simple code): #using <iostream> int main() { return 0; } I get the following error: Er ...Show All

• .NET Development SqlCommand.CommandTimeout is being ignored

  I am getting the following exception because of what appears to be SQL command timeout issue: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) at ...Show All

• Architecture Performance Tool

  I don't know if here is the right place to post but.... Is there a way to monitor like the "Performance tool" on windows the Processor and memory use separated by user on windows server Is there a way to log, and consult it later Thanks Hi Zopo, this is clearly not my field of expertise (Management and Instrumentation) but taking a look at the Management page in the MS Architecture Center ( http://msdn.microsoft.com/architecture/solutions_architecture/management/ ) I found a link to a MS product called Microsoft Operation Manager Not sure if it's the product but its page is at http://www.microsoft.com/mom/default.mspx Hope it is ...Show All

• Visual Basic Opening Forms

  Is it possible to have a function to open a form by parming in the form Name as a string It's simpler than that..... Private Sub OpenForm (byval FormName as string) Select Case "Lassie" FormLassie.Show Select Case "Timmy" FormTimmy.Show End Select End Sub ...Show All

• SQL Server AMO. Aggregation designs can't be deleted? Is this a bug?

  Why this code public static void ClearAggregations( MeasureGroup pMg) { if (pMg.IsLinked) return ; foreach ( Partition lPart in pMg.Partitions) { lPart.AggregationDesignID = null ; lPart.Update(); } pMg.AggregationDesigns.Clear(); pMg.Update(); } doesn't work What are needed and suffisient calls for deleting af all aggregation designs in a MeasureGroup     >For example, in cube editor, in online mode in Visual Studio: >when somebody deletes a MeasureGroup from the cube (by calling as usual cube.MeasureGroups.Remove), >we don't want that delete to happen on the server until the user explicitly saves. :-) But If the c ...Show All

• SQL Server sys.Conversation_Endpoints

  I know that if a conversation is normally ended the handle will wind up in the sys.Conversation_endpoints table in a Closed State. I realize they are supposed to stay there for 30 minutes to prevent a reply attack, however the number of rows I have in this table continues to grow with the bulk of the states set to 'Closed'. I am trying to use this table to determine if I have any conversation handle leaks. I see some rows in there with a Disconnected Outbound state while some are conversing. What should I be looking for in this table and how can I know I have a problem (ie. leak). I realize that Disconnected Outbound is probably something i need to look into. Are there any other states I should be concerned with Gary ...Show All

• Visual C# move file to a directory

  Hi everyone, i’d like to move files from a directory to another directory, with move() or copy() i can only move a file to another file. Can you tell me how i can solve this problem please. Thankyou you really shouldnt be adding references from a different language/using a different language assembly. It's not recommended. you can move all files from a directory, by going through each file/folder and moving it/copying it. Take a look at this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=711713&SiteID=1 the above link copies files and directories. To move directories:   System.IO.Directory.Move( Source, Destination)     ...Show All

• SQL Server Cannot connect to 2000 from 2005 via linked server

  Interesting issue.. I think I have 2 linked servers on my dev 2005 instance (sp1-win 2003). My 2005 instance shares the physical server with a 2000 instance. This linked server works fine. The second linked server is on a separate server running sql 2000 sp3. I cannot connect to this server at all. I can connect the other way -- from the 2000 to the 2005. I have tried all kinds of combinations of security and options but nothing works. The only resolutions I have found referenced installing Management Studio on the 2000 server or creating an ODBC connection from the 2005 instance. Any ideas Here is the error I get: OLE DB provider "SQLNCLI" for linked server "ALLFLDB6" returned message "Login timeout exp ...Show All

• Windows Forms cross-threading exception

  I am getting an exception saying Cross-thread operation not valid: Control 'AE_Debugging_Output_Textbox' accessed from a thread other than the thread it was created on. I did not, intentionally, create more than one thread. In this class I have event handlers that take strings and add them to a queue. I also have a timer that displays the contents of the queue to the ouput textbox, after every interval of 150ms. This is where I am getting my exception. Any help would be appriciated. Thanks, Ross What kind of timer are you using Some kinds will call back on a different thread. The kind you need is the kind you add via the Form Designer. ...Show All

• SQL Server Articles on foreach loop container over dataflow task?

  Hi everyone, do you know any articles on foreach loop container that loops over a dataflow task...pls tell me.... thanks in advance, Hi, Thanks Jamie... But i was looking for articles that involves foreach loop container that has a data flow task... By saying dataflow task i mean i am goin to loop around all the records in the recordset of the dataflow task. or you can tell me how to solve this issue.... I need to fetch data from table 2 for every record from the recordset which is mergejoin resultset of table1 and table2. Thanks in advance, ...Show All

• .NET Development How scalable are Multicast Events?

  I have a control that has many controls. Let's say they can reach over ten thousand. (This is not an edge case for my app). My parent control wants to tell its children to toggle their state based on values passed into a function. The parent control has a collection of its children that are currently toggled on. However, the only way for it to know if a particular child in the list needs to be toggled off is by iterating through the collection and checking if it doesn't fit within the parameters of the function (or it can just toggle them all off and toggle them back on if they do fit). The function receives as a parameter a range numbers to iterate and the numbers match up with the child controls that need to be toggled on in O(1 ...Show All

• Visual Basic Custom control problem

  This may well show my idiocy but here goes. I decided to build a custom control using visual basic in Visual studio 2005. I created a control library and built a control by dragging a Text Control from the tool bar. I managed to add the properties I wanted and modified the key down and key press events to accomplish what I wanted. The idea was of course to have this custom control available in many areas in a project. I then added the control library to the visual basic windows project. I am able to select the control from the toolbar in the project and add it to forms in the project. This all works (the control works as designed). The problem I have is when I add code to say the got focus event of the control in the project th ...Show All

• Visual Basic Getting Form Pixel Color

  Once I draw on a form, I later need to read the colors on the form, at a specific pixel. It was the now obsolete "Form1.point(x,y)" in VB6. I see lots of help for reading a pixel in .bmp files (Bitmap.GetPixel), but that's not my need here. All help says to do is to query the backcolor property, but I don't see a query that allows a specific pixel, such as Form.backcolor(x,y). So how do I get the color of a specific pixel on a form Thanks in advance. Bert Rein, How is your problems going Have you tried the custom defining the certain property by yourself This is my suggestion. Or did you use the System.Drawing.Graphics.CopyFromScreen method Does it help Waiting for your reply :-) ...Show All

• Windows Forms Update Database from Datagrid

  Hi, I have written this below code and would like to understand why whenever i create a new row into Orders Datagrid, the row does not get inserted into Orders DB Table thanks in advance for your help, My code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Text; using System.Windows.Forms; namespace AdminConsole {     public partial class AdminConsole : Form     {         DataSet myDs;         DataGrid myDg;         OleDbDataAdapter myOleDbDataAdapter = new OleDbDataAdapt ...Show All