enpointeprolifix's Q&A profile

• SQL Server Intermittent Error 40 on Report Manager

  Hi, I have my Reporting Services up and running and deploy the AdventureWorks samples without any errors. I can browse to http://localhost/reports, click on the AW samples, but when I then click on actual report, I sometimes manage to get the report parameters returned, sometimes get the below error. In all cases it takes 40-50 seconds to get a response, during which time the CPU usage jumps up and down between 0% and 100%. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'AdventureWorks'. (rsErrorOpeningConnection) An error has occurred while establishing a connection to the ser ...Show All

• Visual Studio Tools for Office Inspector CommandBars

  I would like to add a command bar to the window where I read the messages but not to the one that opens when I want to create a new e-mail message. I create the CommandBar in my Microsoft.Office.Interop.Outlook.InspectorsEvents_NewInspectorEventHandler Event Handler. I can limit the creation of the command bar to a MailItem by saying : if (Inspector.CurrentItem is Outlook.MailItem)             {....} But I cannot differentiate between a new e-mail message window and the window that opens to read an existing message in any folder. Any Ideas on how to do that I work with VS2005, VSTO 200 ...Show All

• SQL Server SQL Server 2005 RTM

  Hi,   What if I want to remove(clean) all default instances and install SQL Server 2005 RTM as the default instance. I am getting the error "An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name. " while trying to install RTM. I unistalled Sept CTP. How do I remove all the existing instances and start fresh. Thanks, -Suri I forward my posting to another question here. Try the following. 1. Uninstall all visible Beta components in Add/Remove Programes. 2. Detect the Beta components infromation in the the log file located in ...Show All

• SQL Server Where are my tools? SQLEXPR.EXE

  Hi, I've installed ms visual studio 2005. On the list of installed components, there was SQL server 2005. As far as I'm concerned it automatically installs SQL Express. I have VStudio ready for work, in start -> All Programs -> MS SQL Server 2005 I have only "configuration tools". Where can I find tools for createing database schema, some sql editors, tools for creating new users.. etc If you didn’t download the advanced edition, you have to install the client tools seperately: http://msdn.microsoft.com/vstudio/express/sql/download/ HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Moving my SQL 7.0 databases to a new server to replace the old server

  My existing SQL server is an old box that can no longer cope with the load. I need to replace it with a brand new box. I am looking for a comprehensive set of steps that I could follow to ensure that the transition to the new server goes well. I'm looking to transfer all my user databases but I'm not so sure whether I have to backup and restore my system databases to the new server as well. I want to name the new server the same as the old server since I will be taking the old server out of production but I'm not sure whether I should rename the server AFTER I move over all the database and how that would affect SQL. Or should I fir ...Show All

• Microsoft ISV Community Center Forums VBA Editor Crashed

  Dears, I installed a couple of Excel Addin and uninstalled now, but the VBA Editor can't view code right now. I can pop out the VBA Editor in Excel, but I can't double click any file nor insert a new module/class -> it crash immediately. ( Screen here) I also tried to unregister the VBE6.DLL and re-install the component in Excel, but it doesn't fix the problem. Anyone know the resolution (FYI: I installed Excel 12 in the past but now removed and installed the Excel 2003 right now, is it something crash my Excel 2003 version ) TIA! Per the support engineer: The program crash has lots of possible r ...Show All

• SQL Server Custom connection manager development sample?

  Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class. TIA, Nitesh I assume you mean a custom UI for the component not connection. You follow a similar pattern to tasks, but inherit from IDtsComponentUI Interface . Developing a User Interface for Components ( ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/dtsref9/html/10b829a1-609b-42e3-9070-cfe5a2bb698c.htm ) A sample is available from here, Ch 14 & 15 - Wr ...Show All

