Bryant Likes's Q&A profile

• SQL Server file corrupted message on query of restored db

  The analysis services database is operational on original server where it was processed. I backed it up and restored backup on another machine, and it fails to display data with message like this: The query could not be processed: o File system error: The following file is corrupted: Physical file: \\ \F:\MSOLAPDATA\mycube.24.db\cubedev.119.cub\datafacts19.172.det\cubedev.67.prt.fact.data. Logical file . I tried the backup 2 times - both in compressed mode. When uncompressed the database takes up 70GB. can anyone suggest what might be the reason for this The datbase works fine when I query it on the original server. Both machines have the same version of SQL 2005 - SP2 Dec CTP. I am also experiencing th ...Show All

• SQL Server Web Site Admin Tool problem in VS2005

  All, When I create a new project and try to use the WSAT security tab, I get the following : There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. I am using VS2005 beta2 with a local copy of SQL Server Express. I am new to all of this so a little help would be great Thx jonpfl Could you please share with me how you solved his issue when I click the "Secur ...Show All

• Visual Basic Send output to stdout from gui app...possible?

  I have a simple vb.net gui application (an alternative file requester in a form) that I would like to run from the command line. It executes fine, but I find that I cannot send any output (a string representing the file selected) to the command line upon completion. It appears that "console.writeline" doesn't actually write to the console Any suggestions as to how to send info back to the console window upon completion Keep in mind that this is a gui app (not straight console). I instantiated that streams and received valid streams although, the second was a null stream. There is abother approach. You begin with a console task and add forms capability as shown here: http://www.geoci ...Show All

• Visual Studio Express Editions Saving decimal in SQL Data Base

  Hi, When I save a decimal number, forexample 1.23, the database is rounding it to the nearest whole number 1. I need the DB to retain the value sent 1.23. Ron Thanks for your time, I have just created a new project with a new DB with one coloumn set to decimal (18,4), 4 decimal places I then dragged the column onto the form to create the data grid view and controls. I then tested the column with decimal data and it works fine, that is it retains the 1.23 with no rounding to a whole number. I beleive the issue to be with the changing of the DB table column types and the projects database.xsd file. I will now investigate my original project to see where the issue lays. Many Thanks Ro ...Show All

