Nate879's Q&A profile

• SQL Server Inserting float value problem

  Hello, I wrote a stored procedure which gets some parameters and do an insertion according to these parameters. A parameter is type of float.In my own develop machine when I call the sp like this: mySP 'X', 4, 9.2 it inserts the float value 9.2 correctly. but a customer tells that when he wrote 9.2, it is inserted as 92 or 9.0. What is the problem causing this situation Hi, this is either caused because the parameter was not defined the right way either on the client or in the procedure. You will also hae to make sure that different language settings on your computer might interpret the value the wrong way,either with a decimal point or a thousend’s delimiter. To investigate the first issue you will have to see through ...Show All

• Software Development for Windows Vista SqlDatabaseActivity can't handle output parameters when calling a stored procedure

  Dear all, I have just run into a problem with SqlDatabaseActivity which I downloaded from Microsoft. It doesn't understand output parameters in stored procedures, so it never returns any values for them. It assumes that all parameters are input only. I had previously discovered that it didn't handle @RETURN_VALUE, but fixed it myself. The failure to handle output parameters looks more fundamental, so I am reluctant to embark on trying to fix it. Is there a version of the activity which resolves this issue That's great Trevor. This is something I'm sure many people would use and benefit from. Do you have a blog where you could post this Otherwise a link to download on this thread is a good start, as I'm sure others ...Show All

• Visual Studio Tools for Office Selection.PasteExcelTable not working correctly the first time it is called

  Hi, There are specific circumstances under which Selection.PasteExcelTable does not behave as expected the first time it is called. The following are the steps to reproduce it. In a Word Template project, add the following code private void ThisDocument_Startup(object sender, System.EventArgs e) { UserControl1 userControl = new UserControl1(); userControl.button1.Click += new EventHandler(userControl_Click); this.ActionsPane.Controls.Add(userControl); } void userControl_Click(object sender, EventArgs e) { Application.Selection.PasteExcelTable(true, true, false); } Run the project and then copy from an Excel file that looks like this http://pic.atpic.com/172150/0/jtfgimzxcdylugbmebyq Notice that there is a hid ...Show All

• Windows Forms how to implement Licensing in your application

  i want to implement licensing in my application....guidance required how to do that Hi, I allready used the software of thirdparty company orient software http://www.orientsoftware.net and the software O-Licensing (download from http://www.olicensing.com ). The software is very easy to used. Try to use it. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. When is LoadGraphicsContent(true) called?

  Hi, I'm wondering if LoadGraphicsContent(true) is ever called by XNA (rather than client code) except for when the game is first started. The reason I care is that if I have to reload, for example, a Texture that a few different objects are still using, I have to make sure that they use the new Texture reference rather than their old one, which is now dead. Basically: am I guaranteed that LoadGraphicsContent(true) is never called except when the application first starts up and when I call it myself It appears that's how it's supposed to be, but from the documentation I'm not 100% sure. Thanks, Max If you switch to full screen mode and then alt-tab to switch to another process and back again the devic ...Show All

• Visual Studio Team System Reporting Services woes.

  Hi, I installed Team Foundation Server and I can do queries but I can't create a report. Where do I look for the account causing the following error message: An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'TfsOlapReportDS'. (rsErrorImpersonatingUser) Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Hi, Thank you for your help. This issue has been resolved. My error was: Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Your suggestion was: Can you verify that ...Show All

• Visual C# Best way to update a class when modifying a member

  Hi, I have a UserControl derived class containing a Label, which I would like to be updated every time a public string on the class is modified. For this, I created accessors for the public string, in this way: public class MyControl : UserControl { private Label _label; private string _string; public string MyString { get {return _string; } set {_string = value; _label.Text = value + " " + value; /* do something fancy with the new value */} } /* ... */ } What I dislike of this approach is that I have the feeling of having duplicated the string inside my class. I am not sure if this is accurate, as I am new to C# development. Anyway, is there any other way to update elements of a class when a member is mo ...Show All

• Visual FoxPro HUGE problem with the Container Control (?)

  In VFP9: I have a Form, that has a Container, that holds a Listbox The Listbox has some items in it. Now, if you try to click on an Item, hold the mouse clicked and drag it up and down, the selected item does not change, it just blocks there. When you release the mouse and click on another item, you now have TWO selected items in the Listbox. That is not normal. A Listbox outside a container works just fine. Has anyone been able to solve this Thanks. I will ignore your crack about experts and merely remind you that those who seek help from volunteers usually do better not to insult people who try and help them! Let me repeat. I tested this with VFP Base Classes and do NOT see the behavior you desc ...Show All

