nbaker's Q&A profile

• SQL Server Export to excel issue

  I Have a report, in SQL Reporting servies. THE report has a field where the value shows up as an integer ie 0. However, when the report is exported to excel, the field value shows up as a decimal ie 0.4. How do i keep the number to show as an integer only ie 0, when exported to excel. Are you specifying a format code to only display the integer, or is the underlying value actually an integer If it is the former, what is the format code you are using Ian ...Show All

• SQL Server Auditing Status of a Trigger in SQL Server 2005

  I need to know when a DML trigger changes state (from enabled to disabled, and disabled to enabled). I **assume** this info is not in any of the standard SQL Server 2005 loags and find no entry relating to triggers being enabled/disabled. Therefore I also *assume* the best way to do this is create a DDL Trigger and populate a table when a trigger status is changed. Am I on the right track Has anyone done this Code samples/links to solution Is there a simplier way <i'm all about simple> Thanks in advance. Thats exactly the right direction, if you need a quikc sample for using DDL events, take a look at the DDL event definition in the BOL and perhpas at the slightly diff ...Show All

• .NET Development unable to create odbc data connection

  hi, i am using visual basic 2005 and oracle 8.0 as my data base. i had created the odbc. i had created a odbc data connection in administrative toos. But when i try to create data connection in vb, selected Microsoft ODBC Data Sources, when i test connection, it says an error message: ERROR[NA000][Microsoft][ODBC driver for oracle][Oracle]ORA-03121:no interface driver connected- function not performed ERROR[IM006][Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR[01000][Microsoft][ODBC Driver Manager]The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). Do i have to download any other driver to support ODBC If so please sent me some links. Is it free ...Show All

• SQL Server cpu usage @ parallel cube processing

  Hi! We encounter heavy perfomance problems when processing some (up to 8) cubes in parallel mode. Our CPUs are 2x Inten Xeon Dual Core @ 3,06GHz. When starting the processing (out of XMLA or Visual Studio), all of the 4 CPUs (2x DualCore) raise up to full utilization. This would be perfect if it would be the machine's only job to process the cubes. Unfortunately the machine is a Webserver (IIS @ ASP.NET 2.0) and has to run some MDX queries out of our Intranet Site, too. My question: Is it possible to configure the Analysis Services Server just to use 3 (or 2) CPUs Or is it possible to write a special statement into the XMLA script to affect that Sorry about my bad English! Thanks in advance! Regards JohnnyR ...Show All

• Visual Studio Missing Events Lightning Bolt Icon

  In Visual Studio 2005 Properties window the Events Lightning Bolt icon has disappeared even with an object, e.g., DropDownList selected. How do I get it back It was there earlier today, but I must've clicked on something that removed it. I still have the Categorized and Alphabetical icons ... Gabriel, I'm away from the office until Tue. I'll try to get an answer to your question. Thanks for your response, Daryl ...Show All

• Windows Forms How to find start of line in richtextbox

  Hi How can i find the start of line in richtextbox For example, RichTextBox1.SelStart = RichTextBox1.Find("i m finding") what is the start of line that includes "i m finding" I want to know selstart number of start of line. thanks. why dont you use the Find method, which returns back to you the starting position of that found string you can then maybe use the SelectionStart property to indicate the starting position of that string Dim theResult as Integer = Me.theRichTextBox.Find("String Here") if theResult > -1 then Me.theRichTextBox.SelectionStart = theResult end if ...Show All

• SQL Server Textbox Properties Format Code = to General Format in Excel?

  When I export a report to Excel I need most of the fields to be the general format of Excel which is what in the format properties of Reporting Services Reports I tried Default and that doesnt seem to be it either. According to Excel the General format cells have no specific number format. Any ideas would be wonderful! Thanks so much! Stokh :) I have tried everything, from it being in the sql select Oca_Cd,Convert(char(30),cast(DebtorName as text)) as DebtorName ,Convert(char(20),cast(AccountNumber as text)) as AccountNumber, DebtorPhone,Convert(char(15),cast(Msd as text)) as Msd ,Lob,IndOrgBalance,EnterDate,TransAmt,TransType,TransDate,GrossComm, EdiTransDate,Tax,TextId,ImportDate from temp_verizon_info where TextId IN ...Show All

• Visual Studio How to intercept click on icon decorator

  I have compartment shape with IconShape decorator on it and I want to provide some action with click on icon. Does anyone know how to do it Thanks, Alexey Hi Alan, So, as I can see it is impossible for now. Will it be possible for the future releases Thanks, Alexey ...Show All