• Windows Networking Development Listen On a Certain Port

  I dont know if this is the right place for this.. but lets hope so... Im trying to create a simple... app that will listen on a certain port.. but for some reason It listen.. the program starts but.. then it ends... I also dont get any errors.. So Im a big lost here.. using System; using System.Net; using System.Net.Sockets; class internetcheck { public static void Main( ) { new startConnection(); } } class startConnection { public startConnection( ) { Socket socket = new Socket( AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp ); IPAddress ipaddr = IPAddress.Parse( "127.0.0.1" ); IPEndPoint endpoint = new IPEndPoint( ipaddr, 888 ); socket.Bind( endpoint ); socket.Listen(2); //soc ...Show All

• SQL Server Gurus, Is it possible to pass a DateTime parameter to a subreport

  Is it possible to pass a DateTime parameter from a master report to a subreport. I have managed to pass a string, but when i pass a DateTime parameter some error regarding its type is thrown. Please point me in the correct direction. Many Thanks. When you insert subreport component into you report, this subreport has Parameters property. Using this property you could setup parameters in your subreport. In XML code it's look like: <ReportItems> <Subreport Name="subreport1"> <Parameters> <Parameter Name="SubReportParam"> <Value>=Parameters!StartDate.Value</Value> </Parameter> </Parameters> <ZIndex>34</ZIndex> <Re ...Show All

• SQL Server automatically copy database to another pc

  When I create a setup program for my vb.net 1.0 app which has embedded sql express database, it successfully copies the database to the new machine alone with the upgraded app. However, if I just copy the vb.exe app to the other pc and also copy the mdf, ldf files, I get an error opening the sql database. I am presuming that the setup program does some kind of backup restore or detach, attach to copy in the .mdf. If the user cannot do this from the management studio (or if they do not have the management studio installed), is there any way I can create some method to have this copying done automatically via some code by the user Thanks SM Haig Yes, you can run a restore script using th ...Show All

• Windows Forms ToolStripStatusLabel properties

  I'm using a ToolStripStatusLabel and it doesn't seem to have all the properties that a normal label does. For example, AutoEllipsis. I need that property for the StatusLabel control. Am I just not looking for the right property If the text is too long, I need to add an ellipsis and I'm hoping I'm not going to have to figure it out manually. Any help is appreciated. Thanks! Ya-Tin Yeah, but I need the label to be fixed size and to have an ellipsis at the end for longer strings. I ended up replacing the ToolStripStatusLabel with a standard Label, and it seems now that the letters are squished after a certain point. Has anyone come across this ...Show All

• Visual Studio Express Editions How Can I Create Activex Controls using Templates and wizards in VC++ Express Edition?

  HI I had Installed Visual C++ Express Edition thro IMG. But i Can't able to create ActiveX Controls thro Templates. I am new to Microsoft Technologies. My Questions are: 1) How can we create ActiveX Controls using Templates or MFC Templates etc., 2) Is there any downloads available for only Templates - since in Express Edition Project Dialog it asks for Search for Online Templates ! Anybody help me in this hurdle. XAVIER VC Express is not suitable for creating ActiveX controls, it is missing both ATL and MFC. After you upgrade, you'll get lots of templates for ActiveX. ...Show All

• Visual Studio 2008 (Pre-release) wsHttpBinding and interoperability

  Hi, I have a wcf server hosted it IIS and the client is running on non-WCF environment.When I use the basicHttpBinding and generated the wsdl I have no problems and the client works with out any problem , but as soon as I change the binding to wsHttpBinding and try to generate the wsdl then i get this warning ... **************** From SDK Command Prompt ************************** C:\>wsdl http://localhost:8000/fortune Microsoft (R) Web Services Description Language Utility [Microsoft (R) .NET Framework, Version 2.0.50727.42] Copyright (C) Microsoft Corporation. All rights reserved. Warning: This web reference does not conform to WS-I Basic Profile v1.1. SOAP 1.1 binding was not found: WS-I's Basic Profile 1.1 consists of implementat i ...Show All

• Windows Forms cause a property to display "builder" button to browse for folder ?

  I'm writing a custom control. One of its properties is a directory name. I'd like the property sheet to display a "build" button that--when clicked, displays the standard Browse for Folder dialog. I have no idea how to do this. Any help getting started is appreciated. I don't know if you can call the folder browser directly, so you might need to research that some, but you can do what you want by: Creating a custom editor for your property derived from UITypeEditor (Look at help for this guy for a good sample) public override UITypeEditorEditStyle GetEditStyle(System.ComponentModel. ITypeDescriptorContext context) { return UITypeEditorEditStyle .Modal; //tells the system ...Show All

• Smart Device Development Recording and Playing back streaming sound in C# on Motorola Q Smartphone

  I want to be able to record sound samples from the microphone and playback sound samples to the speaker on a Smartphone that are being streamed over a network connection. I have C# code to do this using DirectSound under XP but need to know what I will have to do to make it work on CF2 for a Smartphone, in particular, a Motorola Q. Here is the code that works under XP in case you're interested: public partial class Soundcard { private Form _form; private Log _log; private RTPConnection _rtp; private const short _channels = 1; private const short _bitsPerSample = 16; private const int _samplesPerSecond = 8000; private const int _frameRate = 50; private WaveFormat _waveFormat; private int _frameSize; ...Show All

• Smart Device Development SelectedIndexChanged event

  private void comboBox3_SelectedIndexChanged_1(object sender, EventArgs e) { } private void comboBox3_SelectedIndexChanged(object sender, EventArgs e) { } I design a combox at my form, which name is comboBox3, when I select a list item, but the comboBox3_SelectedIndexChanged_1 be called, the comboBox3_SelectedIndexChanged not be called. Why Please tell me. Thank you . The designer got confused when you were designing your form. You probably created the SelectedIndexChanged event, then deleted the ComboBox, then added it again. The designer saw that a SelectedIndexChanged function was already declared in your code so it made anoth ...Show All

• SQL Server can i restore only a table from a backup file?

  Hi, i have a backup file , and i saw the wizard to restore the file in sql2005. But i need to restore only a table. Is there a wizard for that Refer to the SQL Books ONline in this case when it is explained with code examples. hrubesh wrote: okay how do i do the above can you please explain stepwise. thanks ...Show All

• SQL Server Percentage Format

  I am trying to display a figure as a Percentage. The figure is 2.00000. I want it to show as 2.00%. When i go into the formatting i select P but it displays the figure as 200.00%. What formatting code should i use to get 2.00% Vijay, It seems that Duncan's values were already in decimal form and just needed to have 2 decimals and a % afterwards. Using the format code 'P' multiplies the value by 100, gets 2 decimals, and adds the % sign. The fact that it multiplies it by 100 is what was throwing off Duncan's values, and why we couldn't use the 'P' format code. Jarret ...Show All