Jae's Q&A profile

• SQL Server SQL Server2005 express Reporting services (error opening new project)

  Please can someone help, I'm tearing my hear out with this problem. Initially, I installed the SQL Server Express edition together with the Management Studio Express. This worked great. Then I decided to upgrade to SQL Server Express Advanced Edition . So, to make my life easier I uninstalled the SQL Server Express edition and installed the SQL Server Express Advanced Edition. This installed without any problems. Then I tried to install the (SQLEXPRESS_TOOLKIT.EXE) which would give me the facility to generate reports. This seemed to install properly, but when I try to open up a new report project inside VisualStudio.Net2005, I get the following error message. Could not load file or assembly 'Mic ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Health Bars

  Hey, I have looked at the spacewar game template, and I noticed their hp bars are just 5 blocks. How can I make a bar like the shield bar in halo 2 A sliding bar I've knocked up an example which shows a sliding based gauge but the principle can be used for a rotating type gauge as well. It may not be the most graceful solution but I can't think of any other way to do it. Here's the code but if someone can recommended a decent place to post the source code zip then let me know. #region Using Statements using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework.Content; using Microsoft.Xna.Framework.Graphics ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3d perlin noise on pixel shader

  I have a mesh which wraps in such a way that I can not get continous texture coordinates all over, so I thought that I would generate the pixel color with a noise function. I want to generate 3d perlin noise on a per pixel basis, where I calculate for example 5 octaves for each pixel and pertubs its default color somewhat with the noise. The thing is.. I feel that this should not be that dificult, but still I have not seen example of this. Some generate 2d textures with perlin noise and then use that texture, but that is not what I want. I want to tage a pixels 3d world position and use that as my noise sample point. I already have a noise function running in the main application, where I hash a 3d position into a float in the interv ...Show All

• SQL Server Connect to SSAS on TCP/IP using Java + execute XMLA

  Hi, I have done this in .Net, but that is easy because you get .Net libraries to help you connect and send XMLA over TCP/IP. I would want to do the same using Java: Connect to SSAS 2005 on TCP/IP, or even SOAP over TCP/IP Then execute XMLA commands and retrieve XMLA responses. How to accomplish this Regards Vijay R Hi Mosha, Thanks a lot :-) I have been quite a fan of yours!! I am currently in the US, any chance that you are here If possible, I was hoping to meet you. No problem anyway, bye Thanks again. Regards Vijay R ...Show All

• SQL Server SSIS vs. Excel's CSV parser

  Hi All, I’ve been battling with a client who’s supplied us with what they consider to be a legitimate CSV file. 1st off let me say that I understand that there’s no CSV “specification” per say, but here’s the situation regardless. The client has a test string in one of their fields that looks something like this: He said "STOP" so, of course he stopped The CSV best practice requires that you double quote, so a valid CSV filed would look like this: He said ""STOP"" so, of course he stopped Once this is placed into a comma delimited CSV it looks something like this "Col1","Col2" "He said ""STOP"" so, of course he stopped","value in col2" --------------- ...Show All