• Software Development for Windows Vista Canceling a burn

  I can't find the documentation on canceling using IMAPIv2. Is it the same as in IMAPIv1 I'm not really using IDiscMasterProgressEvents, so I'm not sure how I'm supposed to implement a QueryCancel() Also, I've seen claims that the cancel is broken on xp sp1/sp2, is it for sure working on Vista Hello Vlad, We do not provide support for IMAPIv1 on Windows XP on this forum. For IMAPIv1 on Windows XP support I advice using http://support.microsoft.com or specific support contract from your ISV company. For both Windows XP and Windows Vista we strongly advise using IMAPIv2. ...Show All

• SQL Server SSIS ScriptTask logging

  Hi. I've tried several things to log some information inside of the ScriptTask. I've tried Console.WriteLine(), Debug.WriteLine(), and Dts.Log(). All compile and work, but my problem is I can't find the output to save my life. I have logging turned on in my SSIS package, but the data doesn't show up in that file. I've check SQL Server's log. Event Log in OS. All no luck. Please help. Dts.Events.FireError() as well.. Also important to note that right clicking on task and executing will not post these messages to the log file. You need to execute the package to see this logging happen properly. Event Handlers as well. They won't fire unless the package is executed. Thanks for the help. ...Show All

• Software Development for Windows Vista Urgent workflow initiation query

  I am currently trying to implement a custom workflow in Microsoft Sharepoint server 2007 and have successfully done it but the issue is that i want to have a list of my workflows on the main page, clicking on which shall make user initiate that particular flow (by displaying its initiation form) instead of the the de-facto way which in on adding an item to the document library or list Is it possible to do so If yes, any hints or help would be highly appreciated. (As i have to decide if to go for SPS 2007 or build my own custom workflow asp.net application) Please post this question on the Sharepoint forums. this might help: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=881&SiteID=1 ...Show All

• SQL Server Can a non-admin user generate a create database script?

  I am trying to generate the create database script using SMO. The issue is the user account which connects to SQL server is not SA, SMO fails to generate the "Create Database" script with error User ZZZ\User1 does not have permission to run DBCC SHOWFILESTATS. Is it possible to generate a "Create database" script using SMO when you are connecting to the SQL server using NON-ADMIN account The user login is a part of db_Datareader role on the database. I tried following grant permission to the concerned account at server level Grant view any database, grant view any definition and grant view server state. Still it fails. Any idea Thanks Satya, I missed this reply. I tried ...Show All

• SharePoint Products and Technologies Displaying InfoPath browser form within master page content

  Is it possible to modify the FormServer.aspx page or create a new page based on the default master page to display a form generated from InfoPath Forms Server I would like to have a consistent look-and-feel throughout the site, including when users fill out information on a form. Right now, the form open up full-screen with no other content other than the form itself. I would like the menu bars and navigation present on the screen to keep the user aware of where he/she is in the site. I'm aware that problems may arise should the user decide to click on one of these links outside of the form; I imagine it would be the same just as if the user navigated to a new URL - the form just wouldn't save. Anyone have any insight into this ...Show All

• Visual Studio Team System Server name in Changeset.aspx

  I changed the name of my TFS server in all sorts of places, but there is one left which I can't figure out. When I get an alert email that something new was checked in, I get an email with a link to the changeset. It ends with /VersionControl/Changeset.aspx artifactMoniker=16&webView=true. In there is a reference to a XSL stylesheet, but that reference is using the old, original server name. How can I update that one as well Thanks, David Excellent and thanks! Any chance to see this fixed in SP1 This looks like a problem for extranet scenarios, which are one of the things that should work with SP1, right Best, David ...Show All

• Visual Studio Tools for Office Opening word doc in IE prompts me for username and password..

  Hi, I am using windows 2003 server with MS office 2003 and IIS6.0. When I click on the link to open the word document in the IE7.0, it prompts me to provide username and password. How can I configure word or IIS 6.0 to avoid this problem   Thanks, Milan ...Show All