Penicillin's Q&A profile

• SQL Server ParallelPeriod, Subcubes, and SP2

  We're defining some KPIs that include trend expressions which use the ParallelPeriod function to calculate the change in a KPI value since a past time period. For example, we calculate the change in the KPI value When we use an MDX SELECT with a WHERE clause that specifies a time slice, the expression evaluates correctly. However, when we use CREATE SUBCUBE to do the filter, or use BI Studio (which creates a subcube), the result is incorrect. In particular, the there's an IsEmpty check for the parallel period of the KPI value, so we're not doing bogus math when there's no data for the previous period. With the WHERE clause, that works fine, but with the subcube, the ParallelPeriod always evaluates to empty. As a point of comparison, I t ...Show All

• Visual C# Creating Taskbar icon

  Hi. Your help is very much appreciated. I am writing Win App using C#, framework version 1.1. My app starts with taskbar icon. By clicking theicon, the main window will show. The main window SHOULD NOT be available unless the icon is clicked. My problem: the main window is ALWAYS available. I tried to hide it, but by using Alt+Tab, the user can still see it. (In my code I used the .NET's notifyIcon component). Any ideas Thanks Roy Thanks for the reply. I tried to do what you suggested, but the hidden form is still visible through Alt+Tab ...Show All

• Windows Forms DataRelation

  Hi, I need to create datarelation. I have trying to do this by standart ways but it gives me an error. I know that main table don't have some IDs that child table has. How can I solve it Thank's Alexei Hi, 1. When I use constrate I have the error that parent and child have not same IDs. 2. When I use not constrate I have error in datagrid that I can generate data in it - missing rows. How can I solve it Thank's Alexei ...Show All

• Software Development for Windows Vista DeleteFile, then MoveFile Fails. is Delete Asynchronous?

  I am currently having problems DeleteFile (or what i believe to be DeleteFile). If I delete a file, check if the file is deleted with DoesFileExist (it is) then use MoveFile to a file with the same name/location as the that was just deleted, I receive a Error 183, can't move file because a file with that name already exists. I am doing this in Vista Beta 2, and the test was conducted in the C:\ProgramData folder. If the same test was conducted in a directory in Program Files, the files were virtualized and the same error was not seen. Also if a sleep for 1 millisecond was entered directly before the MoveFile no errors were seen. Is this a known issue or has the DeleteFile been changed No one has the file open. I still see the error. ...Show All

