Ultrawhack's Q&A profile

• SQL Server WMI Task Failu Access is denied

  Hi, i've this problem: have a wmi task that performs a query on a system directory. The package works correctly if executed by dtexecUI. If the package is executed by sql agent job it returns this error message: <<Watching for the Wql query caused the following system exception: "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))". Check the query for errors or WMI connection for access rights/permissions.>> If i create a SSIS proxy with administrator credentials the sql job works correctly, but i've the requirement to use a domain-user to "execute As" SSiS packages, and when i use a proxy like that the job doesn't works anymore and the error messages come into view again. I also tried t ...Show All

• Commerce Server CommerceProfileSystemException: Failed to initialize profile service handle

  Hi, We are working so thad whe have an integration server on with Commerce Server and SQL Server are running. Each developer has now local his own Commverce Server and connects to the database on the integration server. Everything was running fine till last week and now we get a rely strange error. If i start the Website on the server itself it loads and works correctly but if I start the local website on a developers PC I get the error that it Failed to initialize profile service handle. Its so strange then the code of the website is at the momment exactly the same as on the Developer's PC and i get the error way before it really goes into the code. What could here be the Problem It was really working fine last week even the Prof ...Show All

• Visual Studio 2008 (Pre-release) IIS hosting does not automatically start service on call, need to manually hit the server

  I have a few wcf services, hosted by IIS. When my client application does a call, it will result in an exception because the service is unavailable. I have to manually load one of the .svc's to get it to work. After that, client calls work as expected. Is there some way to change this behavior Hi, I have the same problem as Ruurd. (Hmm maybe because we're working on the same project ) The answer to the 4 questions from Michele are all yes : - The server used to be console hosted, no problem there - New file-based websited works fine - Existing IIS sites working fine, a test wcf site also no problem - mapping of the .svc extension is oke But recently I noticed the following entry in my event log, just after trying to ...Show All

• .NET Development Connection pooling

  In my past I took the following course Programming with Microsoft ADO.NET (Material No: 2389BCP) Connection Pooling is covered in detail under Module 2: Connecting to Data Sources; Lesson: Connection Pooling Where the second paragraph on page 39 state the following (citation): When a connection is closed, the connection is returned to the pool and ready for reuse. When a connection is disposed, the connection is deleted from memory. It is not returned to the pool and is not available for reuse. When the last connection in a connection pool is deleted, the pool is also deleted from memory. As we all know when dealing with Web application, enabling Connection Pooling is vital and the reasons are well k ...Show All

• Visual Studio 2008 (Pre-release) Any way to disable optimistic concurrency in LINQ to SQL?

  Is it possible to disable optimistic concurrency checking completely, at a *table* level I will definitely put my vote for this. It is best if we have transactions everywhere, but sometimes it is not necessary. For example I'm using DLINQ in a web application. No problem on the dev enviorment, but when I deploy it on our intranet server - bam. Cannot update records. The problems is due to using SQL Server and Web Server on a machines that were not in the same domain and DTC did not work correctly. More info here . ...Show All

• Visual Studio Tools for Office Two Questions : OnAction & LoadPicture

  Hello I have two Different Questions that i ran into while trying to work with VSTO 2005 (Visual Basic) they are both about Working with ToolBarButton I am working with Excel Project. 1. OnAction Property Does not  work when i trying to asign an macro(some Sub) to a ToolBarButton. I am using: With objButton ..... ...     .OnAction = "MySub" end with and have a related Sub with the same name. there is no error in the code but at runtime i am getting the message "the macro could not found". (I tryed few 'places' new module,the sheet,the workbook  class..) Finaly i gev up and find the way to do it with WithEvent to the Button and using the Button_Click event and then everyting works. But I wa ...Show All

• .NET Development Zero a volume

  I need to prewrite a volume attached to the windows host. In other words, I need to zero the entire volume. Is the best way to do this - open file, set a buffer full of zeroes, write it to the disk, move file pointer and so on Or is there an easy way to do this in .NET What I'm trying to accomplish is actually sort of format the volume, but for optimizing performance. I'd like all pages on my disk to be written to gain better read performance. ...Show All