• Smart Device Development regarding memory exception

  hi , i have been in developing application in smartphone using c# .. i am using visual studio 2005 .... for my application i have loaded the resoueces using the following code ... Stream s ; Bitmap img_btYellow; s = this.GetType().Assembly.GetManifestResourceStream("Widgets.res.avblue.png"); img_btYellow = new Bitmap(s); s.Close(); i have loaded 8 '.png' images through the above code using the same stream ' s ' . the application is running fine in emulator .... but it is showing out of memory exception in the exe created inside the bin folder ... even i tried using singleton object for all the classes , that i have used .. but it s still showing the same exception .. could anyone help me in resolving th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. End users shouldn't have to rewrite XNA math functions in order to improve performance.

  The overhead of passing a 64 byte Matrix by value is significant. Most especially when you are comparing two matrices for equivalency (==), or performing a Vector*Matrix multiplication (Vector3.Transform(Matrix)). The following matrix comparison function performs 5-10 times better than your built in == comparison. If the matrices are equal, then it is about 5 times faster. If they are unequal then it fails fast, and is about 10 times faster. public static bool Equals(ref Matrix a, ref Matrix b) { // i check the diagonal first for quick fails return a.M11 == b.M11 && a.M22 == b.M22 && a.M33 == b.M33 && a.M44 == b.M44 && a.M12 == b.M12 && a.M13 == b.M13 && a.M1 ...Show All

• SQL Server Returning multiple attributes from the same dimension at the same level

  This seems like it should be basic, but I can't find any examples that explain if this should be possible, or if I'm just approach the problem incorrectly. I've got several books on MDX and it seems every example uses only one column from a dimension to perform any reports. Let's say I have a customer dimension with the attributes: Customer Id, FirstName, LastName, MiddleName, State, City A standard date dimension and a fact table that tracks Orders. In my Customer Dimension I define a hiearchy that has State, City and Customer Id. With this simple setup, I am able to show Order totals by Customer Id, City or State with no problem. The issue I am having is if I want to write a query that shows order totals by the person, wit ...Show All

• Visual Basic checkbox column

  how to know the value in the column of checkbox column of a datagridview . whether it is checked or not thanks Private Sub Dgv1_CellContentClick( ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles Dgv1.CellContentClick If Me .Dgv1.CurrentCell.OwningColumn.Name = "theColumn" Then If CType ( Me .Dgv1.CurrentCell, DataGridViewCheckBoxCell).Value = True Then 'the what you want to do. End If End If End Sub ...Show All

• Visual C++ Divide without using operators

  I need a code for Dividing two integers but ... without using any operators ie (+,-,*,/) to get the Quotient and Remainder One can use math.h . plz help me thanks..... You know, google won't bite you. http://www.bearcave.com/software/divide.htm ...Show All

• Smart Device Development two-state icons on Windows Mobile 5.0 start menu (grid view)

  Some shortcuts on the start menu of a Windows Mobile 5.0 Smartphone show a different icon when they're selected. The Messaging icon shows the slip of paper poking out of the envelope, for example. Has anyone managed to recreate this with their own applications, and if so, how Is there a convention for how the icons have to be ordered in the .rc file or is there a naming convention Is there a URL talking about this in MSDN Thanks in advance, Matt I'm seeing an issue on cingular 2125 where icons get messed up. Even a reboot does not clear issue. To be clear the wrong icon is shown for a particular app.. i.e internet explorer icon shows up as folder icon. Do you know how to clear this issue ...Show All

• SQL Server Time dimension

  Hello, I have question about time dimension. I have fact table, which contains Named Calculations (Year, Quarter, Month, Week and Day, calculated from column controlDate in fact). I created Time dimension and assigned Year to Years, Quarter to Quarters, Month to Months, Week to Weeks and Day to Days in Define Time Periods page. My problem is that default first day is Sunday, but I want Monday and I don't know where to set this up My results now look like this: Week1 8.1.2003 (Wednesday) 9.1.2003 (Thursday) 10.1.2003 (Friday) Week2 12.1.2003 (Sunday) ..... but I want to have: Week1 8.1.2003 (Wednesday) 9.1.2003 (Thursday) 10.1.2003 (Friday) 12.1. ...Show All

• .NET Development Webservices and dlls

  I have developed a web service and deployed it successfully, on local and remote web servers. A few days ago I added functions that loads a dll (which act as an entry point for a software I'm running). The dll in question connects by sockets to another server and sends some data, and then unload itself. The web service works fine if I use the web server that comes with Visual Studio 2005 but I get an exception thrown on any other web server. "'System.CannotUnloadAppDomainException' occurred in System.Web.dll Additional information: Error while unloading appdomain. (Exception from HRESULT: 0x80131015)" I'm figure there is some permissions that needs to be given to the web service / asp.net user, but I can't seem to find where I set permissi ...Show All

• Visual C++ Pls Help. Urgent!!

  Hi Everyone, Currently I having a problem on pass vb string into c dll. I sucessfully pass the string to the c dll and return the whole string with the codes below: c code to create dll char *ccDecrypt( char *str, char *ostr ){ return str ; } vb code Private Declare Function ccDecrypt _ Lib "C:\Documents and Settings\fpca\Desktop\dll\TestDLL\Release\TestDLL.dll" _ (ByRef str As String, _ ByRef ostr As String) As String Private Sub Command1_Click() Dim deCard As String txtDe.Text = ccDecrypt(txtEn.Text, deCard) End Sub But when i change the str in the c code to str[0], it throw me error... can anyone suggest how to solve this problem Hi, ...Show All

• SQL Server Transform-Pivot in SQL Server 2005

  Is there any equivalent for Transform-pivot of MS Access in SQL Server 2005 I have this query in MS Access that I need to migrate to SQL Server 2005 TRANSFORM Sum ( CD1 ([CheckAmount])) AS [The Value] SELECT "Total Amount of Checks" AS Type, tblResult.AccountNumber, tblResult.CheckDate, tblResult.Status, Sum ( CD1 ([CheckAmount])) AS Total FROM tblResult GROUP BY "Total Amount of Checks " , tblResult.AccountNumber, tblResult.CheckDate, tblResult.Status PIVOT IIf ( IsNull ([statusdate]), "Outstanding" , Format ([StatusDate], "Short Date" )); Table columns: Autonumber,AccountNumber ,C ...Show All