Jeanvo's Q&A profile

• SQL Server What happens at midnight ?

  Everyday at just gone midnight, my MSSQL server won't accept connections. About 25 minutes later, it seems to be OK. There's no third party backup software running on this machine which is MSSQL server aware. Has anyone any suggestions as to why this might be happening The client app trying to use the db reports 17/10/2006 00:02:04 Email2DBServer Cannot open database "Email2DB" requested by the login. The login failed. From OpenLocalDatabase and there's an entry in the event log Event Type: Failure Audit Event Source: MSSQL$EMAIL2DB Event Category: (4) Event ID: 18456 Date: 17/10/2006 Time: 00:02:04 User: NAVIGATOR-BATH\navigator-service Computer: NAVIGAT2A Description: Login failed for user 'NAVIGATOR-BATH\navigator ...Show All

• Visual Studio 2008 (Pre-release) proper way to use BuildWindowCore params?

  In the following code, I'm attempting to make my own .NET 2.0 form act as a FrameworkElement. I'm having trouble in the BuildWindowCore function. As I understand it, I'm supposed to take my existing form and make it a child of the input HWND. I don't know how to take the hwndParent.Handle and turn that into a System.Windows.Forms. Control. I've stepped through the code a number of times trying different things includeing WINAPI SetParent all with no luck. It's too bad Wrapper is null. That would at least give me an idea as to what type of object it is. public class AppWindow : HwndHost { private AppForm _appForm; // AppForm inherits from System.Windows.Forms.Form public AppWindow( AppForm appForm) ...Show All

• SQL Server Login to SQL Server management studio

  Hi, I am facing a strange behavior during loging in to SQL server mangement studio. Whenever I install SQL server express, various protocols like Named Pipe and TCP/IP and SQL browser are disabled by default. But still I am able to log in to SQL Server throguh Management studio. But when I try to log in to SQL server throguh one of my applications, it allows me to log in to it only for one time. From next time onwards, I am not able to log in to SQL server neither through my application nor through Management studio. I connect to SQL server using "machine name"\"Instance name". Machine name is the name of machine on my office LAN. PS: Once this problem occurs, I can log in to SQL server if I use "loc ...Show All

• Gadgets brin gadget to front

  hi every body plz any one know a function to bring a gadget to front thanks There's no such function. Windows-Space brings the sidebar to the front, so you could in theory insert that in the keyboard buffer with some code. Something like AutoIt may work. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Shaders without effects on the 360

  According to the documentation, functions such as ShaderCompiler.CompileFromFile are only available when developing in windows. Does this mean that you cannot compile a shader without an effect on the 360 In order to incorporate an xna rendering mode into my engine, I really need to be able to do this. Ok, I actually found the documentation in question, but could use some clarification. The PixelShaderProcessor class there actually uses the windows only ShaderCompiler.CompileFromSource method. Is this class used at build time to compile the shader in windows, prior to sending the now compiled shader to the xbox ...Show All

• .NET Development System.Net.WebException

  I'm using the following function to try to determine how long it takes for a file to download from a webserver. private void btnDownload_Click(object sender, System.EventArgs e) { //**************************************************** Uri uri = new Uri(" http://cslibrary.stanford.edu/107/UnixProgrammingTools.pdf#search=%22unix%20filetype%3Apdf%22 "); System.Net.WebRequest wr = System.Net.HttpWebRequest.Create(uri); System.IO.Stream stream = wr.GetResponse().GetResponseStream(); int b; int counter=0; string strResult = string.Empty; DateTime BeforeDlTime = DateTime.Now; while ((b=stream.ReadByte())!=-1) { strResult += System.Text.UTF7Encoding.UTF7.GetString(new byte[] { (byte)b },0,1); ...Show All

• Visual Basic Sorting thru directories for files

  Dim dir As New IO.DirectoryInfo(NewPath) For Each dir In dir.GetDirectories(NewPath) For Each ImageFile In dir.GetFiles( "*.jpg" ) Next Next error: Second path fragment must not be a drive or UNC name. Parameter name: path2 I'm trying to search NewPath for directories (dir.get directories) and then get each file in each sub directories, (for each imagefile in dir.getFiles). There's a problem with the Get.Directories at runtime. There are other ways to do this, but I want to try using this way... Thanks Looks like your code should have been something like          Dim strFileList As String = "" ...Show All

• Visual Studio Documentation Compiler - Sandcastle

  We did code complete of documentation compiler ( code named "Sandcastle") on June 15th and currently we are testing the tool building our .NetFramework documentation. We would like to release the CTP version of Sandcastle in Microsoft download center by next week. The perf in our testing has been great as we are able to build the entire framework content in less than 1 hour. I am in the process of going through final check and code signing required to post this in our download center. Please expect the CTP in the next week or so and I will provide an update here as soon I post the CTP. Anand.. Thanks everyone for your posts. I have had several emails asking about CTP. There are couple places (download at our download cen ...Show All

• .NET Development Is an assembly the only possible target for an emitted method?

  I am wondering if there is any way to emit a method and its supporting metadata without having to create a full-fledged assembly I want to be able to emit individual methods on the fly and feel that it's rather heavy handed to create a whole assembly just for one method. What I would ideally like to do is emit the byte codes into a buffer that is part of another data structure and then pass that buffer's adress along with a pointer to appropriate metadata (which could contain metadata for multiple methods and data types) to a function that will jit-compile the method and execute it. Is there an interface that will let me do this -- that will let me separate the metadata I point to from the acutal executable byte code and submit them in se ...Show All

• SQL Server How tot select the most recent date

  I have 2 tables: 1) Item table (No_, Description) 2) Sales Price HAG table (Item No_, Sales Price HAG, Starting Date) I want to have a report within from every item the most recent sales price. But, it is possible that a unique item has more than 1 sales price in the 'Sales Price table' (if it has more than one Starting Date). I want to report the sales price with the most recent date. I've made this statement: SELECT [DatabaseName$Item].No_, [DatabaseName$Item].Description, [DatabaseName$Sales Price HAG].[Unit Price] FROM [DatabaseName$Item] INNER JOIN [DatabaseName$Sales Price HAG] ON [DatabaseName$Item].No_ = [DatabaseName$Sales Price HAG].[Item No_] ...Show All

