curly_cam's Q&A profile

• SQL Server Excel "Damage to the file" Error When Exporting With SSRS 2005

  I am getting an error: "Damage to the file was so extensive that repairs were not possible. Excel attemted to recover your formulas and values, but some data may have been lost or corrupted." in some instances when exporting toexcel. The report is no different than any othere report. This report uses rectagles and text boxes to control layout with two tables but it's pretty straight forward. This only happens for this particular report when exported only to Excel. I am using SQL2005 SP1. Any ideas, thoughts, or references are welcome. I can't believe noody answered this yet. I saw the same behavior and the only way we got it to work is to re-publish the data associated with that report AND ...Show All

• SQL Server Unable To Commit UPDATE CUBE via Excel VBA

  Hi, there, I have a SSAS 2005 cube. I write enabled the fact partition in the cube. I can see the writeback table created in the relational database. Next, I run the Excel vba that performs writeback. I can write back but the writeback is not permanent. I know I need to commit the update transaction but whenever I tried to commit using ADODB's .CommiTrans, I got the following error: "Run-time Error '-2147467259 (80004005)'" The writeback fails at the commit statement. FYI, I have full control (Administrator) over the cube. What will be the possible causes Thank you. Regards, Yong Hwee   Hi, I've resolved this. It was due to the issuing of CommitTrans before i ...Show All

• SQL Server Temp tables or Joins

  I had a SP to generate a recordset for a MIS report. It had 11 temp tables , basically taking data from real tables , performing some aggregation and counts and passin on the records to a temp table which gave the result as desired ..ofcourse with some group by clauses... Now i replaced these temp tables (most of them..left with just 2), and used derieved tables instead in the final query..and joins which will execute with each query iteration..something of the sort select col1,co2 , (select count(id) from sometable x group by sayaccount where x.id = temp.id) , (select sum(id) from (select count(id) from sometable group by sayaccount) DERIVED_Tab), ...... from #finaltemp temp group by col1..... ...Show All

• SQL Server Optimising Merge Replication for both server and client subscribers

  I need to merge replicate data to two different types of subscribers: Clients subscribers which will have a very small percentage of the data from the central database. The data on these machines will be managed using dynamic filtering on host_name() Server subscribers which will manage a copy of all the data from the central database There will be far fewer server subscribers than client subscribers. As I see it I have two options for the configuration 1) Use two separate merge publications – one which is filtered and one which isn’t 2) Use a single merge publication and setup the filtering so that the server subscribers receive all the rows Which option is likely to lead to better performance ...Show All

• Visual Studio Set toolbox list at runtime

  I would like to set the list of toolbox at the runtime. I assigned a property in my DomainModel; SetRoom, that defines string of a file's name and its address. Can I make the list of toolbox based on that file Lets say the file is Room.txt, inside there are Suite, Deluxe, and Standard text. I want to make the geometry shape toolbox of these types of room. And later on, if I add a new type of room in the file, lets say President Suite, I want a new toolbox of that type generated. Is this possible Thanks! Herru Hi Herru, you can override the CreateToolboxItems method in your ToolboxHelper partial class to do whatever you like at startup. You can then use regular DTE or VS SDK interfaces to manipulate the toolbox later. ...Show All

• Visual Basic DATABASE READ HELP

  Me.Table1TableAdapter.FillBynamelike(Me.STOCKDataSet.Table1, textbox1.text ) i made a data base tableaapter and filled with above command 1) now i want to create a command so that number of rows in this dataadapter are received which i can display in my application 2) go to first row and display its fields in application Hi. 1) Me . Table1TableAdapter .GetData Bynamelike ( textbox1.text ).Count This will return the nunber of rows on the Table Adapter. 2) Me .STOCKDataSet.table1(0).field Like this you can show the value o field at record 0. Best regards. dp ...Show All

• Visual C++ std::list has changed in VS 2005

  It seems like std::list implementation has changed in that it now uses the & operator on elements of the list type. The difference between VS2005 and VS2003 implementation can be seen in the _Buynode( _Nodeptr _Next, _Nodeptr _Prev, const _Ty& _Val) method (line 1152 VS2005, line 915 VS2003). The problem with this is that if the & operator for the type is overloaded, the same code that used to work in VS2003 will no longer compile in VS2005. When the type used is a built-in type like _com_ptr_t, which overloads that operator, it is no longer possible to have a list<_com_ptr_t> type. Does anyone have a resolution for this This is always a problem for objects in container t ...Show All