• Software Development for Windows Vista WritePrinter doesn't work with "FILE:" Port.

  Hi all!!! I made following code and compiled it with 2003SDKSP1. In order to test in VISTA RC2, I changed the port from USB001 to FILE: in printers properties. But It showed error message like "Error - Printing" after running. Actually, It works well with 9x,2k and XP. Any help would be appreciated Thanks, JMH HANDLE hPrinter = 0; DWORD dwBytesWritten=0; CString strDocName; DWORD dwFileLength = 0; char szData[512]; strcpy(szData,"TEST TEST TEST TEST TEST"); if (OpenPrinter(szPrinterName, &hPrinter, NULL)) { DOC_INFO_1 DocInfo; DocInfo.pDocName = "TEST"; DocInfo.pOutputFile = NULL; DocInfo.pDatatype = _T("RAW"); if (StartDocPrinter(hPrinter, 1, (LPBYTE)&DocI ...Show All

• Visual C++ How to move up (move down) select item in a CListBox?

  thanks. You can use DeleteString and InsertString combination to accomplish this. AFAIK, there is not direct function to acomplish this. 1. Get the string you want to move, you can use GetText function 2. Delete the item and store the index and string 3. Insert a new string at (index + or- 1) location for going up or down ...Show All

• SQL Server Is it Possible When the time of Implement SSIS Package show Windows and ASk SERVER NAME ,DB NaME ,PAsword

  Hi, now i am currently using SSIS Package using BUI, The Source and Destination File we Given Manullay Connect the Server name ,And Table . Instead of given Manual . How to create Global Variable Connection Manager. Suppose Today i am Working Developement Server. Latter i will be changed Production Server Database. At That time we have to Going to Modify all the Connection .Instead of This How to Create the Connection Manager Gloabe Variable . and How to Use .Please Any one give Sample For Connection Manager variable for Different Server. Thanks & Regards, Jeyakumar.M chennai Just be sure you want userid's mentioned in a plain-text xml file. Personally, where possible, I would suggest windows authe ...Show All

• Smart Device Development a deployment question :)

  Our application has some configuration values (server IP and server port). Until now, those parameters were set in the cab project that wrapped the exe with other resources. The process above was done by a programmer, but now we want to give this task to a non-programmer (which means that he/she doesn’t have VS installed on his/her machine). Is there a nice & clean way to make a CAB without the need to install VS (just to make the cab project..) Oren You can use cabwiz.exe to create a CAB file for your PPC devices. See MSDN article here http://msdn2.microsoft.com/en-us/library/aa458948.aspx Manav ...Show All

• Windows Forms design aspect for populating my DataGrid in 3-tier application

  Pls, 1/ When we have a datagrid for ex. in our form and we don t want to put too much code behind the form. I guess, Normally, we access a business class clcBusiness. then clsBusiness access a datalayer clsData. And let s say the datagrid is populated according to a textbox value that the user fills in. How do I populate the datagrid of my form without puting too much code behind my form. In order to do that, I guess I should call the business class, right.  but what is the buisness class supposed to get as an input value and what s it supposed to return to me, a dataset or a whole datagrid object populated and ready to go. Do I pass the datagrid of the form to the business class as a ByRef variable or do ...Show All

• Microsoft ISV Community Center Forums Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional

  This problem has been mentioned by many other users (in a different thread subject), so I wanted to start a new thread. I have tried many suggestions, but none have worked for me. My MODI has been a print option for me until just recently. It disappeared from my printers folder. I have repaired, removed, and re-installed Microsoft Office. The MODI will still not appear in the printers folder. Please Help! Mine disappeared without any software updates except for the automatic ones. I was on XPSP2 and Office 2007 and it has been there since the original installation. What make it go away ...Show All

• Visual C++ How do I stop pupups from occuring in Com objects?

  My application is using COM to communicate with a 3rd party app. Specifically, I create an interface to a CComPtr<> by calling CoCreateInstance(). This all works great, but there's one problem. The 3rd party is not supposed to have popups. But it seems it does is some error conditions. So, is there a way I could detect when it has a popup It's ok for me to just kill the process when it has a popup, but I need to detect when it has one. Or even, is there a utility that will look for popups from any application and kill the application if it ever presents a popup That would work also. Thanks for any help, Scott Hello Re: How do I stop pupups from occuring in Com objects Such questions are outs ...Show All

• Visual Studio Tools for Office Cant change MS Word properties using DCOMCNFG

  Whenever I log into the dcom config application and try and change the properties for Microsoft Word - it says the operation completed successfully. It does not let me change the properties for my MS Word application - MS Word 2002 installed on the machine. What am i missing here Many Thanks Rajesh Hi Rajesh This is not the proper forum to discuss Word configuration issues - it's for discussing the VSTO technology. I'm not familiar with dcomcnfg and have never heard of anyone using it before to do anything with Word. But after a quick scan of the Knowledge Base it looks like it's meant for developers to use for changing configurations so that (remote) applications can run. You don't ...Show All

• SQL Server Question on restoring encrypted databases on different servers

  I have run into problems trying to use backed-up encrypted databases. I have an ASP.Net/SqlServer 2005 website for which I have production, test, and development environments, each on its own box. I have set up encryption using Master Keys, Certificates, and Symmetric Keys using the following commands: CREATE MASTER KEY ENCRYPTION BY PASSWORD = ' password ' CREATE CERTIFICATE CERTIFICATE_NAME WITH SUBJECT = ' My Website ' CREATE SYMMETRIC KEY KEY_NAME WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE CERTIFICATE_NAME . All databases have the same certificate and symmetric key names. The Production database has a different password than the development and test databases. I am running into proble ...Show All

• SQL Server Setting up Client PC to access remote SQL Server

  Hi, I am a VB6 programmer and I'm really new to SQL Express, I have always used ACCESS because it was so easy to deploy. I've now written a VB6 program which uses SQL Express and I want to know how to deploy it. Basically my PC will host the SQL database as it has SQL Express loaded onto it. I now want to install my EXE onto other Client's PC and have them read/write to the database on my machine. Besides the EXE program, what software do I need to load onto the Client's PC so they can access my SQLExpress database... (eg: Net Framework, SQLExpress, etc). Also, if my machine is called ABC123, in my connectionstring do I just put in ABC123\sqlexpress as the datasource.. . Will this be enough for the other PCs to connect to mine ...Show All

• .NET Development How can I control my keyboard in C#?

  I would like to write a program like in-screen keyboard. I face a problem that I do not know how to output a key to the system which like I am pressing the real keyboard. I checked System.Windows.Forms.Keys but it seemed to be only handling the pressing event from user but not "pressing" the key by the program itself. Thank you in advance. Find it difficuit myself and then half the time when I found something I still find it hard to understand the formatting, anyway the reason why you didn't find anything is becuase the Sendkeys is not part of the Forms.key class. Normally I look for description words eg send keys or save file. ...Show All