PeteJM01's Q&A profile

• SQL Server MDX query using BottomCount

  Hi, Iam facing with a very strange MDX query related problem. I want to display 2 reports one that display Five top records and the second report that displays 5 bottom records. Following is my query which returns top 5 records. SELECT { [Measures].[Order Count] } ON COLUMNS, NON EMPTY TopCount ( Filter ( { [PRODUCT].[PROD NAME].[PROD NAME]}, [Measures].[Order Count] >= 0 ) , 5, [Measures].[Order Count] ) ON ROWS FROM [ShippingOrder] I created report using SQL Server 2005 Reporting Service and the data source is pointing to Analysis Services database. The preview report shows proper records. But my second report that queries to display the bottom 5 records does not display any records. The query is same except with ...Show All

• SQL Server Connection denied. Please help

  Hello, everyone. I'm new in Reporting Services 2005. I encountered a confused connection problem. I'm running a named instance (called 'sql05') of SQL Server 2005 Standard Edition(a SQL Server 2000 instance as my default) on my Windows XP Professional machine. I log in Windows XP as a member of Administrators group. When I came into SQL Server Management Studio and connect to my local reporting server using Windows Authentication, the report server denied my connection request 'actively'. The service is running but it denied my connection. But when I use the same method to connect to my database engine and Analysis Services in Management Studio, no problem has happened. Does anyone have similar experiences I appreciate for any help. Thank ...Show All

• Software Development for Windows Vista WS-AT problem: The MSDTC transaction manager's WS-AtomicTransaction protocol service is disabled

  Hello, I have a very strange problem with the WS-AT controller. I call a simple transactional WCF service once from a WCF client and once from a Java client. When called from the WCF client, everything works fine, but when called from the Java client, I get an exception with the message "The MSDTC transaction manager's WS-AtomicTransaction protocol service is disabled and cannot unmarshal incoming transactions." From the service trace log / service message log, I have the headers of the messages sent to the service both from the wcf client and the java client. Here the headers from the WCF client: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> <s:Header> <CoordinationContext s:mustUnde ...Show All

• SQL Server Foreign Key NOT referencing PK

  This book 'MS SQL Server 2000 Bible' says the following: 'The foreign key can reference primary keys, unique constraints, or unique indexes of any table' I've never heard of this before, I thought that the FK always established referential integrity by referencing the PK in the parent table. Does anyone have a further explanation of this thx, Kat It seems pretty logical when reading it. Remember, a 'Foreign Key' as well as 'Primary Key' are abstracts. They are logical constructs, abstract ideas, or rules if you like. Many times they are mistaken or confused with indexes, though the meaning of PK's or FK's has nothing to do with indexes at all However, the only current way to implement the concept of a PK, is to intr ...Show All

• Visual Studio receive "delay notification" when starting VS2005 help file

  hello. when i try to start my VS2005 help either from the IDE or from the Start | Programs dialog, there is about a 2 minute delay before the help file is displayed. If I start the help file from the IDE, i receive a "delay notification" dialog that it is waiting for some other process to finish.. There seems to be plenty of resources left on the PC ,and I see dexplore.exe is trying to load the help file. What could be the reason for this behavior Hi Barrym21, You haven't mentioned it, but if the MSDN Library is stored on your own, local machine, then let's take a look at your Help settings: In the VS 2005 IDE: Go to the main toolbar and open Tools > Options > ...Show All

• Visual Studio Express Editions What are the differences between the string/String bool/Boolean (and others) types?

  Hello everyone! I've been using C# for a little while now, using the the data types named from C++ such as bool, int, string, etc. Recently I was playing around and started using String, Int32, Boolean, which from what I can tell, do pretty much the same thing as the original ones that I have been used to. I don't think they would have been put into the language if both sets of types were exactly the same in every way. My question then, is could someone explain to me or point me in the right direction so I can know how they are different Which is the best to use during what situation Thanks! Ryan They are just aliases for the .NET type names, probably added to make them look more like the 'native' C# ...Show All

• Smart Device Development Accessing GPIO input

  Hello, I'm not shure, if this is the right group for posting this question, but maybe there is someone who can help me. I'm progamming on Windows Ce with the compact framework on the "Wafer-LX-800"-Board (have a look at www.ieiworld.com; it has an "x86"-processor) and I need to read the GPI0 ( its Pin7 at the GPIO connector and it should be defined as input). But how can a do this by using C# I've already searched the web. The most promising idea was the use of the class "PysicalAddressPointer" of the OpenNetCf-Library ( www.opennetcf.org ). But I failed in finding out which adress to use and how to "read" the nececarry pin. I would appreciate any help! Sabine ...Show All