• Visual Basic Root Namespace

  Hi, My questions is: how do I get the root namespace of an assembly (loaded by Reflection) I hope this is a simple enough question... I do need it for accessing types within the assembly. Thanks in advance, Alex Yes, it is the latter. For example, if you have specified the root namespace as 'MyCompany' in your project and had the following class and namespace declarations: Namespace Foo     Public Class Bar     End Class    End Namespace Public Class Zoo End Class   the compiled assembly would contain the two public classes MyCompany.Fo ...Show All

• Smart Device Development Gracefully exit a blocking call in a thread (NETCF1.1)?

  I am looking for a way to gracefully exit blocking calls such as UdpClient.Receive() if they never receive any data so that I can terminate the thread that they are running on. I am using the .NETCF & C#. Any ideas or insight would be greatly appreciated. Thanks. What I do is to have the program send a udp packet to 127.0.0.1 with the word QUIT. The loop in the blocking thread receives a packet with QUIT and exits the function. ...Show All

• SQL Server Can you create an Alias in a Data Source View?

  Hi All.  I'm building a report model for the first time (SQL Server 2005 June CTP).  I created a data source view by adding the tables that I wish to have in the model.  Now I want to use one of those tables more than once, but I don't see a way to create an Alias.  I see that I can create a Named Query, so I could use that, but I'd rather have an Alias for performance reasons.  For example:  Let's say you have a Fact table with muliple Time Dimension ID's, like Date Entered and Date Worked, and you want to join to the TimeDim twice, once for each.  Using a Named Query for one, I would think it would create ...Show All

• Visual C++ Software controlling mouse in WinXP

  Hi, I've been trying to write a program in VC++ .NET which controls mouse movement in WinXP. Sadly I'm a little lost as to how I should achieve this. All I want to be able to do is to set the position of the mouse cursor to an arbitrary place on the screen. I was hoping there was a straight forward system call I could use to fake a mouse interrupt, but I haven't had much luck finding that. Does anyone know how this is done, or if the approach is wrong, what's the alternative JP. wrote: Hi, I've been trying to write a program in VC++ .NET which controls mouse movement in WinXP. Sadly I'm a little lost ...Show All

• Visual Studio Check in web service that are already under source control for VS2003

  At this moment we are upgrading web services, that are already under source control, from VS2003 to VS2005. The upgrade is successful, but when we want to check these web services in VS2005 is complaining that the *.asmx is already under source control and stops with check in of the other files. For a web service we checked the other files in with our source control manager and reopened the project. VS2005 do not notice that these files (app_code\*.cs) are under source control. Does anybody know what the problem is thanx in advance If you modify the bindings in the solution/projects you're pretty much on ...Show All

• Windows Forms Install issue

  Hi, I'm facing Install issue with Taskvision source and server edition both , issue is that it says unable to locate localhost database please contact system administrator.I've SqlServer 2K sp3 with latest .Net Framework patch (slammer) updates and Win2k server  I've blank  password for sa and I checked the necessary setting ,I'm able to login as sa and I'm  ...Show All

• Visual Studio Team System MsTest command line publish code coverage

  The MSDN2 article How to: Publish Test Results says how to publish code coverage using the UI but it does not say how to do it using the command line. Anyone got any brilliant ideas please Here you have how to publish results from command line, if you want to pulish to TFS, or to data store: http://msdn2.microsoft.com/en-us/library/ms243151(VS.80).aspx If you just want to publish to file, you only need to say to mstest the test run config file you want to use (and has the code coverage configuration enabled) with /runconfig: and also, if you want to another file than the default one with /resul ...Show All

• SQL Server Dynamic Filter Not Updating Correctly

  I have several SQL Mobile devices (WM5) syncronizing with a SQL 2005 database through merge replication. We are using the HOST_NAME parameter to filter several tables. A few of these filters use a sub-query to filter the data because of the complexity of the filter (need to do more than join to one table). The subquery will use the HOST_NAME parameter. For example, I want to get a list of all users in the current user's company I need to use host_name to get the current user, find their company ID, then filter the user table on that company ID. Everything works fine until a user is removed from the table. In that case, the delete stat ...Show All