bes7252's Q&A profile

• SQL Server Aggregate() doesn't aggregate over an expression

  We use CTP3 of SQL Server 2005 SP2. We have the following scope expression Scope ( [Date].[Calendar Year].[Calendar Year].Members, [Date].[Month].Members ); ( { [Measures].[Profit YTD] } ) = Aggregate ( PeriodsToDate([Date].[Calendar].[Calendar Year], [Date].[Calendar].CurrentMember) , StrToMember(Extensibility.Replace([Measures].CurrentMember.UniqueName, " YTD", "")) -- remove " YTD" suffix to aggregate over the corresponding standard measure ); Format_String ( This ) = "Currency"; End Scope; However, Aggregate() essentially bypasses the call to the SSAS stored procedure (Extensibiliy.Replace is a custom SSAS stored pr ...Show All

• SQL Server SQL SP1 build 2047 installation error

  Hello, I am having problems installing the SP1 for SQL server 2005 on a W2K3 R2 server. It appears that the Database Services and Analysis Services are not being updated. I would appreciate any help with this if anyone has seen or had experience with this issue. Thanks, the basic log file is listed below. Redist9_Hotfix_KB913090_3.log 09/17/2006 19:15:53.408 ================================================================================ 09/17/2006 19:15:53.408 Hotfix package launched 09/17/2006 19:16:57.719 Attempting to install instance: SQL Server Native Client 09/17/2006 19:16:57.735 Attempting to install target: HOSPSQL 09/17/2006 19:16:57.735 Attempting to install file: sqlncli.msi 09/17/2006 19:16:57.782 Attempting to ...Show All

• .NET Development howto AppendPrivatePath in 2.0

  yet another migration question from me (I'm on a theme here). in 1.1 (in 2.0 too but with a compiler warning) I can append the private path of the default app domain using the AppendPrivatePath method. the 2.0 compiler compliains that I should use the private bin path of the appdomain setup info, but the problem with this is, that thats not accessible for the default app domain. I suppose the answer would be to specify that in the app config and I suppose thats what I'll end up doing (even though thats a lot of stuff I then have to change), but wanted to look stupid by asking if there was an alternative similar to AppendPrivatePath. The app I'm working declares its private bin path (for al ...Show All

• SQL Server Deploying SQL Express 2005

  Hello, I work for a company that manages computers and their software using Active Directory. One of our packages requires SQL Express 2005, and so far I've been unable to find a good resource online. All I need to do is find a .msi file or a batch script that will install it. Thanks! ...Show All

• SQL Server Problem with output parameters that are varchar and null

  I am using version 9.00.2047.00 SP1 of Visual Studio 2005. Using ADO.NET, I have been unable to get the Execute SQL task to successfully return the value of an output parameter defined as varchar or nvarchar when the value is null. No other data types seem to have this problem, including the sql_variant data type. Here is the stored procedure I am calling: create proc spx @in int = null output, @vc nvarchar(10) = null output, @dt datetime = null output as select @in = null, @vc = null, @dt = null return The variables to which the three output parameters return their values have a data type of Object. The task runs fine when the integer or datetime parameters are used, and the variables can be identified as null using IsDBNull ...Show All

• Visual Studio Team System AssemblyInfoTask default Versioning Flawed?

  Is it just me, or isn't the notion of versioning defaulted to by the AssemblyInfoTask http://www.gotdotnet.com/codegallery/releases/viewuploads.aspx id=93d23e13-c653-4815-9e79-16107919f93e  fundamentally flawed. Assuming major.max.build.revision. Everyone using this task, including Microsoft, seems to be using the strategy that the build number is specified to be DateString with a format of yymmdd, you get something like 061117 on the day of this post or the following if we accept the defaults: 1.0.061117.00 First of all, the actual number (since it gets converted to an integer) becomes 1.0.61117.0 when it gets compiled.  Most importantly, if this was next year (2007) at this time, you get assemblyinfo files u ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where fro art thou System.xml?

  I was using the System.XML namespace in my XNA project for storing definitions, the XMLRead and XMLwrite functions proved very usefull. After upgrading my project to Beta2, the System.XML name space is no longer recognised. is this by design due to the XBOX compatability issues or have i missed something. If XML is nlonger available whats the best medium for sturing structured informationin files now Darkside Look at %XNAINSTALLPATH%/1.0/References/Xbox360 (Variable %XNAINSTALLPATH% does not exist) there is a file system.xml.dll, so I would say System.XML is supported on the Xbox. ...Show All

• Visual C++ Trying to reference objects in another project: errors LNK2028, LNK2019

  Hi Can anyone make head or tail of the error message below I have a project that sets up a port for me, that I want to reference from my project so I can send data to the port. But I get this weird error - which I suspect is something to do with \clr and the constructors / destructors for the Port class... Microsoft docs haven't given me any clues. The Port class compiles fine as a dynamic dll using \clr, but I can't get the two to work together Error 26 error LNK2028: unresolved token (0A00030E) "public: virtual __thiscall Port::~Port(void)" ( 1Port@@$$FUAE@XZ ) referenced in function "void __clrcall `dynamic atexit destructor for 'm_port''(void)" ( __Fm_port@@YMXXZ@ A0x485da573@@$$FYMXXZ ) AHF_Download. ...Show All

• Smart Device Development short alignment issue

  I'm seeing something very weird when compiling this code for an ARMV4i Smartphone target and running it on a smartphone emulator: INT foo(UINT16 *srcPtr) { short data; data = *(srcPtr+1); switch (*srcPtr) {... } If the memory pointed to by srcPtr contains: 11 22 33 44 55 66 77 88 data is set to 0x88776655 (endianism isn't the issue, but 32 instead of 16 bits is - it should be 0x4433) *srcPtr is evaluated as 0x44332211, again 32 instead of 16 bits, it should be 0x2211. Any ideas Cheers, Ken I can't get VS2005 to create Smart Device projects, so I'm going to play blind here. With the following code, does the address for srcPtr and dataPtr differ by two bytes s ...Show All

• Community Chat Kyro KidSafe Browser (beta)

  Hello all, I am making a "KidSafe" browser for kids. Please download my program and post any noticed bugs,etc.  It takes only minutes to set up.  I am 10 years old, so who can make a browser for kids better than a kid Progress:  Final will be started in January Thanks you everyone for your contributions  and encouragement.  *Has 3 tabs for browsing. *Has a "My Websites" button with up to ten of your programmed websites in it. Beta Features: *Has 3 tabs for browsing. *Has a "My Websites" button with up to ten of your programmed websites in it. *Talking Help guide *A new install program Updates in final version: *Button text replaced with graphics. *A game room with games, and fun KidSafe software (suc ...Show All

• Visual Studio Express Editions Listbox

  I have a listbox that get info from a databse access, it only show the name, but I want to show name and surname in the listbox. Me .lstNameAndSurname.DataSource = Me .BindingSource1 Me .lstNameAndSurname.DisplayMember = "Name" I have try to get it to work, but I am doing something workg Thanks I did the following 1. Went to listbox on form 2. Went to Add Query in the Listbox Tasks 3. Make a new Query and with this info select Naam+''+Van as name from Sondagskool 4. When I press Ok it gives me the following info The schema returned by the new query differs from the base query. I am quit a dummy here as I don't know what to change or do here ...Show All

• SQL Server Web Sync Wizard On XP Box

  I have (finally) successfully gotten through the maze and 'published' my database to a folder: Physical path: I:\SqlReplication unc: Warrenassoc\SQLReplication Since I'm running XP pro, I don't have the options of assigning specific read/write permissions to a folder. However it appears the problem is with accessing the snapshot and the logon's there. When I run the IIS Web Configure wizard I error out at the snapshot share permissions step (see report below) Wizard Settings: Click Finish to perform the following actions: Modify a virtual directory immediately. Copy the ISAPI dll 'sqlcesa30.dll" to 'I:\SqlReplication" immediately. Set NTFS permissions immediately. The virtual directo ...Show All

• Visual C# class inheritance question......can't figure it out

  I'm trying to do the following: public class BaseClass { public static int variable = 2; }; public class ClassA : BaseClass { } public class ClassB : BaseClass { } class Program { static void Main(string[] args) { ClassA a = new ClassA(); ClassB b = new ClassB(); ClassA.variable = 3; ClassB.variable = 4; Console.WriteLine(ClassA.variable); Console.WriteLine(ClassB.variable); } } basically I need a static variable in BaseClass but when ClassA and ClassB inherit from BaseClass, each one needs to have its own variable. Is this possible Should it be done a different way variable has to be static though. ' Also, the reason the static variable must be in the base class is b/c the base class is the only one to acces ...Show All

• Windows Forms Current user

  How can I get the user that is running a winform application with c# The users connect to a domain with active directory. Thanks Hi Manuel5, I know there is an another way to obtain the current user name. WindowsIdentity wi = WindowsIdentity.GetCurrent(); MessageBox.Show(wi.Name); But I doubt the password could be obtained easily. ...Show All

• Software Development for Windows Vista How to render video from array

  Hi, How can I render video frame by frame from array of char and not from File   My problem is that I am receiving raw data from the network and I need to display it in real-time.   Thank you.  I assume you are using c++ Probably your best bet is to create your own source filter. When I did this, I started with the PushSource sample. Mostly you need to implement the FillBuffer method. For c# I'd point you somewhere else. ...Show All