• SQL Server Error 1418 and Good Basic Setup Guide

  Hi, I'm new to DB Mirroring, and I am trying to get it going in a test enviroment between two SQL 2005 Dev Servers. I have followed documentation that I have found but cannot get past a 1418 error when establishing a connection between the servers initially. Does anyone know of any good step by step guides that I could look at, in case I have missed something stupid. Thanks in advance Stupots I am newbie to this and am getting quite confused, I have been following Harsh 88s post and it all makes sense to me except this part: Create a login and a user for each remote server, and create a certificate for those users from the certificates copied from the remote servers, as shown in the following TSQL example: ...Show All

• Windows Forms Case study Problems... PLEASE HELP...

  Dear people, I am getting very very crazy. I am trying to make a case study but I just cant do it. In the link you will find the requirements of the case study... I realy hope that you can help me. Its my last case and then I am done.... http://www.vbforums.com/showthread.php p=2766193#post2766193 Thank you for the reply. But my main problem is not solved. When I return from the frmNumber I want the value I entered in the frmNumber to display in the specific row of the datagridview. I hope you can help me on this too... ...Show All

• Microsoft ISV Community Center Forums Urgent HELP!!!!! VB in MS Excel

  I have a data file in Excel which contains a lot of information for different hospitals. I want to create separate Excel files which contains the information specific to one hospital - I don't want hospitals to see data from other hospitals. Ideally I would like one click that will generate the reports for me I am not sure how to go about this. I have some VB code but for business objects and it doesn't work in excel. Please help!!!! You can also try using Pivot Report, or maybe a combination of VBA (Macro) and Pivot. Doing so lessens the coding. ...Show All

• SQL Server Allow null in a field in Flat File Source

  How could I specify in either FF Connection manager or source that it shouldnt give any error and assume blank or no value as NULL Thanks, Fahad Saurabh Kulkarni wrote: you can go to the properties of the Flat file source and set 'RetainNulls' to 'True'. I think that solves your problem. Except the OP stated that the value was blank or empty, not null (char(0)). ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can someone point me to a thread that will tell me how to add collision detection to my game?

  I know tons of threads exist, but I looked through a few of them, and they didn't really help me to learn how to start a collision detection code. Thanks waruwaru wrote: Is your game 2D, or 3D What are you having trouble with Why didn't the threads help you Without more info, can only point you to the more generic answers. http://www.google.com/search hl=en&q=xna+collision+tutorial ok, my game thus far is set in 3d. I believe that bounding sphere would be the best collision detection for me, but i havent used it yet. In everything I have made so far, I just walk thru walls. The reason I didnt find anything that helped me is that the threads I looked at had info for ...Show All

• SQL Server Delete Database User w/o Login name

  I have a database user (Maximum). Its default schema is db_datareader. It was created without a login name. When I try and delete this user, i get the following error message: Drop failed for User 'maximum'. (Microsoft.SqlServer.Smo) The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138) How do I remove this user It seems like your user owns some schema, most likely the default schema that gets created for the user. You will need to use the "DROP SCHEMA" statement to first drop the user's schema (if it is the default schema, the schema's name will most likely be the same as the user's name). Otherwise you can use "ALTER AUTHORIZATION" to change to the own ...Show All

• .NET Development how to use where clause in data adapter

  SqlDataAdapter AdapObj = new SqlDataAdapter("Select * from Employees WHERE employeeid = 1", myConnection); hi im using the above code, but it is genarating an error, I know the way i have used the where clause is wrong, can somebody please show me how to correct the above code. thanks in advance I presume you are learning/ testing due to the use of a textbox for your SQL Select statement. You should not pass TSQL to your DB from a textbox. You should use SQL Command Parameters whenever possible. You would probably be better served if you work on declaring the command and connection objects independently, ensuring correct disposal etc. Then you get a better understanding of the i ...Show All

• Visual Studio Express Editions Webbrowser Control with Loading Bar

  This is a relatively simple question, I suppose, but I have searched for a week across the internet and haven't found an answer nor source code that contains a webbrowser control with a loading bar, such as Firefox, IE, and other popular browsers have. Now, say I have a browser control called WebBrowser1, and a Progress Bar called ToolStripProgressBar1. How do I go about getting the progress bar to show the percent of the page loaded in the web browser control there was a topic about this the past week. implement the ProgressChanged event. This will automatically be fired when the progress of a document loading has been changed. You can then use the CurrentProgress indicator of this event to tell you how much of the document has b ...Show All