Kamii47's Q&A profile

• SharePoint Products and Technologies Displaying Workbook using external data with periodic refresh in EWA

  Hello. I have a very simple workbook containing a Pivot Table that is populated by an external data source (SQL Server 2005 database). The connection properties of the external data source are configured to Enable background refresh, Refresh every 1 minute, and Refresh data when opening the file. The connection is configured to use Windows Authentication. The workbook resides in a Trusted File location. When I open the workbook in Excel 2007, the refresh works fine. No problems. When the workbook is opened in EWA, it appears to load a cached (old) version of the workbook, then the first time a refresh occurs, the Data Refresh Failed message is displayed. I have closely followed the "instructions" provided at http://technet2 ...Show All

• Visual C# Send command-line argument via C#

  I asked earlier about exporting an entry in the registry and rec'd a great reply, suggesting I use File + Export in regedit.exe to backup an ODBC DSN. It was suggested I use Regedit's command line switches and run this with Process.Start(); NOTE: I have had success exporting a selected DSN by directly opening a command prompt in Windows and using the /e command line option, i.e. regedit.exe /e myFile.txt HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ myDSN This returns a usable file containing the DSN configuration data, which I can also use for importing (restoring a DSN where a system has crashed). However, as regards the usage of Process.Start() to open a command prompt AND then SEND the above command switch to the open Window ...Show All

• Commerce Server Upgrade wizard crashing

  I am trying to upgrade from CS2000 using the CS07 Upgrade Wizard. Not very long after the process has started it crashes on me. The last entry in the CS2007Upgrade log file is 01:56:59: <OrdersComponent:MigratePurchaseOrders>: Error: Failed to create marshall dictionary object into object model: Failed to read data from the commerce dictionary. There are 17 consecutive entries like this then boom! The ExceptionOrders.log shows nothing. There is nothing showing up in the event log. It actually migrated some data but it is less than 1%. Toughts ...Show All

• SQL Server Standard Edition - Product Level Is Insufficient

  I developed a package in BIDS which simply runs a query, does a data conversion on one field, then exports to Excel. This works fine in BIDS. When I import the package to the server, I receive the Product Level is Insufficient error for both the data conversion component and the excel destination. I have verified that SSIS is installed and the service is running. I have verified that SP1 is installed. Some other things about the environment: - Running x64 versions of Windows and SQL 2005 - Did not install the workstation tools on the server Any suggestions I am not sure if that is the cause of your problem' but since you are running in a 64-bit machine, make sure you have 64-bit version of the drivers the ...Show All

• .NET Development Updating Access database

  Hi I have created a datatable with an SQL statement from an access db to populate a datagridview. I have solved most of the updating back to the database. Some of the columns in the datagridview display hrs and mins, they are stored as decimal in the database, when these are updated and then the save changes button is pressed the data is saving ok, i then try to recalc the totals but these are 1 action behind, for example if a add 1 hour to a column then this hour is not shown in the totals, if i then add 2 hours and click save changes then the first addition of 1 hour is displayed in the totals. If i create a msgbox in between my code and then click to close the msgbox and the code continues and now the totals are updating. It seems by ...Show All

• SQL Server dimension design

  In my telco cube, I want to analyze usage. Eg how much sms's a subscriber has sent. The fact table is completely denormalized and has lots of columns with different types of usage. For example, following columns occur: MO_VOI_PEAK MO_VOI_OFFPEAK MO_VOI_WEEK MO_VOI_WEEKEND Now the sum of these fields overlap. Evenings during the week are also offpeak... This is only an example. Different categories occur for different products, like voice, sms, mms and so on. And not all categories apply to all products. Eg, mms does not have the peak and offpeak distinction. Is it possible to put this into one dimension, without aggregating double I have already normalised the fact table, meaning tha ...Show All

• SQL Server A lot Of Questions!!!

  Good Morning.. i have started developing on DTS recently. and i have a few question about "How-To" issues. Hope you guys can help 1) I noticed, whenever i want to "redirect row" whenever an error happen, i need to set my AccessMode to OpenRowSet... This mode as i noticed, cant be used when i am tranferring data into a sql table which has primary key set e.g. Ms Access which has identity -> SQL table with PK set Is there anyway, to capture the row error in my situation 2) Another question is, in a data flow... can i have a source which has multiple output arrow. Sorry for the inconvenince,Thank you in advance Hi Phil thanks for the fast reply I am ...Show All