• Visual Studio 2008 (Pre-release) Installation Issue

  Hey gang. I have installed the August CTP so I can try some of the code generation but I am not seeing the template in my project listings. I am running on Vista. Any clues Any help would be greatly appreciated. Please tell me a little more about your environment. Which build of Vista are you running Which version and build of Visual Studio There is a chance that this is due to an incompatibility between Vista and VS 2005. One thing that we can check is to see if the template files were installed correctly on your hard disk. Please look at: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ProjectTemplates\CSharp Do you see the ADO .NET vNext project template folder ...Show All

• Visual Basic using windows service... urgent help

  hello, This is my first time in Window service... I've written my Window service... well my windows service is running already, i assume... coz my windows service can be seen already in server explorer... however... I want to use my window service in another application... I 've declared one protected event in the window service... is there any way i can raise that event in my external application well here is my code... of the window service... Public Class MyService Protected Overrides Sub OnStart( ByVal args() As String ) Timer1.Enabled = True End Sub Protected Overrides Sub OnStop() Timer1.Enabled = False End Sub Protected Event ReturnTime( ByVal TimerReturn ...Show All

• SQL Server SQLCMD sometimes fails to connect

  Hi, I have a set of .sql scripts that I use to create a database with. Some of the scripts are quite large as they are made up of concatinating all my individual stored procedure .sql files. I run all the scripts files from a .bat file using SQLCMD to execute the .sql files. I have found that just recently I often get SQLCMD failing to connect as the specified user half through the batch. It seems to be linked to the size of .sql file it had previously run. The error I get is: Msg 4060, Level 11, State 1, Server MYSERVER, Line 1 Cannot open database "test" requested by the login. The login failed. Msg 18456, Level 14, State 1, Server MYSERVER Line 1 Login failed for user 'sa'. If I run the individual .sql files ...Show All

• SQL Server Understanding Estimated Execution Plan

  When I generate an estimated execution plan from Management Studio, one of the things I often see in the execution plan generated is an 'Index Scan'. When I put my mouse over the 'Index Scan' graphic, I will see a window display with something called 'Output List' at the bottom of the window. Do I understand correctly that SQL Server will scan my index looking for values in each of the fields included in this output list Thanks, Amos. Output list is nothing but the list of columns that will be projected from the operator (scan or seek). So this will relate to say the column(s) that are required for the join and/or referenced in the SELECT list of the query for example. There is a parent topic in the lin ...Show All

• Windows Search Technologies Windows Desktop Search won't start & I cannot remove it

  I recently upgraded to the most recent version of Microsoft Desktop Search. From the Admin account it seemed to be operating perfectly. When I logged off and then on to another account It gave me an error. It suggested that I remove and reinstall. I did and encountered the same problem. I was going to uninstall it, but it has disappeared from my "Add or Remove" list of programs. HELP! Paul, Thanks for getting back to me. Everything was done under the administrator account. I've tried to re-install, but I get the same problem. I cannot un-install the windows desktop search program because it is no longer on the list of programs under add/remove programs. John ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Distribution

  I am trying to get a very simple 2D XNA game to run on other peoples machines; but when I send them the relevant files, they all complain of getting some form of error report. They all claim to have the requirements (XNA Framework, latest DirectX and .NET Framework 2.0) installed, but it seems something, somewhere isn't doing its job. One of the people in question only has a Radeon 7000, so it is understandable why it isn't working. But the other two have a GeForce 6800 and a 7300GS which should be more than enough! I have tried both ClickOnce installers and binaries from both Debug and Release directories. They all worked fine in folders on my machine, but on other computers the installers installed fine, but just throw up a windows error ...Show All

• Windows Forms Error 2203 when installing MSI packages I created with VS2003 - just problems with my profile

  Hi Suddenly, my MSI packags have stopped working. The packages I create all fail with error " The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2203 ". This happens for packages for existing solutions, and also for any new package I create from scratch. There I assume it must be a generic problem with the installer or VS, rather than a problem installing one particular program. It happened when I made some changes to souce of a project, re-built the package. Note that the packages run fine on other people's computers. Note also that it runs fine on other profiles on my machine - thus it might be a problem with my profile o ...Show All

• Software Development for Windows Vista codec selection for RTC SDK

  As i am using RTC (SDK) with C#. I found a bit problem with its default codec selection. As the best codec and the frame size will be selected for different conditions. The changes will happen dynamically during the call. But i want to do it manually i want to select my own codec among the available and supported codec list. So is it possible to do so if yes than how I don't recognize the acronym RTC. However, if you are using DirectShow, you can either build your graph manually, or look at using IAMGraphBuilderCallback. ...Show All