• Software Development for Windows Vista Print to XPS Driver, Automatically Save File, and Call Application

  I have been searching on the web for weeks on how to do this. Any help would be great. At the moment we ask our customers to print to the Microsoft XPS Document Writer, specify their own filename, and then open our application, and load the file in to it. What the customer wants is for this to be fully automated. I.e. When they print to the Microsoft XPS Document Writer, they want all of the rest to occur without any prompts. I have seen a number of posts talking about StartDoc() but these would all require programming in the application doing the printing. We need generic print functionality that can take input from any Windows application. I guess we may have to modify the xps print driver in some way, but I have no idea where t ...Show All

• .NET Development choosing policies in runtime with WSE 2.0

  Hi, I'm developing an application consuming many web services and some of them might require a separate policy config because might require a different certificate. Then, to restate the issue: - have multiple proxy clients to invoke different web services from many and different sources - have the chance to configure a different certificate for every proxy client using WSE I think I have to define a policy where I specify the certificate (among other settings) but at proyect level, then the same policy applies to all the invocations executed in the project, then what I need is the chance to specify multiple policies with multiple certificates and select the proper policy in runtime. Any suggestion is welcome thanks ...Show All

• SQL Server Can a Report Model have Reports included in it?

  Hi All I have created reports in 'Projects'. What I would like to know is that if can transfer these reports into a report model As per my knowledge, a report model contains datasources, datasource views, report models itself and doesn't allow to transfer reports. Please , let me know if my understanding is correct Cheers Preps. hi, i am new in report model report. i have created one report model project, but i don't know how to make report from this report model project.............can u help me to make report from report model project or suggest any article on it..........thx in advance ...Show All

• Microsoft ISV Community Center Forums New Outlook Task: Automatically inserting text into the notes area

  I want to write code that automatically inserts text into the notes area of a new task, i.e. when I click on the "new task"-button and the "Untititled"-task window opens, I want certain text (eg. Requirements) to appear automatically. I have tried the following: Public WithEvents myNewTask As TaskItem Public WithEvents myTasks As Items Public Sub Initialize_myTasks() Set myTasks = Application.GetNamespace("MAPI") _ .GetDefaultFolder(olFolderTasks).Items End Sub Public Sub Initialize_myNewTask() Set myTaskItem = Application.CreateItem(olTaskItem) End Sub Private Sub myNewTask_Open() myTaskItem.Body = "Requirements" End Sub And I have tried tried: Private Sub myTasks ...Show All

• Windows Forms Graphics are being erased by other windows or off screen movement...

  I have am working on a program that monitors the download speed of ones internet connection and draws the speed to a graph. The graph is a simple line graph that is drawn using GDI+. The graph is updated in the WebClients DownloadProgressChangedEventHandler. The problem is that when I move a window or move the program off screen, the graph, or the portion that was covered or went off screen gets erased. I have tried doing gc->Save(); (gc=my graphics) but that has not done anything for me. Here is my entire code: (Note that the timer tick event, "UpdateGraph" doesn't do anything, that is fine) #pragma once namespace iDT { using namespace System; using namespace System::ComponentModel; using namespace System::Collections; using names ...Show All

• SQL Server casting date stored as integers

  Hi I have a SQL server database that have dates stored like 12142006003423 which means 2006-12-14 00:34:00 is there any way to cast it directly to a datetime type (I don't mean a user defined function as I've already implemented one) thanks Mugambo, thanks for your interest . however I was looking for a direct cast or convert statement that can accomplish this task I've created a scalar function for the ease of use as follows CREATE FUNCTION Int2Date ( @sdate bigint) returns datetime as begin declare @dt as varchar(14) declare @dd varchar(2) declare @mm varchar(2) declare @yy varchar(4) declare @hh varchar(2) declare @mi varchar(2) declare @ss varchar(2) declare @result varchar(25) set @dt = cast(@sdat ...Show All

• Visual C# system tray application

  how can develop a system tray application in C# 2005 Handle FormClosing event and write the same as resize private void Form1_FormClosing( object sender, FormClosingEventArgs e) { Hide(); e.Cancel = true ; } ...Show All

• SQL Server Can we upgrade from Express 2005 to Standard/Workgroup 2005

  Can we upgrade from Express 2005 to Standard/Workgroup 2005 If possible with what complexities can it be done Hi Priya, Its possible to upgrade. Run the installer and upgrade the instance you want to do. Just before upgrading I'll suggest you to stop MSSQL and backup its data folder. Thanks ...Show All