Zjivago's Q&A profile

• SQL Server Changing Date

  Hello all, I have a question. I am fairly new to all of this, so bear with me if it is something simple (as I kinda hope it is). In SSRS, I have a report that runs against a SQL '05 DB. The DB tables are created with a SSIS package gathering information from an AS/400 DB2 database. The package and report run fine. One of the columns in the table is for a date (date of birth). The SSIS package gathers the column information and inserts it into SQL Server as a Decimal datatype (Decimal 6,0). The dates (decimals ) are now in the format 40207, as they were on the 400, where that specific date would be April 2, 2007. 120707 would be December 7, 2007 and so on. I would like to format the date to be mm/dd/yy or even m/dd/yy for the "si ...Show All

• Software Development for Windows Vista How to debug with RunWorkflow method?

  when I use btest = scheduler.RunWorkflow(guid); btest return false and how can I trace the error it didn't throw any error for me You can try to enable debug traces in config and see what's going on there: <system.diagnostics> <switches> <add name="System.Workflow LogToTraceListeners" value="1" /> <add name="System.Workflow.Runtime.Hosting" value="All" /> <add name="System.Workflow.Runtime" value="All" /> <add name="System.Workflow.Runtime.Tracking" value="All" /> <add name="System.Workflow.Activities" value="All" /> <add name="System.Workflow.Activit ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. problem under "less than pixel shader 1.1" environment / can't use REF ?

  Hi all. I'm using poor notePC having Intel 865 Graphics Chipset. This one doesn't support pixel shader 1.1, so XNA Template(NewProjects-WindowsGame) doesn't work well. Program stopped at game.Run(). I thought that ReferenceR asterizer (SoftwareShader ) can resolv this problem. So I write below codes, but program stopped at game.Run(). Moreover, I confirmed that graphics_PreparingDeviceSettings was not called. (I n debug_mode step execution, this function was not called.) Hmm...EventHander is called after CreateDevice by default DeviceInformation(required pixel shader 1.1) Are there any solution to execute XNA in "less than pixel shader 1.1" environmen Thank. void graphics_PreparingDeviceSettings(object sender, PreparingDevic ...Show All

• Visual Studio DSL Installer issues

  Hello everybody I encounter some issues when trying to create an installer for my DSL. I have successfully requested a package load key for it, registered it correctly (according to the corresponding MSDN page) and configured the installer definition file. I am able to build the installer project, I can event install it on a test virtual machine (I use VMware for that) and create a model file. But when I try to open it, I get two package load failure error messages. In Constants.cs, the same values for ProductName, CompanyName etc. are provided as the one in my package load key request. Is it possible that a missing assembly that is referenced by one of the package assemblies results in the same errors Thanks for your suggestions and help ...Show All

• Visual Basic System.FormatException: Input string was not in a correct format.

  Public Sub DeleteRecord( ByVal sender As System.Object, ByVal e As DataGridCommandEventArgs) Dim PrimaryKey As Int32 = Convert.ToInt32(glossData.DataKeys(e.Item.ItemIndex)) glossData.EditItemIndex = -1 DeleteData(PrimaryKey) 'viewstate("sortField") = "gTerm" 'viewstate("sortField") = "key_word" viewstate("sortField") = "Username" viewstate("sortDirection") = "ASC" End Sub Have the following code here but theres an error stating: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it orig ...Show All

• SQL Server The process cannot access the file because it is being used by another process.

  While configuring log shipping using SQL 2000 Ent, the copy process failed with this message : The process cannot access the file because it is being used by another process. does anyone know what cause this SAP R/3 is configured with the system, could this be the problem Thats what i want to try, i will try to stop the SAP, then reconfigure the log-shipping, if the log-shipping copy process succeed, i will try to restart the SAP, and see if the problem occurs again. if the problem persists, after restarting the SAP, i wonder how im gonna using LS and SAP on this mechine. ...Show All

• Windows Forms How to retrieve the data in DataGridView?

  Hi, I am using Visual Basic 2005 Express Edition and MSSQL Express Edition for database. I am doing a quotation application and I have the following in my DataGridView: ProductName, Qty, UnitPrice, TotalCost ProductName is a comboBox and its databound to my product database. I am hoping that when a client chooses a product in the comboBox, the UnitPrice will automatically reflects the actual price thats in the product database as well. I know i need to retrieve the data in ProductName column and execute a SQL statement to get the UnitPrice. But how can i get the ProductName data which the client has selected Hoping someone can point me to the right direction here. Thanks I have an example here . ...Show All

