ukrutter's Q&A profile

• Software Development for Windows Vista Lost

  Can anyone suggest the correct approach: I have an app that has both ASP.NET 2.0 front end and back-end processing engine that does various tasks. I want to add workflow to the app, and run the workflow on the back-end engine. Workflow could be initiated by the back-end processing, or be initiated by a user action on the asp.net front end. I want to host the WF runtime on the back-end processor so that no workflow processing is executing on the webserver and causing front-end delays. From what I can understand thus far, to create an instance of workflow I have to access the Runtime. But if I do that and start the workflow, then I am going to get the first activity of the code running within my ASP.NET context, potentially slowing ...Show All

• SQL Server Date Range Issue

  I've been trying to find a good way to do this and it seems every idea I come up with or find only accomplishes the desired result in one scenario. Here is my issue. I'm designing reports with SQL Reporting Services 2000 and many of these reports need to show values for a dynamic date range such as the last full month, last full week, etc. similar to the built-in functions in Crystal Reports. To accomplish this, my first effort was to filter my results by looking only at results where a specific date parameter matched the current week or month -1 or -2 or whatever was needed. The following example would look at records for the previous month only: SELECT * FROM tbExample WHERE MONTH([Entry Date]) = MONTH(GETDATE())-1 AND YEAR([Entry ...Show All

• SQL Server How to connect to Analysis Services with Excel 2007 Data Mining Add In?

  I downloaded a trial version of office 2007 and the data mining addin. I do not have an automatic connection to Analysis Services, so most functionality does not work. Is it possible to configure a connection with a trial version If so, does anyone know what the server name is and how to configure it the server name is typically the name of the computer that is running Analysis Services 2005 (the machine where SQL Server 2005 is installed). If this is installed on the same computer as Office 2007, then you can use "localhost" instead of the computer name. In case you need a trial version of Analysis Services 2005, you can download it from here http://www.microsoft.com/sql/downloads/trial-soft ...Show All

• SQL Server MDX - Remove a certain member from the total

  Hello everyone - I have a State dimension, the ALL level is called Total. On each report I show the total for all Members for each measure. I now have a request to remove certain states from the TOTALS. Any ideas Thanks for your time. with member [MEASURES].[Loan Count] AS '[MEASURES].[LN CNT]' member [MEASURES].[UPB] AS '[MEASURES].[CURRBAL]',format='#,###0' select non empty { [MEASURES].[Loan Count], [MEASURES].[UPB] } on columns, non empty { [STATE].total } on rows from XXXX where ([MONTHS].[TOTAL].[81]) And if all your measures have aggregation functions SUM and Count (or semiadditive), then you can probably get better perfomance with with member [STATE].[EXCEPT] AS '[STATE].[TOTAL] - [STATE].[W ...Show All

• Microsoft ISV Community Center Forums Run Time Error 1004 On Long Running Stored Procedure

  I am encountering a "Run Time Error 1004" when I attempt to execute a stored procedure from within Excel VBA. The stored procedure takes about a minute to return results. I have tested with shorter running procedures successfully, so it must have something to do with the amount of time it takes to return results. The For loop is never executed because no results return. The error occurs on the last command where I attempt to set the column names in the spreadsheet equal to the column names from the recordset. Obviously errors because no recordset exists. As you can see I have set the timeout for the command to indefinite. I have also unsuccessfully tried a DoEvents after the command has been executed. Suggestions If ...Show All

• Visual Studio Tools for Office Several contactItems to public folder

  Hello, I'm having some difficulties with adding several contacts into a public folder. In my Outlook addin i create 300 ContactItems and I loop through all of them like this: foreach (Outlook.ContactItem contact in contactList) { Outlook.ContactItem c = destFolder.Items.Add(Outlook.OlItemType.olContactItem) as Outlook.ContactItem; try { c.FullName = contact.FullName; c.Email1Address = contact.Email1Address; c.CustomerID = contact.CustomerID; c.Save(); } catch (Exception e) { throw e; } } The strange problem appear when i get to contact number 250, then it suddenly throws an exception: {"The op ...Show All

• Smart Device Development Comm ports

  Hello I need a bit of help. I am trying to use the emulator to send data onto a port which I am monitoring on my pc. I can open the port in the emulator but it freezes when I send data. I am a bit confused over mapping the pocket pc 2003 emulator ports. Do I have to do this I have added a port that connects to COM1 in the device appication. I am then simply executing the code: if (serialPort1.IsOpen == true) { serialPort1.WriteLine("blah"); } I am wanting to see the text blah in a port monitoring program on my pc. thanks The serial port 0 of emulated device is mapped to COM1 on CE and so on. Did you bind the SP0 of the emulator to the desktop COM port (From the File->Con ...Show All

• Visual C# Socket issue

  I'v been trying to figure out this socket for a loging for the project i'm working on....Here is the VB.NET code:: Socket(Index).SendData(Login(ClientID(Index), Crypt1(Index), Crypt2(Index), Sessionkey(Index))) This is what i have in C#:: newsock.Send(LoginMod. LoginMod .Login( ref ClientID, ref Crypt1, ref Crypt2, ref SessionKey)) Here is the Error I get on that String:: Error 1 The best overloaded method match for 'System.Net.Sockets.Socket.Send(byte[])' has some invalid arguments Error 2 Argument '1': cannot convert from 'string' to 'byte[]' It appears, going by the error message, that your Login() method returns a string. The Socket.Send() method is expecting a byte[] ...Show All

• SQL Server SET NEW_BROKER statement hangs system

  SQL Version - SQL Server 2005 Standard Edition, SP 1 I have a database which is Broker Enabled. We use Query notification extensively and the application is in testing stage. Both Testing and development database is on the same server. When I create database for testing I used to do Backup-restore method. When i restore a borker enabled database, the restored database and the source database will have same GUID for Broker. So by default the restored database will not be broker enabled. So what I do is , i run Alter database somedatabase SET NEW_BROKER. This statement will generate new GUID for this database and then we can enable the Broker by SET ENABLE_BROKER statement. Till last week this process was working fine. When I did the same ...Show All

• Visual Studio Team System Configuration Manager not visible in IDE

  Guys, I do not see Configuration Manager in IDE of VS 2005 Team Suite, and basically cannot switch between Release and Debug mode for the code. I have checked all possible placed and I do not see how I could make it to appear. Am I missing something vangelis wrote: ------------------------------------------------ I solved it by simply noticing this: Tools - options ->Projects and Solutions ->General the Show advanced build configurations was unchecked! ------------------------------------------------- That's it! I suspect there is a package that we all installed that changed this setting for us... Do any of these tools sound like something you installed recently - Team System Solution Explorer - Dund ...Show All

• Visual C# Viewing runtime errors

  I'm currently using NotePad to write a simple C# application. I simply use cs.exe to compile my windows application. How can I view the runtime errors when using this approach The compiler does not catch the runtime errors obviously. My .exe simply stops executing without any error messages. I do notice one thing, in my task manager I notice that a process called DW20.exe runs for a brief second and terminates. Is the runtime error being logged somewhere in Windows Thanks in advance. Ray Ray C wrote: Unfortunately, I'm new to C# so I don't know how to do a Try-Catch I tried... try{ .....my code } catch (Exception ex){ MessageBox.Show ("Error is: {0}",ex.De ...Show All

• Commerce Server Commerce Server Order Adapter Endpoint cofiguration programmatically

  Hi, Is there a sample on configuring the CS Order adapter programatically in the BizTalk so it can be used configuring the dynamic send port I need to assign send adapter URI and END POINT MESSAGE TYPE = "Order Queries" properties during run time. Thanks, Hey, There are no examples on creating dynamic ports programatically for CS Adapters. While this is not unpossible, this is untested territory. What scenarios do you need to dynamically create or update a port Hope this helps and let me know if you have any additional questions. Thanks Alan ...Show All

• Windows Forms Using an icon for the assembly file AND the form

  Hello, when I want to add an icon to my application, I need to set it as the assembly icon in the project properties and then again in the form where it should appear. If I only set it in the project, the .exe file has the icon displayed in Explorer and the application's taskbar item also shows the icon, but when switching tasks with Alt+Tab, it's missing; not sure about the form title bar itself right now. When I only set the icon for the form, then it's displayed everywhere but not with the .exe file itself. So, to get this icon everywhere, I need to insert it twice, resulting in the double filesize, regarding the icon size. I've tried to use a resource file, but I couldn't add one to my project settings because the Designer only lets me ...Show All

• Visual Studio Team System TFS Build - next version?

  Hello, does anyone know when a next version of the TFS will be released and which extentions will be made to the Build Automation/Reports - Chris I can't comment on the release date, but what kind of changes are you interested in If we know what you need, perhaps we can meet your needs with the next release. Thanks, Jason ...Show All

• Visual Basic How do i fix to make this code work properly?

  This is my mainform's code This is my main form's code Imports System.Runtime.InteropServices Imports System.Text.RegularExpressions Imports System.Threading Public Class Form1 Public Delegate Sub _idDelegate( ByVal found As String ) Public Delegate Sub _postDelegate( ByVal html As String ) Public Delegate Sub _linkDelegate( ByVal link As String ) Public _onID As New _idDelegate( AddressOf ID) Public _onPost As New _postDelegate( AddressOf Post) Public _onLink As New _linkDelegate( AddressOf Link) Private Sub link( ByVal link As String ) End Sub Private Sub Post( ByVal html As String ) End Sub ...Show All