JCJCJC's Q&A profile

• SQL Server Incremental Update

  Good afternoon, I was wondering if someone could help. I'm busy researching into SSAS's capabilities, specifically Incremental Updates, however this would be the first time I'm working on SSAS, so I don't know where to begin. I've read through the BOL July 2006, and it explains that you have to enable this option; however to me it's not very clear. I followed the steps outlined in the Book; however when I go and update the source table, the partition does not update automatically. Could anyone please let me know if there is a website detailing how Incremental Updates work, and also how to set it up correctly Thanks Colin. Hi Thomas, I managed to get my Fact Partitions to automatically update ...Show All

• .NET Development Anyone has a solution about it?

  I have question here.I can access paradox database using c# with oldeconnection which has connectstring as "this.connect.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath +@"\table;Extended Properties=Paradox 5.x;";",but I couldn't 't access a paradox database with password protection.Anyone has idea to solve it thanks in advance! " Below is an example that uses the ODBC driver. Give it try: Dim ConnectionString As String ConnectionString = "Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=C:\Documents and Settings\...\My Documents\My Database\Paradox;Dbq=C:\Documents and Settings\...\My Documents\My Database ...Show All

• Community Chat Developer Solutions team needs you! Well your ideas anyway...

  Hi everyone, I'm a PM on the Developer Solutions team (I work with Joe), and I need some input from you all. I'm putting together a roadmap for some of our future Power Toys work, and we need some good ideas. I've posted about what I'm looking for over on my blog so if you're interested in helping us out, pop on over and check out my post. Thanks in advance for all the great ideas I know you'll send us. :) -Jeremy Kelley i wouldn't say that, we all know they make linux work with virtual PC because they know once anyone who is curious about it tries it, they won't like it since its hard to use (well for a non-geek anyway) well this would be diffrent, this will make VS appealing to those already in ...Show All

• .NET Development Table Adapter - stop Auto generated files

  I am using a Table Adapter in my Data access layer, built as separate Project. I need the adapter to use the Connection string in the Web.config file of the solution where the DAL assembly will be used. How do I prevent the Settings.settings and Setting.Designer.cs files from being generated when I compile the DAL. If I include the DAL project in my Main solution then will I be able to specify the Web.config connection rather than the connection from the Settings.Designer.cs file! I seem to be confused between using the Settings.Designer.cs and the Web .Config for Table adapters. Where can I find a good resource for this . -Jawahar Thks Charles for ur answer, the first method is working if th ...Show All

• Smart Device Development Device Power Off Event

  I am currently using the Compact Framework 2.0 on a Pocket PC 2003 device and there is a setting in start>settings>system>power>advanced called "Turn off device of not used for x minutes." I am curious if there is a way to catch this event so that I might be able to shut down my threads that are dependant on my 802.11x and then Turn Off. Currently what is happening is that I might have a thread in the middle of an HTTP Post when the device powers off and this is not good. Any ideas would be helpfull. The Poweroff ( MessageID - 537) message is sent to all the top level windows by OS. WParam - 32772 So using MessageWindow Class u can catch this event. protected override void ...Show All

• Visual Basic Help with string manipulation in combobox

  Hello, I have a combobox in which I populated as follows: John Smith - Count 24 How can I change that string in my combobox to read John Smith - Count 23 after I save a record ... and then John Smith - Count 22 and so on... I'm not sure if I could just grab the number value, and subtract it by 1 and then take the result and concatinate it back to the string... Thanks in advance. Hi Rashar, a possible solution is to create a integer variable and set that variables value as 23 dim countvariable as integer = 24 then set the combobox string as "John Smith - Count " plus the variable's value yourcombobox.text = "John Smith - Count " + countvariable.tostring put som ...Show All

• Windows Forms Adding Components to Windows Forms

  anyone have any links on how i would add a component control to my windows form I created a component and now i want it to be inside my panel on my windows form but I cant find much info on the net to help me out though.... well which object is null step through the debugger to see where the problem is on what object is null. Again, try doing just a Controls.Add() if its available, rather than Container.Add() and see what happens. ...Show All