• Software Development for Windows Vista sdk sample - boot image problems

  Using the sdk sample app: "C:\Program Files\Microsoft SDKs\Windows\v1.0\samples\winbase\storage\optical\imapi2sample" I tried taking the image from a boot cd (known to work). Then extracting the boot image. Then burning the data from the disc (temporarily copied to the hard drive) along with the boot image to create a new boot cdr. It does burn the disc (in separate attempts, I used both bbie and ultraiso to create the boot images) - but the disc will not boot a computer :-| The computer complains with: "CDBOOT: Couldn't find NTloader" Shouldn't this work Ok, thanks TonyMan and Henry. At least you can repro the problem (right ) It seems surprisin ...Show All

• SQL Server ODBC SQLFetch problem

  Hi, I have ODBC code reading data from a XLS file. It opens the file, reads the sheets and columns available, then presents a dialog to allow the user to select which columns are to be used to load the data. All of this works, almost. It is a simple "Select A,B,C FROM Sheet1" using SQLExecDirect When using SQLFetch it always skips the first row of data. Thanks, any ideas would be great. Keith Does SQLExecDirect fetch the 1st row for you Can you check the bind buffers to see they are filled with column data from the 1st row after SQLExecDirect before calling SQLFetch One more thing you might try is to move SQLBindCol after SQLExecDirect to see if that chang ...Show All

• Audio and Video Development Error Code: C00D1197 How do I fix it?

  It seems everytime I must remove and download the Window Media Player all the time and when I try to go to AOL and watch the TV site I keep getting this Error Code: C00D1197 Could someone explain this to me and how I might go about fixing it. Do I need to put on a patch Are there a site I can go to that can fix it Thank youall for your time and help with this. Take care and GOD bless. Here is the text for that error code: "Windows Media Player cannot find the file. If you are trying to play, burn, or sync an item that is in your library, the item might point to a file that has been moved, renamed, or deleted." Beyond that, this newsgroup isn't going to be so useful, since it's not about Windows Media Player. If you need m ...Show All

• SQL Server How to pass multi values to a report parameter?

  Hi, all experts here, Thank you very much for your kind attention. Could please any one here give me any guidance for how to pass multi values to a report parameter (I have check the box next to "allow muiti value" in the report parameter dialog box tho) I got the problem: each time only one value can be selected from the value list for the parameter. When I selected multi values for the parameter, I got the error: " An error occured during local report processing. Query execution failed for data set, incorrect syntax near ','." Please give me any guidance. Thanks a lot in advance and looking forward to hearing from you shortly. With best regards, Yours sincerely, Hi If you have mulity select ...Show All

• .NET Development How to monitor an I/O event from a separate process?

  I have a third party application that reads a file.  I am trying to create an new application that writes updates to the file after that 3rd party app reads it.  Is it possible to monitor file access from .NET on the O/S level to trigger my application to syncronize read and writes over time   How would you do it   If this is not possible, how would you solve this problem other than recreating the third party application (which is not realistically possible) I/O monitoring seems to be possible, as there are programs like http://www.sysinternals.com/Utilities/Filemon.html  that does it.  I just need to know how they hook into Windows and trigger an event ...Show All