Brook G's Q&A profile

• SQL Server Connect to remote RS in SSMS

  Got following error when try to connect to remote reporting service in SSMS: TITLE: Microsoft SQL Server Management Studio ------------------------------ The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ BUTTONS: OK ------------------------------ No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that Thanks. Odd - You're logged in on as the same user on both computers   Are both computers in the same domain Ca ...Show All

• .NET Development setspn and delegation

  I am having problems getting delegation up and running using a service account running IIS 6.0. My test scenario calls from a XP client through to a webservice on server iis1, through to another web service on iis2, both web servers runing win2003 SP1. The Domain is at a functional level of win2003. Both web services have windows auth and impersonation set, ping methods to the individual webservices do work ok. I have setup 2 service accounts spniis1 & spniis2. With both service accounts I have run aspnet_regiis -ga against them and also added them to the IIS_WPG & users groups. I have also enabled kerberos by using ...Show All

• Visual Basic VS 2005 IDE Unresponsive

  We had originally installed Beta 2 of the product which ran better than expected. After using the tool from MS to uninstall the beta software we then installed VS2005 Final which we downloaded through our msdn subscription. The IDE becomes just about unusable. Not only that but it pretty much renders the computer useless while it eats up CPU cycles. This occurs during the following conditions: 1.) We make a small change in code and the editor hangs, the hour glass pops up and the cpu usage for the devenv.exe process is usually at 99%. The icon at the top of the VS IDE switches to the default exe icon. This unresponsive behavior usually ...Show All

• Visual Basic Converting String to double?

  OK i have a plain text file in a rich text box. This plain text file contains for the most part just text, but it has several chunks of data which are apparently stored as doubles For Example this string here: 33333oH@33333oH@26/01/06 I happen to know that the date field is a date of payment, and apparently, the data before this is the amount paid. The original program i am trying to read was written in quickbasic 7. I don't know enough to know how to do what i what. I've tried Try Dim test As String test = "33333oH@33333oH@" Dim Result As Double Result = Convert.ToDouble(test) ...Show All

• Visual Studio Express Editions I really need a piece of advice...

  Hello again. I am really wavering. I am a developer, windows applications, not web. Until now I used VB6 to build client side user friendly applications. Server side usually are DCOM VC++6 applications (we develop laboratories and quality systems for manufacture). Now I have to develop a new client application, and I would like to try VB2005: I downloaded the express edition to evaluate it. Of coarse I have a lot of code, and tested user interface modules developed in VB6: MDI & treeview interface, graphs and statistics with National Instruments components, reports with excel library, etc. I tried the wizard to convert it to VB2005, but ...Show All

• SQL Server Associating Report Viewer (without UI) with Data Set

  Hello all - I am looking to use the ReportViewer Control to automatically print out some client based reports. I started with the "Print a report from a console app" sample from http://www.gotreportviewer.com/ . I have managed to convert an existing server based report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I believe I have also successfully passed in the correct parameters to the sproc, but now I need to associate this new Data Set with the RDLC re ...Show All

• SQL Server How can I restore a database from a UNC?

  It appears that Management Studio will not allow you to perform a restore from a UNC path. Is this true or am I missing the option to open the magic UNC door I am very new to SQL2005 and this was buried in SQL2000, but it was possible to do in Enterprise Manager. Not to be snotty, but you didn't answer the question. Your point is taken, there are other ways to do this. I can use a script to restore from a UNC path. I am still interested in getting an answer to the question I posted, not to the underlying assumption that I am looking for any way to accomplish a restore from UNC. As a DBA, I do many operat ...Show All

• .NET Development DAO Wrapper: Field is DBNull after Addnew and throws error

  First a quick bit of background. I have a legacy app that is written in VB6 using DAO. We are slowly migrating to .Net. DAO is a problem going forward, but we do not have the time (or $$) to rearchitect using ADO/ADO.Net. We decided to write a set of abstract VB.Net classes that present the DAO interface - this will allow us to implement concrete classes using any physical DB engine that we choose to use in the future. I currently have implemented the abstract DB interfaces as well as a concrete implementation for Jet. This works pretty well, as I simply pass through any call to the DAO equivalent. However, I've recently come across a ...Show All

