JonEbersole's Q&A profile

• SQL Server Stored Procedure Update parameters question

  I just posted a question on WHERE clause impotence in SELECT command, I mean in my setting. It obviously should work on a global scale and now I have a problem with UPDATE command WHERE clause. I am talking about a different SP now. It is supposed to update a record in a table. Anyhow, the procedure did NOT seem to execute properly (did not update the record) when called from C# code but when I tried to exec it in the server it finally did work but raised a problem of safeguarding the unused parameters . I do not need to update all columns in every call to the SP that uses UPDATE statement. Some parameters are left the way they are. I found out that if I ignore them they are set to default values which is NULL for DateTime. It ess ...Show All

• Visual C# Interested but lost! :(

  First off. Hi! Just want to introduce myself since I'll be lurking around these forums for awhile. I know action speaks louder than threads but please bare with me. After looking through one of my PC magazines I found an article talking about Microsofts XNA and became very interested in something I gave up a very long time ago, programming. Why did I give it up Simple, you have to dedicate time and hard work and can't simply wish and will your way through it and amount to anything.. So I just moved on and never looked again at it.. However I've found myself still interested, even with the knowledge its hard work and doesn't amount to much for a very long time. Want I want is some help on things that really crushed me last time I trie ...Show All

• Visual Studio Publish Wizard / MSBuild - won't publish issue.

  I cannot for the life of me figure out why the "Publish Wizard" does not appear is Visual Studio for my VSTO Shared Add-in extensibility project. Even when I try to run MSBuild manually, I get an "unpublishable project" message that I have had tremendous difficulty trying to gather further details on. I would greatly appreciate if you could suggest potential reasons for why this is happening and perhaps a means throug which I can enable the publish wizard. Denis --- Environment: Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Enterprise Microsoft Visual Basic 2005 77617-168-7076001-41607 Microsoft Visua ...Show All

• Visual Studio Express Editions Null Reference Error

  This is still being a problem for me.   Public Shared Sub loadcw( ByVal vary As String , ByVal num As Integer )         Dim tmp As CheckBox         Dim tmp2 As CheckBox         Dim tmp3 As TextBox           If vary = "C" Then             tmp.Name = "C" & num             tmp.Checked = True          ElseIf vary = "W" Then             tm ...Show All

• SQL Server Orphaned SQL Logins on the Mirror

  Hi there, I’ve recently set-up database mirroring between two servers in the same domain: DMZSQL01 and DMZSQL02 with a witness of DMZSQL03. The mirroring as all gone according to plan. Set up all the users/databases on the Mirror (DMZSQL02) and then do a back-up/restore to sync the databases and then enable the mirroring, this has all gone fine and we have lots of synchronised/mirrored databases now. However, if I do a failover the logins on the mirror are not valid, they are in SQL Server and also the database but they don’t work. I’ve read through other posts and found links to this SQL Server article: http://support.microsoft.com/kb/918992/ This has had no effect though. Do I need to remove ever ...Show All

• Visual Basic How to disable the showing of user component in toolbox???

  Hi there, Does anybody know how to disable the showing of user component in toolbox Every time I open my vb 2005 project, my user-component will show in the toolbox, which spent lots of time Can I skip this step Would you please advise me how Thanks, Joseph You can turn it off globally via Tools.Options.Windows Forms.Designer, and turn off "AutoToolPopulate" under "Toolbox". I don't think there's a way to turn it off at the project level. Stephen ...Show All

• SQL Server OLEDB Command stage error in SLOWLY CHANGING DIMENSION

  I have created a sample dataflow to parse the employee details (empid,empname,empaddr) from a flat file to oracle 9i database table named employee(columns : empid,empname,empaddress - All are varchar2(15)) using SLOWLY CHANGING DIMENSION transformation for insert/update on the table. EMPID as Businees key EMPNAME and EMPADDR as changing attributes. Connection string is using Microsoft oledb provider for oracle. I am getting the following oledb command error. ----------------------------------------------------------------------------------- TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [OLE DB Command 1 [2007]]: An OLE DB error has occurred. Error code: 0x80040E51. An OLE DB reco ...Show All

