Ashley Lessard's Q&A profile

• Visual Studio Just repair the installation

  I have installed a RC version of VS Team Suite along with full MSDN installation. After completing installation, I'v got " Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.MSDNQTR.v80.en' is invalid " error when I have tried to access it by doing "Start" -> "All Programs" -> "Microsoft Developer Network" -> "MSDN Library for Visual Studio 2005" When I accessed it from VS 2005, it only have SQL help available. I have tried to reinstall it several time but no luck. Any help would be appreciated. Eric I have exactly the same problem. Here's the scoop: Started a clean Virtual Machine (VMWare not MS since no USB support) Installed Window ...Show All

• SQL Server How to control format of datetime attributes?

  There is an attribute that have type DateTime, based on the field type in data source. It hasn't separate name column. The member caption is formatted as yyyy-MM-dd hh:mm:ss. Can I control the format of Member name without giving separate name column. I assigned different format in the format field of key property window, but it had no effect. What I did wrong Thank you, I thought about more sofisticated solution, that can be used in multi culture environment without adding x additional fields with "formatting" of a datetime attribute. I hoped, that the AS2005 is smarter as AS2005 and offers more possibilties. Do you know what is the format field in key properties for ...Show All

• Visual Studio Tools for Office Excel 2003 using VSTO

  Hi, Is it possible to check if there is a running instance of Excel and load a workbook into it, or if not invoke a new instance Also, it would be good to have some error-handling in case whatever running instance of Excel is tied up (e.g. printing for example or doing some large operation). I am using VS2005, VSTO, and Excel 2003. Thanks! Cindy Meister wrote: This part is early binding and you'd need to change it for late-binding. But you should take this discussion to another group to pursue the topic. Thanks! Any suggestions where exactly ...Show All

• SQL Server Using openrowset (bulk...) with Variable in Filespec

  Hello, to accelerate loading xml data from many files into a table using openrowset (bulk...) I want to use a variable in the file specification and increment it within a loop similar to this: declare @datnam varchar(100); DECLARE @MyCounter int; SET @MyCounter = 1; set @datnam = 'c:\XML_Daten\POS_LOG_200608_'+ltrim(str(@MyCounter))+'.xml'; INSERT INTO GK_TO_KFH_ADAPTER_XML_NS (LOC_ID, MSG_CONTENT) SELECT @MyCounter, MSG_CONTENT FROM ( SELECT * FROM OPENROWSET (BULK @datnam, SINGLE_CLOB) AS MSG_CONTENT) AS R(MSG_CONTENT) But I got the following error: Msg 102, Level 15, State 1, Line 8 Incorrect syntax near '@datnam'. Is there a way to this in that manner Or is the bcp utility an alternative Regards Peter ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. )

  I have a series of 2D coordinates which I'm wanting to multiply by a 90 degree rotation matrix to calculate their new positions. The coordinates are values such as 0,0 -1,0 1,0 and 1,0. I've seen two constructs in the XNA framework which might help me but I have a couple of questions I'm hoping someone can help me with. I'm thinking the best way to do it is to store my coordinates in Vector objects such as Vector2 myVector = new Vector(0, 1); and then multiply them by a Matrix object which is a 90 degree rotation matrix. I believe the matrix for a 90 degree rotation to the right would look like this: 0, -1 1, 0 The problem is, the constructor for the Matrix object takes 16 arguments (for a 4D matrix) and I'm not sure how to convert the ab ...Show All

• Visual Studio Express Editions Converting seconds to different times

  Hi, I'm making a program where you can type sec number. After pressing the CALCULATE button, the programs shows how much months, days, hours and minutes the given sec number is. I have public variable for all those times (months,days,hours,mins) but I can't make it work so that it first removes the bigger amount. This is just logical problem. I would like to have this: User writes in the seconds text-box: for example 3 000 000 The program tells (in the labels by the way): 1 month 4 days ect ect Thanks! You could put it in a button click event..if you want the user to initate the conversion Private Sub Button1_Click ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles ...Show All

• .NET Development Web Service client has "nothing" for result.

  I have a crazy situation where I'm hitting a web service (written in Java), with a client I'm writing in VB (2005, with ASP 2.0)... the return type from the web method is a complex data type (not that complex - just has four different strings). It is consistently returning "nothing" when I call the web method. Here's the thing: I can hit the same web service with XML Spy sending in the same information, and that works just fine. I also used a sniffer tool and was able to see that my client is indeed receiving the correct response back from the server via HTTP... it's just that Dot Net is losing it somehow and by the time it gets back to my VB code, it says there's "nothing" there. (Argh!) Has anybody hit a situati ...Show All

