Speedbird186's Q&A profile

• SQL Server can't connect server

  I'm using light free version of SQL server 2005 and Express Manager , until this time everything was OK. But now I cant using it , I cant connect the server (using windows connection) . That is error alert: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) Does anybody know where is problem OK, first make sure that the service is started properly on the machine which is named in the connectionstring ...Show All

• SQL Server count + excludeempty gives errors

  Hi, I try to make a calculated cell in SSAS 2000, in the standard foodmart 2000 example. I try a technique from the following page: http://msdn2.microsoft.com/en-us/library/aa902637(SQL.80).aspx For instance, I want to know how many married people there are in a salarygroup in the cube 'Sales'. I define the following MDX instruction for the calculated member "Married customers": Count(CrossJoin( {[Marital Status].[M]}, Descendants([Customers].CurrentMember, [Customers].[(All)])), excludeempty) I get nothing but errors when browsing the cube. Every cell states #ERR When I do not define 'excludeempty' everything's fine. How come Thanks in advance Yes, I have defined it in measures. As I, for insta ...Show All

• .NET Development When does NetworkStream.Read return zero?

  Hello! MSDN says: 1. "If no data is available for reading, the Read method returns 0." and: 2. "If the remote host shuts down the connection, and all available data has been received, the Read method completes immediately and return zero bytes." This is a bit confusing, since when "no data is available for reading", the Read method seems to block and wait for data. I get 0 from Read only in situation #2. So is #1 simply not true Thanks, ukasz ukasz Sromek wrote: Hello! MSDN says: 1. "If no data is available for reading, the Read method returns 0." and: 2. "If the remote host shuts down the connection, and all available data has been received, the Read ...Show All

• Visual Studio 2008 (Pre-release) Dotted Figure Border

  Hello, may be you can help me with this. I've a Figure in a FlowDocument and I want to make a dotted border. Is there any way to use StrokeDashArray. Thanks a lot !!! this should help http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=578754&SiteID=1 ...Show All

• Visual C# Drawing a semi-transparent image using GDI+

  Hi, I am trying to find out how to change the transparency when drawing a image to the screen using GDI+. The effect I am trying to produce is a image fading in and out. bratheo, this is what I have figured out recently (not sure if it is exactly what you want) to draw something, say a semitransparent rectangle (g is your graphics object) g.FillRectangle( new SolidBrush( A, Color.Blue), ......); A neesd to be a value between 0 and 255. 255 means totally opaque and I think 0 is totally transparent. Anywhere in between will give you different transparency levels. Hope this helps Fradam ...Show All

• .NET Development xDataAdapter functionality

  Given xDataAdapter of x .NET Provider in ADO.NET 2.0 should xDataAdapter call row.AccepChanges() for an Insert command before updating output params and record returned during xDataAdapter.Update in order to ensure that Original row values are filled Original values are necessary to ensure that DataSet Merge operation works correctly in case PKs are returned from data source after insert either by output params of a SP or a returned record. AFAIK AcceptChanges would clear the dirty information so Update would not have anything to update anymore. -- SvenC ...Show All

• Visual Studio Express Editions Another How to question

  Hello to All: I am trying to figure the method for keeping track and setting the limits for inventory. So how do you do this   Inside my array I have 5 products (Product-"A45" with an inventory or quantity of "2" for a price of $4.50, product "B24" that has a quantity of 5 and so on (Three more products) )of information in text files. I need to set up some "if statments" to set the limit for the inventory. So in other words if the user selects  a quantity of 3- A45 products then the progam will respond with a message box telling that user that there is not enough inventory to order that product. Notice that I have tryed a few methods or statements that do not work.   So far , it is just that I am  stuc ...Show All

• SQL Server Need infos regarding install of SQL Express 2005 SP1

  Hi, A little technical question. If I want to install SQL Express 2005 SP1, do I have to uninstall current version first Thanks in advance, Stephane Hi Arnie, Just to be sure. Must I uninstall current version of SQL Express before going on with others listed in previous message Thanks for your help, really appreciated! Stephane ...Show All

