How to import data from Excel 2007 xlsx file into SQL Server 2000 Database?
SQL Server 2000 doesn't seem to support the xml based .xlsx file types. Besides converting the file to a 97-2003 file type, how else can I achieve this? ...
windows
How to force restart a Windows box using VBScript?
I'm trying to find a way to force Windows to reboot, and I am running into issues. I've tried Set OpSysSet = GetObject("winmgmts:{authenticationlevel=Pkt," _ & "(Shutdown)}").ExecQuery("select * from Win32_OperatingSystem where "_ & "Primary=true") for each OpSys in OpSysSet retVal = OpSys.Reboot() next I've also tried...
Strip Windows DLL debug info?
I normally don't work on Windows development, and am completely unfamiliar with the toolchain and build system. My embedded product includes some Windows DLLs from a third party in its filesystem (which are used by a Windows machine which mounts the filesystem). I have a problem: the most recent release of these DLLs have tripled in siz...
Where can I find my .emacs file for Emacs running on Windows?
I tried looking for the .emacs file for my Windows install for Emacs but could not find it. Does it have the same filename under Windows as in Unix? Do I have to create it myself? If so, under what specific directory does it go? ...
IE6 generated strange worksheet name when doing export from java application
I am encountering error like test(10)[1].csv file cannot be found at C:\Documents and Settings\Ron\Local Settings\Temporary Internet Files\Content.IE5\PQ0STUVW When trying to do export of CSV file using the following codes. Anyone have any idea what could be wrong? This issue does not occur in IE7 / Firefox and is only specific to ...
Easiest way to front Weblogic 9.2 with apache 2.x
I want to put Apache 2.2.9 in front of a Weblogic 9.2 server on Windows XP. What does it take to do that ? I probably need mod_proxy on the apache side ? As far as Weblogic and apache are concerned, is there something similar to mod_jk ? I would like this setup so that I can introduce some filtering later on. But for now, the goal is...
Where and how does Windows XP store wep/wpa keys?
Like the title says Where and How (i.e. if encrypted, with what method) does Windows XP store WEP/WPA Keys? ...
Persisting an environment variable through ruby
I am trying to set my dos environment variable in ruby which persists after the script exits. For example if I want a ruby script set_abc_env.rb to set environment variable ABC to blah, I expect to have the following: C:> echo %ABC% C:> set_abc_env.rb C:> echo %ABC% blah How do I do this? ...
How to detect whether serial port is in use or not in .net
We have industrial automation application developed in .NET 3.5 framework. I have to list out the available serial ports in the computer for our user. As part this, if any of the serial port is already opened, I have to show "In Use" status. I tried google but no luck. Can someone help me please? Regards, Krishgy ...
Windows swapping redundantly?
This may not be strictly programming related but more OS-structure related. Running Vista 32 bit on a brand new laptop with 3GB of memory, Running idle the system consumes about 40% of its memory. Other then the fact that this is outrageous on its own right, the OS should be able to fit all of the processes nicely into memory and not ne...
Changing the width of a Windows console window?
Is it possible to programatically, or otherwise, increase the width of the Windows console window? Or do I need to create a wrapper program that looks and acts like the console somehow? Are there any programs around that do this already? I use cygwin extensively in my development, and it seems a little rediculous to me that all console w...
Drag and drop in winapi
I have a pure Winapi application that needs a few new features. One of them would best be implemented as two lists where you can drag-and-drop (multiple) elements between the lists. The new feature can be limited to a single dialog. What would be the quickest way to implement this? A few ideas: Pure Winapi (is it DetectDrag) A separat...
How does Windows actually detect LAN (proxy) settings when using Automatic Configuration
When Windows Internet Properties -> Connections -> LAN Settings -> Automatic Configuration is set to "Automatically detect settings" how does Windows actually determine/discover what the settings are? Is it a network broadcast or some kind of targeted query to a server configured somewhere in the registry, or something else? ...
How can I find the user's fonts in my .NET application?
How can I find the font that the user has set in their Windows Display Properties using C# in .NET? I want to display a form using the fonts that the user has selected. The fonts I want are those selected in the Windows Display Properties form for 3D-objects, menus and window title bars. But I cannot find a way to access them. There is...
How can I abort a long operation in WinDbg?
Often WinDbg will enter a state where it is *Busy* performing an operation. Often this is due to some mistake I made trying to *dt some_variable_itll_never_find* or setting a break point somewhere without symbols or the 1000's of other mistakes I make fumbling around this tool. Is there a way to cancel the current operation? ...
Windows equivalent of /dev/random
Is there a Windows equivalent of Linux's /dev/random? ...
Using a Windows Form with Ruby
Is it possible to create a form on Windows using Ruby? I have a Ruby script and I would like to have an input form to ask for a user's password, then use this in the rest of my script. update: I have successfully done this with wxRuby, although it looks ugly. Shoes looks promising, I might look into that if I need to do this again.. ...
How do I get console output in C++ with a Windows program?
If I have a native C++ windows program (i.e. the entry point is WinMain) how do I view output from console functions like std::cout? ...
Determining 64-bit vs. 32-bit Windows
I'd like to configure visual studio 2005 to copy .dll's based on whether the OS is 64-bit or 32-bit during a build. I do not want to specify what the platform target is. My first attempt was to use a batch file to lookup the Windows version, but some 32-bit and 64-bit versions of Windows share the same version number. Anyone know of...
In an MFC application, what's the easiest way to copy a file from one directory to another?
Should I create two CFile objects and copy one into the other character by character? Or is there something in the library that will do this for me? ...