• Visual Basic non-modal error

  hello, I have a C# application that calls a VB form in a referenced DLL. The problem is, when I try to run the application on its own, I get an error about how non-modal forms can't be displayed. However, if I have the VB file open and run the dll, the error doesn't come up. Does anyone know what could cause this to happen thanks for any help I'm using frmConnect.Show vbModal, Me to show the form. The error I'm getting is "Non-modal forms cannot be displayed in this host application from an ActiveX DLL, ActiveX Control, or Property Page. The error in C# comes when it tries to do something with the object that cannot connect because the form's error stopped it. ...Show All

• SQL Server Error while trying to get predictions from relational DB

  I am trying to get predictions and insert them into a DB table. Following is the code I am using , but I am getting an error saying ' An error occurred while preparing the query , Pl. help. begin declare @v_query varchar(5000); declare @full_query varchar(5000); declare @v_dbquery varchar (200); set @v_dbquery = char(39)+'SELECT [ProspectAlternateKey], [FirstName], [LastName], [MaritalStatus], [Gender], [YearlyIncome], [TotalChildren], [NumberChildrenAtHome], [HouseOwnerFlag], [NumberCarsOwned] FROM [dbo].[ProspectiveBuyer]'+char(39); set @v_query = 'SELECT [TM_Cluster].[Bike Buyer], t.[ProspectAlternateKey], PredictProbability([TM_Cluster].[Bike Buyer]) From [TM_Cluster] P ...Show All

• SQL Server Administrative Tasks

  Can anybody tel me what are the most administrative tasks/strategy. What do professional administrators to maintain sql databases. I hope for your answer. michael ...Show All

• Software Development for Windows Vista Writing to HKLM

  I'm using the RTM release of Windows Vista and testing my application to see if it will run on Vista as a standard user. I'm seeing some strange behaviour and I'm wondering if anyone can help me figure this out. My application writes some data to HKLM\Software. I was expecting to see this write getting redirected to the VirtualStore when running as a Standard user. However, that does not seem to be happening. My app is able to write to HKLM\Software. My app is not running with elevated privileges and Virtualization is ON. I even tested my app with the Standard User Analyzer tool thinking it would possibly show me some errors when writing to registry but nothing showed up there either. Strangely enough, I see the same behavior when running ...Show All

• Software Development for Windows Vista IE7 just hangs my box - Vista RC1 (b 5536)

  I switched to FireFox 2.0b2 and its extremely fast. When I try browsing through Internet Explorer 7, my machine just hangs. It takes at-least 10 seconds for IE to start - when it takes just few milliseconds for the FireFox to start. Is anyone else having the same problem Thanks. Sekhar. im afraid these are the incorrect forums for your question. The best place to ask would be the appropriate IE newsgroups over at: www.microsoft.com/communities Thanks! ...Show All

• Visual Studio Custom Smart tags

  Im trying to create a DualList control for .net 2.0 in visual studio 2k5 that would be able to use the smart tag to setup the datasource. I want to know if its a. possible and b. if there are tutorials that I must have overlooked in my search. thanks in advance! Yes, you can create a control that has a smart tag. You can find a walk through at http://msdn2.microsoft.com/en-us/library/ms171829.aspx . ...Show All

• Visual Basic MsgBox always return "no" regardless of what the user click

  I am using VS2005 and have a messagebox inside of an event that does not work properly. The code is below: If Microsoft.VisualBasic.MsgBox( "Do you want to save your changes" , MsgBoxStyle.YesNo) = MsgBoxResult.No Then Exit Sub End If The problem is regardless of whether the user clicks Yes or No, it always returns No. If I add another MsgBox in the code immediately before the if statement, then the if statement will always work properly. (see code below) Microsoft.VisualBasic.MsgBox( "Dummy MsgBox" ) If Microsoft.VisualBasic.MsgBox( "Do you want to save your changes" , MsgBoxStyle.YesNo) = MsgBoxResult.No Then Exit Sub End If I can't figure out what is wrong h ...Show All

• Visual Studio Using a non-standard paper format using printToPrinter in CR for VS2005

  Hi. I'm working on a asp.net Intranet application, and I must print label on a network label printer. There's is no preview, the print job is sent by the server directly to the printer. So far I can print, but I have to made my label format the default format in the printer driver, and that's bugging me. The label are 4in by 2in which is not one of the predefined format in CrystalDecisions.Shared.PaperSize. I want to be able to define the paperSize before calling PrintToPrinter. The CR support web site tell this : ...It is possible to design a report in the Crystal Reports Designer specifying a custom paper size. Once this report is created, it looks and prints as expected on the computer it was designed on. When this same report is ...Show All