• Visual Studio Team System 'Test' Menu

  How do i enable the test functionlaity, is there any additional software i need to install We currently have Visual Studio 2005 Standard editions, I've tried to reset the user data to change the profile to Tester, but do not get a prompt to change user Have you installed the Visual Studio Team Suite or the Visual Studio Team System for Software Tester on your machine You can look up Help->About to see if you have installed these on the machine ...Show All

• SQL Server Scary Problems with User Hierarchies

  In my training (at MS Ascend) and in my readings I was initially lead to believe that user hierarchies were nothing more than a way to "organize attribute hierarchies into user-friendly multilevel structures." (Spofford et al.) However, the more I use SSAS 2005, the more I see that this is not completely true. User hierarchies have more significance. For example, user hierarchies seem to be used more than you might think (or want) in the design of cube aggregations. More recently I discovered a very scary and unintended consequence of building and using user hierarchies. Consider a simple product dimension with three attributes (besides the key): Product Type ([Type]) Product Species ([Species]) Product Size ([Size]) Th ...Show All

• Visual Studio 2008 (Pre-release) Cost of Binding?

  Can anyone comment on the expense for large number (thousands) of data binds Fundamentally, what does it cost me to do a bind I already understand the benefits :-) thanks, Kiel If you're referring to a listview or something similar there is hope. ListView can virtualize the elements so that only those elements that are actually visible get created (and bound). This allows your UI to scale and display thousands of elements without creating thousands of textblocks or what have you. ...Show All

• Visual Studio 2008 (Pre-release) Sample code / Demo projects

  Hi Due to the abscence of the Sync Designer, it will help immensely if you can post either or all of the following: Documentation for Microsoft.Synchronization.Data.Client, Microsoft.Synchronization.Data.Server and Microsoft.Synchronization.Data.dll Sample code : Any demo projects Regards, Kk No worries Rafik... So I'm not going 'loopy', I was just too quick off the mark! Thats a relief. Thanks for the quick reply. Regards, Glen ...Show All

• Visual Studio Express Editions problem with msdn

  i had downloaded the last msdn from msdn website my problem is that msdn is compatible with my visual c++ 6.0 dated since 1998 i can't update to the last version because our teacher want us to work with visual c++ 6.0 killer_instinct wrote: i had downloaded the last msdn from msdn website my problem is that msdn is compatible with my visual c++ 6.0 dated since 1998 i can't update to the last version because our teacher want us to work with visual c++ 6.0 If you are not going to be making Windows applications, you do not need anything that does not come with the Visual C++ 6.0 compiler. What do you expect to find in the MSDN Library that will matter for your class You can use the MSDN that is par ...Show All

• SQL Server want to implment DRILLTHROUGH IN SSRS

  I am trying to implment following statement in my SQL Server Report 2005. My data source is AS2005. ***************************************************************************** DRILLTHROUGH SELECT ([Measures].[Total Test Count]) ON columns FROM [OLAP Test Cube] WHERE [Dim Station].[Station Name].&[1ST CHOICE EMISSIONS & INSPECTIONS] RETURN KEY([$Dim Station].[Dim Tests],0) ,KEY([$Dim Station].[Dim Tests],1), [$Dim Test Cycle].[Test Cycle], [$Dim OverallResult].[Overall Result] ****************************************************************************** When I execute above statement in AS SQL Query Analyzer then it is working fine but same statement I am executing during Report creation (Query Builder) that time it giving ...Show All

• .NET Development Why do GZipStream compression ratio so bad?

  I tested on multiple files and GZipStream can only reduce the file size to ~70% of the original files. I tried the same files with GZip.exe utility from http://www.gzip.org/ and it can compress the files down to 50% of the original files. Am I missing something here I don't see any options in the GZipStream that I can set to make the result better. Thanks, hdp. GZip format is not pattented. I believe the zip/unzip code from the link that I mentioned above are non-patented also. I need to compress file to reduce load/unload time (from network drive). 30% compression of image files is pretty useless to me when you factor in the extra time to (de)compress the file. I guess I have to use other li ...Show All