Question: How can I release all existing database locks for all the sessions a specific user has started? Answer: The easiest way probably is to log that user out. Otherwise,

Question: I have been receiving the following (albeit general) error sporadically: “Microsoft OLE DB Provider for ODBC Driverserror ‘80004005’ [Informix][Informix ODBC Driver]General error.” This error has occurred when the code

Question: I have a parameterized SQL statement like the following: “insert into eSession (ESessionID, eUserName, eLastActivityTime) VALUES(?,?,?)” It’s parameters are ‘bbb’,’name’ and ‘2000/01/01 22:23:25′, using an ODBC connection. I can’t

Question: Outbound messages are being delayed randomly. You can send them to the same host—sometimes they don’t queue up long enough to even see. Other times they are there for

Question: Is there a command-line way to back up my Exchange databases without stopping the services, like the GUI can? Or, for that matter, is there any automated method of

The ADO Recorset object exposes a hidden, undocumented member: the Collect property. This property is functionally similar to the Field’s Value property, but it’s faster because it doesn’t need a

Question: What is the purpose of using the fetch and declare cursor in Informix.4GL?How do you use the scroll cursor, and what are its advantages? Answer: Cursors allow you to

Question: My ace report/shell script did not wait for user intervention. I have solved that with: script.sh < mytty > mytty But now the screen needs refreshing with a CTRL-R.

Question: How can I place my Exchange Server on a network with private addresses and have my MX record point to the server even though the server is behind a

Question: I have a Windows 2000 server where I have installed the Exchange Server 5.5 Service Pack 3. I want to do a backup, but the Exchange option is empty

Question: How can I redirect mail sent to a particular mailbox to an external address? Answer: Outlook 2000 has the ability, in the Rules Wizard, to redirect mail. You’ll find

Question: I’ve tried to create a table (for my guestbook) with an auto increment column. Here’s my statement: CREATE TABLE guestbook(id mediumint(8) NOT NULL KEY(PRI) default(0) auto_increment, name varchar(30) NOT

Question: I have about 50 users on an “old” Exchange Server (version 5.0 SP2), and I need to move them to a new server. The problem is that the new

Question: This weekend I did a restore of my Information store. I had to do a repairmidway through. This morning, a few people have told me they can’t opensome mail

I came across this solution while trying to embed an applet in an XSL page I was using to transform my XML source document into HTML.If you want to cut

Private Declare Function FindWindow Lib “user32” Alias “FindWindowA” (ByVal _ lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hwnd

‘ Returns an array and initializes it with passed data.” It is similar to the Array function, but it works with’ array of any type. The type of the returned

Many VB developers use a class module to augment the capabilities of a control on a form. For example, consider this simple example, that formats a currency value in a

If you want to execute an application and waiting for its termination, you can follow two approaches. The “classic” approach is based on API functions such as OpenProcess, WaitForSingleObject and

You can retrieve the length of a standard windows media file (WAV, AVI or MIDI) using simple MCI functions. First, you must open the file with: Declare Function mciSendString Lib

The simplest way to help user copy a floppy disk is display the Copy Disk system dialog. You can do this with a one-line statement: Shell “rundll32.exe diskcopy.dll,DiskCopyRunDll 0,0”

Private Declare Function GetDesktopWindow Lib “user32” () As LongPrivate Declare Function GetDC Lib “user32” (ByVal hWnd As Long) As LongPrivate Declare Function ReleaseDC Lib “user32” (ByVal hWnd As Long, _

Question: I’m working with ASP to retrieve records, but I keep getting an “Unexpected Error” near my recordset function. Why? Answer: Pinpointing exactly what’s wrong would be hard without actually

Question: What is the best Backup Software available that will do a live backup of the Exchange Information Stores? Answer: I haven’t evaluated all of them, but we’ve been satisfied

Question: Can I include something in the title line of a query to include the current date/time? Answer: You can use the GETDATE() function to return the current date and

Question: I created a “help” button in a form and coded this button’s click event as: { help } The code { set help to MyHelp.chm }is included in the

Question: Suppose I wanted to setup the IIS 4.0 to process the WML with ASP codes. Which MIME type should I configure: text/vnd.wap.wml or text/x-wap.wml? What is the difference between

Question: About how fast can the current wireless systems transmit a medium- to high-resolution digital photo? What’s currently the best way to do it? Will higher baud rates of wireless

Question: How do I link an Oracle (8i) database to pull and push data from WML decks? Answer: An XML parser is available in Oracle8i. Oracle is developing a product

Question: How do I create an Application Setup Wizard from Visual FoxPro? Answer: VFP ships with a Setup Wizard, which builds three different types of installations: Standalone, Network, and Web.