• Visual Studio Tools for Office VSTO Outlook Add-in Debug errors even for simple HelloWorld add-in

  I am trying to learn about VSTO Outlook development and I've tried several Outlook add-in samples online. I'm getting all kinds of weird behavior when I try to debug even a simple HelloWorld add-in. public class ThisApplication Private Sub ThisApplication_Startup( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Startup MsgBox( "Hello World" ) End Sub Private Sub ThisApplication_Shutdown( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Shutdown End Sub End class Sometimes I get the following in a Microsoft Visual Studio message box: "Unable to start debugging. Check for one of the following. The application you ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. scrolling background with xna

  I made a scrolling background with xna using the example in the documentation and what I got is a very jerky scrolling - especially when there are extra moving sprites on the screen. After that I used the same background with the well known "star trooper" game example of microsoft webcast series and ... the scrolling is perfect. Do somebody have an idea if this is a bug in xna and are they going to correct it in the final release Creating games with xna is very pleasant and I'd really like the xna team to correct this problem. I don't think so. I just copy/paste the example from the msdn. It's coded by the xna guys. Here's the link for it - ms-help://MS.VSExpressCC.v80/MS.VSIPCC.v80/MS.XNAFX.1033/XNA/2DGraphi ...Show All

• Commerce Server Scriptor

  I have added a scriptor component to the Total Pipeline. This code is an offshot out of the book Developing with MS CS 2002. What I basically need to get is the Ship To State so I can determine a tax value etc. CS 2007 seems to have a problem on the line: Shipments = orderform.[shipments] The Event Views states: "Wrong Numbr of Arguments or invalid Property Assignment" 'The following entry points are available (shown in VBScript format): function MSCSExecute(config, orderform, context, flags) Dim State Dim Shipments Dim TaxTotal Shipments = orderform.[shipments] For each Shipment in Shipments shippingAddressId = shipment.[shipping_address_id] shippingAddress = orderform.[Addresses].Value(s ...Show All

• .NET Development Fastest way to call C++ code from C#?

  I would like to write plug-ins for my application using C#. My plan was to make the C# objects COM visible and derive from my plug-in interface. I’ve been told that the transition to and from managed code is a very expensive operation and I should limit the transitions as much as possible. This makes sense but I would still like to do things in the most optimal way since there will be no way from the transitions to be eliminated. That said, what would be the optimal way to call C# code from C++ (COM) and C++ code from C# My current plan is to use COM visible interfaces to call C# code C++ and COM connection points to call C++ code from C#. More to ask,   Sinc ...Show All

• Visual Basic Web Browser project

  I am working on a very simple browser, mainly for quick web surfing without the need of menus, favorites, and other fancy features seen in other browsers. The problem is, im quite new to this programming language, and i barely got anything out of what little time i had in Introduction to Computer Programming (using Visual Basic 6.0) before being pulled out of that class to make up a required credit. Im clueless as to how to get the WebBrowser object to respond to the input in the AddressBar, and display the site the user types. Any help on this would be really greatful. Thanks I recieve the following error: 'Navigate' is not a member of 'System.Windows.Forms.TextBox'. I have no clue what i did wrong. I put: Me.AddressBar.Na ...Show All

• SQL Server Larger Scale SSAS 2005 deployment configuration options...

  I'm wondering if there is anything like Microsoft SQL Server 2000 Analysis Services Operations Guide.doc Microsoft SQL Server 2000 Analysis Services Performance Guide.doc for SSAS 2005. I'm working on a 22 Gig cube (that is size with no aggs) with a 32-Gig RAM Server and want to do more tuning - I should be able to get the whole thing in RAM, no Shouldn't that make it really fast I'm particularly interested in all of the Analysis Services Properties for SSAS. What does "-3000" mean for several of the properties I was thinking that raising many of the max RAM settings could be good, but if they are based on percentages, then that would scale with the server and wouldn't need tuning. There seems to be ext ...Show All

• Microsoft ISV Community Center Forums Business and market share of Software Players

  Not sure if this is the right folder, but I can't find where to look for this information. This is more a business question. We have Microsoft, Oracle, SAP and maybe IBM as the dominant players in the software industry. I would like to know the market share, prospect and the future trend of these players in the industry. For example, in particular, the ERP Sytems, currently it is SAP getting the most market share in the market. How about Microsoft BizTalk/Navision or Oracle What do you think about the future trend If I am going to invest on an ERP system and need plan for the next 10 years, what is the best pick Please discuss. Thanks ...Show All