Mike Lapierre's Q&A profile

• SQL Server Auto Updates for SQL Server?

  Our IT guy insists that he must be present anytime the SQL Server automatic updates from Microsoft are installed on the server or the server will crash. What has he been tinkering with to cause this to happen or is he just giving us a line Well, I wouldn’t apply all patches to SQL Server without any notice ot testing. Normally the updates or patches don’t break the functionality of SQL Server. To be sure, I would test the patch on a testing server. If you have a WUS, you can setup the server to confirm the patch first before applying the patch on the SQL Server. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Software Development for Windows Vista CreateHandle method with C# on Windows Vista

  Hi All, yesterday I installed Vista on my computer and now I'm trying to compile and run some C# projects. I have an error while search the handle of a usercontrol; this is the error: Error creating window handle. Any idea Does Vista manages in a different way all this Thanx in advance Marcello I'm trying to get the handle of a UserControl with simply call this.Handle property of my usercontrol. Marcello   ...Show All

• SQL Server report position jumps horizontally on expanding

  I'm running into the following behavour of reporting services: My report has a horizontal scrollbar and I expand a collumn in order to drill down across a hierarchy. When I do that the report repositions itself horizontally in such a way that the node I expanded is exactly in the middle of the displayed part of the report. For users this is confusing because they expect the node they where looking at to stay at the same place, just as when there is no scrollbar. Has somebody noticed this behavior as well Is there a way to change or work around this behavior or must I just tell my users to live with it   Regards, Henk ...Show All

• SQL Server Transform-Pivot in SQL Server 2005

  Is there any equivalent for Transform-pivot of MS Access in SQL Server 2005 I have this query in MS Access that I need to migrate to SQL Server 2005 TRANSFORM Sum ( CD1 ([CheckAmount])) AS [The Value] SELECT "Total Amount of Checks" AS Type, tblResult.AccountNumber, tblResult.CheckDate, tblResult.Status, Sum ( CD1 ([CheckAmount])) AS Total FROM tblResult GROUP BY "Total Amount of Checks " , tblResult.AccountNumber, tblResult.CheckDate, tblResult.Status PIVOT IIf ( IsNull ([statusdate]), "Outstanding" , Format ([StatusDate], "Short Date" )); Table columns: Autonumber,AccountNumber ,C ...Show All

• Smart Device Development SetFilePointer Problem

  Hi I am new here. I am writing because I am having a problem I wasn’t able to resolve. I am using the SetFilePointer function in my mobile project. The problem arise when I try to test it in my emulator. The SetFilePointer function moves its pointer in the oposite direction. When I pass a positive value to the method, the file pointer moves backward. And when I pass it a negative one, it moves foward. This only happens when the dwMoveMethod it’s set to FILE_END. When I run the program in my ppc it works fine, just like the documentation explain. Maybe I am doing something wrong, does anybody have the same problem. I try to search in the forum and no post for SetFilePointer was found. Also, I not sure if this is the right forum to post. My ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Regarding D3DXSaveTextureToFile

  Hi, I am working on an application that captures streams from D3D applications and then replays them. While replaying we can dump information related to the frames of our interest. In order to dump we switch to software processing mode. Along with all the other information being dumped, we also dump textures in dds format using D3DXSaveTextureToFileA(FileName, D3DXIFF_DDS, pTexture, NULL); where pTexture = (LPDIRECT3DTEXTURE9) m_pTexObj->getIUnknown(); While doing this whenever Desc.Format = D3DFMT_A2W10V10U10 D3DXSaveTextureToFileA fails with the error message Direct3D9: (ERROR) :The format is not supported by this device. CreateRenderTarget/CreateDepthStencil failed Direct3D9: (ERROR) :Failure trying to create render-target I checke ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Begininer Needs Help

  Hi. I am very new to the programming scene, and am taking a High School Class currently which uses Visual Basic 6.0. As of right now we are still on Chapter 1, so I am still getting familiar with VB. I have never coded or programmed a game or program and I have no prior knowledge of it. I am very excited about getting XNA however. What would you guys suggest I look up or read up on in order to succesfully design games I planned on watching the C# Tutorial Videos but are those really neccesary Would they even help And I visisted LearnXNA.com but didnt know which video to watch first or if those would even help. And I tryed searching but couldnt find any written tutorials on this. How about a book So please, any tips would be greatly appreac ...Show All