• Visual Basic Read text file into string

  Does anyone know how to read a text file (.txt) into a string variable using VB.NET and VS.NET 2003 Thanks Dim s As String Dim tr As IO . TextReader = New IO . StreamReader ("C:\MyTextFile.txt") s = tr . ReadToEnd ...Show All

• Visual Basic modal dialog active...

  Any news on the "Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again." I have had this happen several times and its a pain in the butt! This is been opened twice ... many people here have provided examples in this post and on the ticket - I dont know why it cant be recreated at microsoft if so many others can. This was from a previous post I followed the link to http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=105195 and I saw that Microsoft has marked this bug "Closed". Unless there is a service pack or a hotfix that I don't know about, the problem is not yet solved, and the bug shoul ...Show All

• SQL Server Limiting Results from MDX query

  Is there any way to specify that I only want the last 16 rows of an MDX query Thanks. Depends on the query, and depends what exactly you want to limit. In the simplest case when there are no NON EMPTY clauses, you can modify the select statement from SELECT set0 on COLUMNS, set1 on ROWS FROM cube to SELECT set0 on COLUMNS, Head(set1, 16) on ROWS FROM cube ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. New version of Octtree Game Component

  I just uploaded version 0.1.2 on filefront http://hosted.filefront.com/ClydeCoulter in the XNA folder. I'm still working with CodePlex for a project there. (I think they thought it was for the same project since Quad and Oct were the only part of the name difference). I have made several fixes to and add more support for the OcttreeGameComponent class and added a simple example of the same in the TestOcttree1 project. I really would like some feedback on this project and the Quadtree project since there have been lots of downloads. How are you using it Are you using it or just curios Problems Enhancement that you have made....etc.... Post to answer this post or use the Forum at the quadtree project on CodePlex for both proje ...Show All

• SQL Server CURSOR Select clause

  I need to dynamically construct the field order of a cursor based on fixed labels from another table, but when I put that resulting query I receive the error: Server: Msg 16924, Level 16, State 1, Line 78 Cursorfetch: The number of variables declared in the INTO list must match that of selected columns. I have 6 fields defined in the cursor select, and 6 parameters in the fetch. The results of running the @sql portion returns valid data. Should this be possible to define a parameter containing the select clause of the cursor select colnum, coldesc, colname into #ae_defs from ae_adefs select @Sql = (select colname from #ae_defs where coldesc = 'PATIENT NAME') + ', ' + (select colname from #ae_defs where coldesc = 'PATIENT NUMBER') ...Show All

• SQL Server ErrorColumn field from Datasource Error Output

  Hi, The problem is, ErrorColumn contains ID. Is the following code reference safe columnname = Me.ComponentMetaData.InputCollection.FindObjectByID(Row.ErrorColumn).Name Is there any possibility for FindObjectByID to return NULL Reference in any case Fahad349 wrote: Dang on SQL Server team Is there any harder way to do it You are welcome to submit a feature request: http://connect.microsoft.com/sqlserver/feedback ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Having a bit of trouble with space wars

  The game starts and you can see the scores and hear stuff going on, but the rest of the screen is blank :( Any help with this is greatly appreciated i'm having trouble figuring out what the controls are if run as a windows app.. has anyone figured that out ...Show All

• Visual Studio Document Explorer merge problem

  I downloaded MSDN August 2006 and tried to install. It installed and now Document Explorer shows articles only from that MSDN. But other documentation is not shown. I have documentation about DirectX and Compuware DevPartner in English and about SQL in Russian. I tried to reinstall them all but nothing changed, DExplorer still not merged them. Hi Andrey, I've done some further investigation based on the software you have installed listed in your earlier message. I don't know if these suggestions will help, but they may be worth a try to get you going again. Direct X Diagnostic Tool: This tool does a check for problems associated with Direct X. Go to Start > Run. In the Ru ...Show All