• Windows Forms Expander Control (from TaskVision)

  Hi, I downloaded the TaskVision Source, to reuse the Expander Control.. I modified the buttons to collapse/expand the control as they were a little to low compare to the header bar, but now, I want to improve the collapse/expand behaviour. I want it to progressively expand/collapse the control. Actually, it only shows/hides directly the control. I want a beautiful&nb ...Show All

• Microsoft ISV Community Center Forums When to program in VBA and when not to???

  Hello Guys and Gals I have to make a presentation about VBA, and one question I need to answer is when to program and when not to program in VBA. That is, I sure will not program a Find function, since there is one built-in, and it does a great job. But I sure would want to write code that would enhance the Find function and make it look in multiple worksheets. What other examples of when not to program can I use Thanks for any help. Wassim Don't bother programming a sort routine in Excel, unless it's a way to automate the sort to allow worksheet sorting of more than three fields. Jon Peltier, Microsoft ...Show All

• .NET Development Cannot view XML input using XSL style sheet

  Yeah! I've got VS 2005.  So I built a new WebPage on a remote machine.  It has only one 'form' or page i.e. "default.aspx"  That page only has one button on it.  Code behind changes the button's color.  Publish site is successful.  However, when trying to view the site from a browser, I get: The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. Sounds like ASP.NET is not installed properly.  Make sure you've added the IIS windows component to your OS, then repair the .NET Frameworks.  That shou ...Show All

• .NET Development CommandBehavior.KeyInfo

  Hello, I have a connection using .Net Framework Data Provider for Oracle. When I try execute the follow statement: cmd.CommandText = "SELECT NOME, CI FROM (SELECT NOME, CI, ENDERECO FROM FUNCIONARIO) A"; conn.Open(); DbDataReader reader = cmd.ExecuteReader (CommandBehavior.KeyInfo); schema = reader.GetSchemaTable(); reader.Close(); conn.Close(); /******************************************************************************************/ System.InvalidOperationException was unhandled   Message="Syntax Error: Expecting identifier or quoted identifier."   Source="System.Data.OracleClient"   StackTrace:   &nb ...Show All

• Visual Basic form inheritance

  I want show the keyboard accelerator keys in all my forms, so I create a base form with that functionality, then I have other forms inherit from this base form,  the base form does not have any control on it,  when I step through the code, it works, but after removing the break point, it stops working.  I have to add a control (such as a button) on the base form and the Visible Property of the control must be true to make the functionality work for other forms, which is not desired. I am stuck here, any suggestion will be greatly appreciated.   ...Show All

• Visual Studio Express Editions Can´t register or create new User in Demo Project

  Hi! The application is running fine but I can’t create an admistrative user (or anything else). It always comes up with a red HTML-Dialog "Please enter a different password.". There must be some kind of error in here, because I can try whichever password I want, it won’t let me finish the registration. This happens in the basic application as well as in the ASP.NET Configuration > Security > Create User dialog. Any suggestions Bye, Brokit hi, I have the same problem and continue found a lot of other problems. Im from Brasil and i cant find the same valueable information in the msdn brasil. Thank yo ...Show All

• Smart Device Development Speeding up the emulator

  My emulator is working pretty nicely but it is really slow (I don't have anything installed on it). I tried to assign to it as much RAM as possible (current RAM available 17MB), but it still is slow. even a simple tap on the menu has a significant lag time. Is there a way to speed up the emulators performance Thanks. I notice that all post on this thread is pretty old. Is there some new development regarding the speed of the pocket PC. i.e. Using a pocket PC with a higher speed ex 400Mhz ...Show All