• SQL Server syspublications ..is there a known issue.?

  Hi, I have two publications on a database. One Merge Replication and one snapshot replication. When i run select * from syspublications i see only one row. (snapshot). I am not able to see the record for the merger replication. I am a dbo and administrator on the system. Is this some known issue I am surprised. Have any one else noticed this Or am i missing something obvious Cheers Mohan Thanks Greg. I missed that. But still wondering why create a syspublications table and not have all publications in it. Any way thanks for the sharing. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 2D Sprite?

  Ok i know I have found this topic some where in this forum but now I can't find it. What do I use to create a 2D Sprite in C++ with D3D9 Yes, ID3DXSprite is good... and look at this nice goody by AGPX ... Initialize with: ID3DXSprite *spriteDrawer = NULL; D3DXCreateSprite(pd3dDevice, &spriteDrawer); Load your sprite with: IDirect3DTexture9 *sprite = NULL; D3DXCreateTextureFromFileEx(pd3dDevice, L"c:\\MyWellSprite.png", D3DX_DEFAULT_NONPOW2, D3DX_DEFAULT_NONPOW2, 1, 0, D3DFMT_UNKNOWN, D3DPOOL_MANAGED, D3DX_DEFAULT, D3DX_DEFAULT, 0x00FF00FF, NULL, NULL, &sprite); All the pixels of color (255, 0, 25 ...Show All

• Visual Studio Team System TFSWarehouse shows data but reports come up empty

  Hi, The built-in reports (e.g. remaining work, related work item, etc.) that come with the project template show 0 for number of work items. I checked the warehouse database tables and do see the changes to the existing tasks. I've enabled the security permissions in the Team project, the SQL Server reporting services and the Windows share point service admin, but still don't see improvement. The number of work items shown in the reports is 0 no matter if I use VS2005, the report site or the project portal to bring them up. What else can be missing What can I try Thanks. Hi, thanks, I figured it out. The default fields used by the reports are not the same as those used in the work items, so the report ...Show All

• .NET Development IIS 6 connection to SQL Server 2005

  Hi, I have an aspx page with a connection to SQL Server 2005 which works fine on the local VS2005 setting. When I deployed it to an IIS 6 box it could not establish the connection. Could someone help shed some light Scenarios, Local to sql 2000 -- OK Local to sql 2005 -- OK IIS box to sql 2000 -- OK IIS box to sql 2005 -- Error The connection string is, "Data Source=DBServer;Initial Catalog=DB;User ID=uid;Password=pwd;Pooling=true;Max Pool Size=50;Min Pool Size=10;" I get the error message SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a conne ction to SQL Server) If connection string is, "Network=DBMSSOCN;Data Source=10.10.1 ...Show All

• .NET Development HtmlDocument.Images

  Hello, I get the HtmlElemenCollection object, after I call HtmlDocument.Images. I get the src attribute of the image, however it comes in the format: file:///C:/Documents%20and%20Settings/azabobonin/My%20Documents/My%20Pictures/Einstein.jpg Is there a way of getting it the way it is written in the Html Document :c:/Documents and Sett... etc...). You can get it the way it is written by using mshtml.HTMLElement.getAttribute("src", 2), but I can't use mshtml object. Thank you. Then a regular expression parser could be your friend. In this case I will use the static replace instead of creating a new object. using System.Text.RegularExpressions; public static void ReplaceSpace() { ...Show All

• SQL Server How can I find if the SQL server 2005 installed is a 64bit or 32bit?

  I am about to work on a SQL server 2005 migration and I have no clue what SQL server 2005 is as I have been working on 2K all along. Fist of all I am not sure if the given box is having 64bit or 32 bit Operationg System Second of all I am trying to find if the SQL server 2005 installed on this box is 32bit or 64bit Thanks in advance, sk As Jens mentioned, you can issue a query to SQL Server "SELECT @@VERSION" which will return something like the following: Microsoft SQL Server 2005 - 9.00.2047.00 ( X64 ) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition ( 64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1 To find out if your operating system is 64bit or ...Show All

• Software Development for Windows Vista Problem with ManagementClass API, probably linked with Media Center update

  Hi, We have designed an HTML application for the Media Center (2005 edition) : an applet is downloaded from a web server located on another PC. In order to check that the applet has been downloaded from the local network we have implemented a .Net security policy giving fulltrust to assemblies coming from the same subnetwork. The corresponding condition is called LanMembershipCondition (see below). At first the ManagementClass APIs was used in that membership condition in order to get the collection of network adapters so that the Subnet mask was dynamically retrieved (1). And it worked fine ! But one day it stopped working, because of an update of our Media Center : the application could not l ...Show All

• Smart Device Development How to convert simple desktop application to smart device application?

  How to convert simple desktop application to smart device application Can it be done Of course it can be done - I've done it. However I doubt whether anyone could formulate a methodology. The main problem is redesigning the forms. Smart devices have much smaller screens. Smartphones have no buttons. I had to divide large forms into several smaller ones. If your app is complex, you'll probably have to re-think the whole GUI. I had much less of a problem with non-displaying classes. Sometimes I had used a method that wasn't supported by Windows CE, but there was always an alternative method or a simple work around. Just throw everything at the CE compiler and work through the error list in the time-honored m ...Show All