GoDaddy's Q&A profile

• SQL Server exporting to CSV

  I have a need to run an export of fields from a table into a CSV text file located on my e:\exports. Is there a simple way to do this use the following query... master..xp_cmdshell 'bcp "select * from master..sysobjects" queryout e:\exports\exported.csv -SMYSERVER -UMyUserName -pMyPassword -c -t "," -r "\n"' ...Show All

• SQL Server Read property of "selected" dimension member (AS 2005 filter)

  Hello there I am using Richard Kutchaks CellsetGrid though this issue is of a general kind. I want to filter on a hierarchy. This filtering occurs as a subcube. I intend only to chose one member at a time. The thing is that I want to read the property "level" from the chosen (filtered) member. I can't use currentmember since no member is actually chosen, but the filtered hierarchy points at a member. Is there a way to catch that member and through that actually read properties of it I don't care if it fails when more than one member is chosen. This code worked when I used the old way of filtering which cannot be used with CellsetGrid: CASE WHEN [Prisme Dimension].[Hierarki Prisme Budget]. currentmember . LEVEL . NAME = [ ...Show All

• Software Development for Windows Vista Error while running application on VISTA

  we are developing some multimedia application, everything is working fine on XP and 2000, but on Vista I'm getting the following error when I'm calling a COM server method with a BSTR parameter: "Duplicate Memory Free operation. Get a stack trace and report bug against the calling app (not against OLE Automation). File: d:\rtm_edw\com\oleaut32\typelib\oautil.cpp, line 602" Anyone could help me I tried various combination, without ::SysFreeString in the COM server also in the main application, but I'm getting the same result. Below is the the code that works on XP and 2000. calling code: class CAppClass { ... private: IComClass* m_comClass; } bool ...Show All

• Smart Device Development Error InvalidOperationException unhandled - help needed urgently

  hi, I have implemented the code for cameracapturedialog using WM 5.0 and VS 2005 and Windows 2000 professional OS .I m getting error using the ShowDialog() method of the CameraCaptureDialog. Code is like this CameraCaptureDialog cameraCapture = new CameraCaptureDialog(); cameraCapture.Owner = this; cameraCapture.Mode = CameraCaptureMode.Still; cameraCapture.StillQuality = CameraCaptureStillQuality.High; cameraCapture.Resolution = new Size(175, 150); cameraCapture.DefaultFileName = @"test.jpg"; cameraCapture.InitialDirectory = @"\My Documents"; cameraCapture.ShowDialog(); Stack Trace ========================== System.InvalidOperationExceptoion: {"An unknown ...Show All

• Visual Studio Guidance Automation Extensions and Toolkit: June 2006 Release

  The patterns & practices team is please to announce the availability of the June 2006 CTP of the Guidance Automation Extensions (GAX) and Guidance Automation Toolkit (GAT) ! As reported previously , this is a relatively minor update to the previous December 2005 CTP which includes some important bug fixes and usability improvements. For more details on this release, please read the announcement on my blog . Enjoy! Tom Hollander Product Manager Microsoft patterns & practices I try now to make a setup file (register fails) to install de package and fails with this error: Package configuration file c:\programa files\......\WCFTooling.xml doesn’t existe. WCFTooling is the name of the hol b ...Show All

• SQL Server Does tablesize affect performence on an indexed table?

  I'm facing a design choise. I'm about to create a table that will hold reading values from temperature meters. It'll need to hold about 1,5 billion records. The number of columns will be fairly limited, someting like: ID - bigint (PK) MeterID - bigint (referense to the temp meter) Temp - real (the temperature) Time - datetime (the time of the reading) Most of the select querys will look sililiar to SELECT ID, MeterID, Temp, Time FROM TempReadings WHERE Time > X AND Time < Y The time column (and probably others to) will have indexes. Meter readings from 20 years back will be stored. I've been thinking of two alternatives here. 1 - Save all readings in one table 2 - Have two tables. One for the first year and one for year 2-20. R ...Show All

• Visual C++ How to get deskband interface?

  ____________________ | | | | | | | | | | deskband | HTML | | | | | | | This question does not contain the information needed for anyone to give any kind of feedback. Also, this is a C++ language forum -- not a place for general discussion or problems not related to the C++ language or its standard extensions. Direct a clarification to a suitable newsgroup at http://msdn.microsoft.com/newsgroups. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=789657&SiteID=1 for more information. ...Show All

• Smart Device Development Regional Settings and PlatformNotSupportedException

  Hi, My regional settings in my Mobile 5.0 PDA is not set to one of the 8( ) default languages. When i'm trying to use String .Compare(str1, str2) I get a "PlatformNotSupportedException" If I change the regional settings back to english, all is working OK. I know I need to change the current thread Culture or something, but how do I do it In CF there's no threading.Thread.CurrentThread.CurrentCulture I do not need to translate the app or something. Thanks. Ammm, that thread is mine also (I just notice that you tried to help me then as well...). I tried to contact the manufacturer (as I wrote on the other thread) without success. The reason I opened a different thread is that maybe the problem is ...Show All

• Gadgets Security overlooked when downloading

  Okay so there is a security check when downloading gadgets, but as nobody ever botheres to get their approved~what's the point ! Please Microsoft, you have this great oS (Vista) that *has* security, gone to the trouble of developing a sidebar for gadgets and community for it and all because you wnt people to post you don't enforce the security certificates. I think that is wrong, there's quite a bit of dross in the gallery (no offence) and I am sure it would benefit everybody if the majority were certificatted. ...otherwise people will just revert back to pre-Vista thinking and just assume things are safe, not caring about security checks. What with RSS being the new medium for viruses and gadgets....... I didn't know ther ...Show All

• Windows Forms Why SHIFT in Shortcuts in TextBox?

  Use the ShortcutsEnabled property to enable or disable the following shortcut key combinations: CTRL+Z CTRL+C CTRL+Y CTRL+X etc... The shortcuts above won't work in my application.   In stead I must use the SHIFT key: CTRL+SHIFT+Z CTRL+SHIFT+C CTRL+SHIFT+Y CTRL+SHIFT+X etc...   Why ...   I want the first one. How I'm using VB 2005. The most common reason for this is that you've assigned these shortcut keystrokes to menu items or toolbar buttons... ...Show All

• Windows Forms vb2005 prerequisite versus merge module question

  situation: vb2005, deployment project in the same solution as my main project. i use crystal reports in my main project, also jet, and mdac. i want to know if setting the prerequisite Crystal Reports is the same as adding the Merge Module for CR, are they mutually exclusive or are they both needed same with the MDAC prerequisite, do i set it and also the merge module, or just one of them what happens when in the prerequisite list you cant find what you want (jet for example), do i add as a merge module only or is there a way to add it as a prerequisite thanks The pre-requisite would be the preferred approach if one exists. One of the key reasons is that a single system-version of the pre- ...Show All

• Visual C# Managed Code Vs Unmanaged Code?

  I have read a lot on managed code and unmanaged code,now what I could understand is that any code that targets the .net framework is Managed code (right ),which inturn means its under the control of the CLR @ runtime. Assuming the above as true, I suppose unmanaged code does not target the framework or it does not come under the control of CLR @ runtime Can somebody explain this if possible with code example so that I can undersand the difference...thx. Unmanaged Code example like C++, Win32, and COM which compiled into native so they not managed by .net runtime but as you spend alot of time and money to build them .Net provide Unmanaged Interoperability so you can use them into your application and  here the ...Show All

• SQL Server How do I prevent a SQL Error terminating my package?

  I am getting the ubiquitous error.... "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. I have a stored procedure that performs a task on a loop. Sometime it fails, somtimes it succeeds and that's just fine, the errors are handled within the stored procedure and I return counts of success and failures. The trouble is that the package execution terminates when even one of the task fails. I don't want it to, I just want it to continue as the pakage should then go on to extract the source of the failues and post them back where they came from. Any ideas how I can ...Show All

• SQL Server Can bulkload update existing data in a table?

  Hi. I'm new to transfering data from XML to an SQL Database. I'm using SQLXML Bulkload. I can insert data into the table successfully but I cannot figure out how to update existing data. Is this possible in Bulkload or should I use Updategrams instead If it is, how can go about doing this I used Bulkload because I read up that it was good for large file transfers. Anyone Thanks so much! I've decided to handle the updates separately and not use updategrams because its too meticulous to deal with especially since I hav to do this for different tables and xml files. So what I'm doing is having a transition (temporary) table that will update the table. The mapping problem was solved by using Dictionary&l ...Show All

• Visual Studio Linking DSL Files

  Hi All, I will try to be as brief as possible. I've been making a DSL project for 2 months now. And somehow my application need to access the inner-structure of Visual Studio. I went to DSL forum to solve my problem, but someone pointed me to this forum. I hope there is someone here who can help me out. I dont know if my first question is related to GAT. When I run my DSL project I can add an item in Experimental Window by left-clicking the Debugging in solution explorer and then a window with templates appears. There I can choose my DSL template for the file I want to add. My question is, how can I perform this by only clicking a button I made by myself How can I show the Add New Item Template window by clicking my button And the ...Show All