• Software Development for Windows Vista Lockup

  Hi. I like CardSpace, and I have had it working since it came in Windows Updates. But today when I ran it (and I've tried a few times) It just sticks at "Please wait while Windows CardSpace loads". It doesn't do anything, except stick there and display the egg-timer cursor. My only way to get out of it (as Windows key doesnt work, ALT+F4 doesn't work, CTRL+ALT+DEL doesn't work, is to restart (I use the hardware reset button). Anyone know why it's locking up I have same problem. Cardspace locks up the system completely. Nothing works, can't get to windows desktop via 'windows' key, can't bring up task manager with ctl-alt-del. No cancel button on the cardspace splash screen.(The cardspace splash screen is not completely rend ...Show All

• Visual C# Converting a string to a 64 bit WEP KEY

  2 Questions: I have been trying to find a tutorial on this and even asked in other forums so far no luck. What I want to do is convert a string to a 64 bit hexadecimal WEP KEY For example: Text : "santa" 64 bit hex : "DA3011B523" I also have a form the user will enter data into I want to then have the form to to a website automatically tell it what part of the site to go to and then fill in the info and press the save button on the website, is this possible and if it is how do I do it. I'm pretty new to C# but would really like to get this going. Try here: http://www.codeproject.com/csharp/wepkey_generator.asp ...Show All

• Software Development for Windows Vista Conditional start of workflow

  I'm working on a workflow hosted in SharePoint 2007 ... is it possible to only start the workflow when a certain field of a document has a certain value How would you do this Start the workflow from an eventhandler Any other ideas Joris [http://jopx.blogspot.com] Hi Joris, I'm sure you'll get better advice on a SharePoint discussion group. See the SharePoint home page , the SharePoint news groups , or the SharePoint support home . Regards, Paul ...Show All

• SQL Server help regarding SQL connection

  i am developing a web application which requires a DB to store various data fields. Though i am familiar with both web development languages and SQL, I am having difficulty connecting DB to my web pages(jsp). Can any one help with ODBC/JDBC settings required regards sumit dagar i wanted to know if I have to change control panel->Administrative Tools->ODBC data sources settings.If yess then what would these settings be. regards Sumit Dagar ...Show All

• Visual C# Events problems.

  Hello, I try to make a class (called voltage) to use in a Usercontrol (called switch). I like to know when one of the propertys of the type voltage change by means of an event triggerd in the voltage class, and then trigger a event in the class switch to notify the user. (see also my last post) here is the code for the voltage class: FYI, I've found that first pasteing the copied code fragment into Word will "lock" the proper formatting. Then copy/paste into the forum box from Word and the code will retain it's proper format. Rhubarb ...Show All

• SQL Server Help translating Access SQL to T-SQL

  Can someone tell me what this Where clause (from MS Access) should be T-SQL Basically, if the value in the [reason] field contains 'DIST' then the row should return as long as the value in [movement] is greater than or equal to 1. Where IIf ( [reason] LIKE '%DIST%' , Val ( [movement] ),1 )>= 1 Thanks! Thanks anomolous! That was the right answer. I just had to change int to real because [movement] holds a decimal value. Yes, Val() in Access converts a string to a number And if it's NULL, Val() will return 0. Will Convert() return a 0 for a NULL value Or do I need to use a different function so that I get a 0 if [movement] holds a NULL value ...Show All

• Visual C# How do I rename the administrator on a given machine via c#(System.Management?)

  I've found a few bread crumbs, but i have not as of yet figured this out.. here's what i know. You're supposed to be able to do it using WMI via win32_useraccount.Rename, You can call WMI stuff in c# via System.Management. What I need is how to tie those two pieces of information togther to allow me to make the changes. Can anyone help Give me a few more breadcrumbs to follow Thanks,  Eric-   I was trying to look for this for you earlier but couldnt find one. the technet scripting guy article(s) did state that there was no way to rename an account in WMI since the Rename method does not exist in W2K. I also remember a previous colleague who I was with (who is a guru of infra ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Min. Requirements to PLAY

  hi, sorry if this is explained somewhere and i just can't find it... i can see the min. requirements to *develop* the games, but what are the min. requirements to *play* the games we develop i can't get my game to run on any machine but my own. either .net isn't there (and *won't* install either), or they're not running WinXP. it seems like getting our games out there isn't very easy. the funny thing is, my PC doesn't support XNA completely -- i can only draw sprites, no 3D stuff -- so i made a simple game that's only using sprites. that means even something this simple isn't running on any machine but mine ! it's going to be hard to generate interest in our games if noone else can play them... finally, shouldn't the "r ...Show All