• Visual C# Import methods from DLL wrote on C

  Don't work import from dll wrote on unmanaged language C, do actions [ DllImport ( "Shapes.dll" , EntryPoint = "SwapWord" , CharSet = CharSet .Auto)] extern static public void SwapWord( int lenght, ref wordP); Compiler write error - Don't find entry point in this method. All parameters true. Best regards Maxim Kozlenko - Microsoft Student Partner There is a syntax error in your example, missed a identifier in you second argument. It should be something like: [ DllImport ( "Shapes.dll" , EntryPoint = "SwapWord" , CharSet = CharSet .Auto)] extern static public void SwapWord( int lenght, ref string wordP); ...Show All

• SQL Server SQL 2005 auto-attach vs. traditional databases

  This is my first post on Microsoft forums so please be gentle. I am not a developer, just trying to write some documentation and having a little trouble finding information. Is "traditional" an appropriate term for registering databases the old-fashioned way (not using auto-attach), or is there a better term What are the benefits and drawbacks of using auto-attach vs. traditional database representation It would seem to simplify deployment but present possible administration challenges. Is it possible to control the name of the database when using auto-attach, or must it always be the full path to the file Thanks, I think I will stick with the term traditional. Is it possible to ...Show All

• SQL Server PrevMember Question

  Hello, I am running into an issue where CurrentMember DOES NOT return all members at the lowest level. Here's my dimension Hierarchy --> [Week].[Week].[Week Name] I want to have it return the following when I select [Week].[Week Name].CurrentMember Week of 09/04/2006 Week of 09/11/2006 Week of 09/18/2006 But it is returning at the ALL level All Once I can return all members using CurrentMember, I should be able to use CurrentMember.PrevMember to return Total Revenue for the previous member, same as Lag(1). If anyone can shed some light on how to return all members at the lowest level using CurrentMember, I would truly appreciated! If there's an alternate way of NOT using CurrentMember, please feel free to let me kn ...Show All

• SQL Server Error during bcp: Cannot open database 'XXX' requested by the login. The login failed.

  Using bcp to transfer data from .dat file to Express is getting the error: Cannot open database 'XXX' requested by the login. The login failed. However, if I include the parameter -h "TABLOCK", the bcp has no problem. Additional Info: Multiple bcp commands are in .bat file. Each bcp command transfers data from a specific .dat file to a corresponding SQL table. No one is accessing any of the SQL tables. The error may not occur on every set of .dat files. However, if it occurs in a set of .dat files, it always occurs at the bcp command for the same .dat file. I'm guessing that it may be related to the previous bcp command which has transferred large amount of data. ...Show All

• Visual Basic More than one datareader at the same time?

  How to replicate this snippet of code using Ado 2.0 I mean, you are not able to use two datareaders associated to the same connection. Let me know, how do I such thing, I'm just a newbie with ADo .Net. TIA  sql = "select..."  command.commandtext = sql  set recordset = command.execute   While Not recordset.EOF    sql2 = "select..."  command.commandtext = sql2  set recordset2 = command.execute  While Not recordset2      Wend    Wend   You can have only one reader per open connection. I would take a look at the ADO.NET VB samples here to get started learning ADO.NET 2.0 http://msdn.microsoft.com/vbasic/downloads/code/101s ...Show All

• Visual C++ Vista "for loop" problem

  In code that runs correctly in XP, I have a for loop. 1. for (int nIndex = 0; nIndex < 256; nIndex++) { 2. array[nIndex] = something; ... In Vista, at line 2, nIndex = -856238756375 or something like that, ie. uninitialized. Obviously, this causes a crash. Is this a known bug The best way to avoid speculation is for the original poster to give us a step-by-step reproduction (with a new project) of the problem that leaves out no details, including the version of Vista being run. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Woeful XNA GSE Install

  I've uninstalled my XNA GSE Beta 1 and everything but I get that stupid error message whenever the installer gets around to installing the DX Runtime. I never had this error when I installed GSE Beta 1, so why now You'll have to run that from the command line. To open a command line window hit the Windows Key+R and naviage to the directory where the install is located then type that line in the command line window and hit enter. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Components and Design-time support

  Hi, I build a several game components with lots of design-time support, including custom property editors, custom context menus, etc. This is a good aproach This design-time code will run with XBox 360 project Thanks any help, Jose. Unfortunately it has been announced that design time support will not be included in beta 2, nor the RTM. The feature was removed due to time constraints getting it fully running and tested in the xbox projects. ...Show All