• Smart Device Development Console Applications Help needed

  hi all, I want to develop a console app and call it from my main application. how to do it If i want to pass any arguments to console application then Is there any mechanisms tht u appln made by me, send msgs plz help needed.How to make the console appln to run in background hi, really thanx for ur help. Actually the problem that i m facing is, I have main application from which user selects the images he want to upload to the server. this uploading should work in background and at the same time user can select other images for uploading. Now, when i exit my main application, if the console appln does not complete its work then, it should still remain running, even if the main appl close and exits. pl ...Show All

• Windows Forms Dragging stored procedure into dataset not creating datatable

  When I drag stored procedures onto my dataset, normally I get a datatable with an adapter. With one procedure that I'm working with, I get a tableadapter, but no datatable. Right now the proc doesn't return any rows, but when I execute it, I see the column headers so it should be returning them to the IDE. Anyone have any ideas Not sure why this was moved into Data Controls and Databinding. It turns out that it looks like this is an IDE issue regarding how the IDE figures out what columns are returned from a stored procedure. If there is a conditional statement before the select, which calls return, the IDE fails to figure out that the SP returns data. Example: create procedure dbo.TestSP_Broken as ...Show All

• Visual C++ VC Project Source Hardcopy

  was wondering if there was a simple way to print out a hardcopy of an entire VC project . like a dsp/dsw parser that could convert it to a single PDF file , so i can print that easily . i'm using VC++ 6. i know i can print each file , but i don't want to forget one especially if i have to make a copy regularly. is there much print options in later version ok then let me rephrase the question . is there such a feature in the VC++ 2005 if so i guess i will have to upgrade and if not , how to do it ...Show All

• Visual Basic Data Access Not Saving

  I followed the tutorial word for word. I have done it both in data view and detailed view. I can enter data in the data designer and it will flip through it at run time. I can click on the new record, enter data, and click the save button and I can flip back through it. When I close and restart the data is gone. Help! see if this thread helps: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=427451&SiteID=1 ...Show All

• SQL Server What counts for MSDE 2GB limit?

  How to assess how much space is left in the MSDE DB If I check with sp_spaceused .... is the ' reserved ' the right answer Or maybe only the ' data ' counts Please help!!! Thanks, but according to MS file size can be greater then 2GB. Only the data in DB should be below 2GB. So where to take this value from ...Show All

• Visual C# Convert TimeSpan to format DD:HH:MM:SS without the milliseconds

  Hi I have an application that needs to display duration time which is calculated with the TimeSpan class. The representation should be formatted as: D:HH:MM:SS (D=days, HH=hours, MM=minutes, SS=seconds). When applying the ToString method of the object it yields out the exactly what we need (including negative values). Quote from MSDN: "A string that represents the value of this instance. The return value is of the form: [-][d.]hh:mm:ss[.ff] Items in square brackets ([ and ]) are optional, colons and periods (: and.) are literal characters; " The issue is the optional decimal second fraction, we don't need it. Please advice how can we eliminate this milliseconds optional representation. Thanking you in advance Ilan ...Show All

• Windows Forms System Standby When Playing DVD's

  I'm currently experiencing a problem where my computer enters standby mode after 20 minutes. I've changed the power schemes to reflect "Never" so that it shouldn't enter standby and shut off the screen saver, yet the problem still occurs. Since this is a problem when playing DVD's, I've turned off the "Enter Password" option when returning from standby, and I've also shut off hibrination. Is there something I'm missing here Is there a patch to correct the problem As for what system I'm using, it's Windows XP Professional Service Pack 2. The computer is a Dell Optiplex, Intel Pentium 4 2.4 GHz & 512 MB RAM. I'm using an ATI Graphics card and sending the signal out of the computer to an LCD Projector and bac ...Show All

• SQL Server SQL parameter Syntax

  Guys, Wahts the right way to specify a parameter in an Execute SQL Task when the param is a varchar should I use apostrophe's around the or not I have two SQL tasks .. one where the query is specified like : WHERE FIA.BaseCurrency = Which SSIS likes and doesn't complain about...(the but then I have another query.. [below].. which SSIS complains about unless I have apostrophes around the So its like: AND FIA.BaseCurrency = ' ' So.. which should it be The problem for me here is that when I DO put the apostrophes around the I get no results back from the query... PJ The problem query: SELECT ForeignCurrency, RateFromFile AS YesterdaysRate --The ISNULL just protects us from situati ...Show All